June 22nd, 2008, 01:53 PM
Backup/restore through PGAdmin not working
I use PGAdmin to do a backup, Plain, with no options checked. When I try to do a restore from the .backup file, the "OK" button is gray.
Here's more info... I want to copy the DB from my client's PC to mine. I do the Backup on the client's server, copy the .backup file to my PC, and try to restore. It's not possible. If I try the restore on my client's server, it, too, is unavailable.
Do I need to delete the DB on the target machine? I hoped it would just overwrite the old DB.
I'm rather a newbie...
June 22nd, 2008, 02:02 PM
So I figured "That must be it. I need to delete the DB first."
I did, the OK is still gray, and now I have no database!! But I do have a backup, and my client's machine is still okay, so I'm not dead - yet!
June 22nd, 2008, 03:18 PM
Found the answer on another forum - PGAdmin won't restore a "plain" backup...