restore from pg_dumpall - Mailing list pgsql-admin

From Marc Fromm
Subject restore from pg_dumpall
Date
Msg-id 81FEAB8CDDC62B42B6E8AA258228BC8804DB3B9B@EVS2.univ.dir.wwu.edu
Whole thread Raw
List pgsql-admin
When restoring from a pg_dumpall file, is it best to delete the contents
of the data folder, run intitdb to recreate it, and then do the command
"psql -U postgres -f backupfile postgres"?

When I do the restore over top of what is in the data folder already,
there are many errors reported.

Thanks

Marc Fromm
Information Technology Specialist II
Financial Aid Department
Western Washington University
Phone: 360-650-3351
Fax:   360-788-0251


pgsql-admin by date:

Previous
From: Meetesh Karia
Date:
Subject: Re: Encoding problems with migration from 8.0.14 to 8.3.0 on Windows
Next
From: Carol Walter
Date:
Subject: Database conversion type serial question