restore from pg_dumpall

From: "Marc Fromm" <Marc(dot)Fromm(at)wwu(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: restore from pg_dumpall
Date: 2008-03-13 18:41:41
Message-ID: 81FEAB8CDDC62B42B6E8AA258228BC8804DB3B9B@EVS2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-03-14 15:05:57 Database conversion type serial question
Previous Message Meetesh Karia 2008-03-13 18:06:31 Re: Encoding problems with migration from 8.0.14 to 8.3.0 on Windows