When I restore from a pg_dumpall file, I am required to peform the following
steps or else all the records in the databses are duplicated. If I only empty
the data/base folder I get al sorts of errors. I find in necessary to wipe the
entire data folder and rebuild it with initdb. Is there a better way to restore
using a pg_dumpall file then doing all these steps:
* stop postmaster service
* delete everything in the data folder
(var/lib/pgsql/data)
* as postgres user run initdb
* exit postgres user
* psql -U postgres -f pg_dumpall_file postgres
thansk
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
