Postgres downgrade

From: Norman Uittenbogaart|Webminded (norman_at_webminded.nl)
Date: 09/23/04

  • Next message: Ari Suutari: "Re: Postgres downgrade" 
    Date: Thu, 23 Sep 2004 11:02:50 +0200
To: freebsd-stable@freebsd.org

    I upgraded my postgres without dumping my data and reimport them, so now
    my database won t start,

    > [root@cp root]# /usr/local/etc/rc.d/010.pgsql.sh start
    > pgsqlFATAL: database files are incompatible with server
    > DETAIL: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.2.

    Now how can I downgrade from Postgres 7.4.2 back to Postgres 7.3 without
    loosing my data ?
    Would a make install in /usr/ports/databases/postgresql73 be sufficient ?

    Please help !!!

    Norman Uittenbogaart
    _______________________________________________
    freebsd-stable@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-stable
    To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"

  • Next message: Ari Suutari: "Re: Postgres downgrade"

    Relevant Pages

    • Re: Reading million records
      ... How can I get same performance as FoxPro using Postgres or any other database? ... FoxPro is what is called an ISAM DB - or a double-linked list manager - or in our common language - a "desktop database". ... Postgres is a SQL DB server and those beasts works only on the 'network' - it really doesn't matter where the client actually is - especially in the Postgres case. ...
      (borland.public.delphi.non-technical)
    • Re: Reading million records
      ... How can I get same performance as FoxPro using Postgres or any other database? ... Postgres is a SQL DB server and those beasts works only on the 'network' - it really doesn't matter where the client actually is - especially in the Postgres case. ...
      (borland.public.delphi.non-technical)
    • Re: Microsoft to certify and support SUSE Linux !
      ... Then they will have to give it away and open source it. ... SQL Server integration looks like a weak hack. ... Postgres certainly is. ... MS-SQL Server would not be a huge market for MS on Linux; ...
      (borland.public.delphi.non-technical)
    • Problem with postgresql and need to fix it in the next release
      ... I install FC3 on a server with SELINUX=enforcing and ... I install postgresql and do initdb with the user postgres ... This user must also own the server process. ...
      (Fedora)
    • Re: Secure Postgres access
      ... I would like to access a remote Postgres server from a Python program in a ... Both Postgres and the Python program are running on Linux. ... you put their pubkey in authorized_keys on the server for SSH connection. ...
      (comp.lang.python)