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: (view raw or whole 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.


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-2015 The PostgreSQL Global Development Group