From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |
Date: | 2010-11-02 21:37:33 |
Message-ID: | AANLkTim8CUiUktQnW6zw9TwExG-eJdoMG5DiL3rw0kx-@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Nov 2, 2010 at 10:53 AM, Steve Clark <sclark(at)netwolves(dot)com> wrote:
> mv /var/lib/postgres/data /var/lib/postgres/data.old
Before I move or rename '/var/lib/postgres/data', what version of
PostgreSQL should I be at? 8.4 or 9.0?
> You will then have to do an initdb to create the basic 9.x databases.
> You can then use psql or pg_restore depending on how you dumped
> your data to restore your databases.
I simply ran the following command:
/usr/bin/pg_dump finance > finance.sql
> With fedora you use either:
> /etc/init.d/postgresql initdb
> or
> service postgresql initdb
> to initialize the 9.x database system.
Sadly that command didn't pan out for Arch Linux:
# /etc/rc.d/postgresql initdb
usage: /etc/rc.d/postgresql {start|stop|restart}
From | Date | Subject | |
---|---|---|---|
Next Message | Leif Biberg Kristensen | 2010-11-02 21:50:16 | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |
Previous Message | Aljoša Mohorović | 2010-11-02 21:33:35 | Re: postgres videos - copyright issues or something else? |