Thread: Backup/Restore problem (Windows) - newbie
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 PC? 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. Thanks, Rocky -- View this message in context: http://www.nabble.com/Backup-Restore-problem-%28Windows%29---newbie-tp18060565p18060565.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Mon, Jun 23, 2008 at 12:55 AM, rockyp <rockyp@rockyp.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 > PC? 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 database. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
I downloaded the backup today from a different location, and the restore was just fine. I must have had problems at my first location getting a good download. The file is about 78 Mb - I guess too big for my wireless...? Anyway, thanks for your suggestions, Dave. Rocky Dave Page-7 wrote: > > On Mon, Jun 23, 2008 at 12:55 AM, rockyp <rockyp@rockyp.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 >> PC? > > 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 > database. > > > -- > Dave Page > EnterpriseDB UK: http://www.enterprisedb.com > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support > > -- View this message in context: http://www.nabble.com/Backup-Restore-problem-%28Windows%29---newbie-tp18060565p18073601.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.