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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
