From: | "Tim Penhey" <tim(at)penhey(dot)net> |
---|---|
To: | "postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: File System Restore |
Date: | 2004-06-20 08:16:39 |
Message-ID: | HOEPLDNJPCIDBMLHJFMIMEIMELAA.tim@penhey.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Scot L. Harris wrote:
>
> I just recently upgraded from 7.2.4 to 7.4.2 postgresql. What I did was
> a pg_dumpall to save my databases. Then after the upgrade I did a
> pg_restore using the saved dump file. Worked perfectly for me.
>
> After I installed the new version of postgresql I did a initdb to setup
> the new database cluster then a started postgresql. After that I ran a
> psql -d template1 -f databasebackupfile. The databasebackupfile was
> created from the pg_dumpall. This recreated all my tables and loaded
> the data.
>
> Very easy and clean.
>
> Not sure you can just copy the file systems around like you describe.
This has been a bit of a point of confusion for me.
When do you use pg_restore vs. psql -f dumped.sql?
Thanks
Tim
From | Date | Subject | |
---|---|---|---|
Next Message | NTPT | 2004-06-20 12:12:18 | Relocation error pg_dumpall undefined symbol get_progname in 7.4.3 |
Previous Message | Scott Marlowe | 2004-06-20 05:56:28 | Re: administering files, data type "file" |