Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group