On Mon, Jun 23, 2008 at 12:55 AM, rockyp <rockyp(at)rockyp(dot)com> wrote:
> I have looked at prior messages on this topic, but haven't been able to get
> my restore to work.
> I am doing a backup on my client's server (I've tried, PLAIN, COMPRESSED,
> SCHEMA/DATA only).
> I then copy the file to my PC and want to restore here. I've tried the
> restore in PGAdmin, but the restore option is disabled. Or I try to restore
> the PLAIN versions, and again it is disabled. If I rename the .backup to
> .sql, I can load the SQL script, but it fails immediately.
> I guess my questions are....
> 1) Obviously, what are the steps to do a successful restore on a different
Make sure the are appropriate versions of pg_dump/pg_restore can be
found. Check the path under File -> Options. That should ensure the
backup/restore options are enabled when you select an appropriate
object in the tree.
> 2) If I restore over my existing (old) DB, do I need to empty the tables, or
> delete and recreate the DB first?
I'd create a new database. In the next major release there will be a
'clean' option though so you will be able to load over an existing
EnterpriseDB UK: http://www.enterprisedb.com
In response to
pgadmin-support by date
|Next:||From: Dave Page||Date: 2008-06-23 08:00:10|
|Subject: Re: Error set CLRF in SqlEditor on Windows|
|Previous:||From: rockyp||Date: 2008-06-22 23:55:57|
|Subject: Backup/Restore problem (Windows) - newbie|