Re: File System Restore

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