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

Backup/Restore problem (Windows) - newbie

From: rockyp <rockyp(at)rockyp(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Backup/Restore problem (Windows) - newbie
Date: 2008-06-22 23:55:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
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,

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

2) If I restore over my existing (old) DB, do I need to empty the tables, or
delete and recreate the DB first?

I have PG Admin 1.8.2 at the client site, and 1.8.4 here. Both sites are
using PGSQL 8.3.0.

View this message in context:
Sent from the PostgreSQL - pgadmin support mailing list archive at


pgadmin-support by date

Next:From: Dave PageDate: 2008-06-23 07:53:52
Subject: Re: Backup/Restore problem (Windows) - newbie
Previous:From: Соболь А.Е.Date: 2008-06-20 11:21:27
Subject: Re: Error set CLRF in SqlEditor on Windows

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