This is a discussion on restore from pg_dumpall within the pgsql Admins forums, part of the PostgreSQL category; --> When restoring from a pg_dumpall file, is it best to delete the contents of the data folder, run intitdb ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin |