I have been using the built in DB backup/restore interface in OE for the last 9 months with no problems. My main application is in LINUX and my backup application is running on a Windows servers. Up to now I have used the built in backup function to create the dump file and I have restored it on my windows application to test it.
Now for no obvious reason I get an error message in a small window in the center of the screen stating "Restore Database Could not restore database OK" At the same time I see the text I am used to see up in the right corner "Restored Database restored"
At this point I can not restore any of the backups that I have been able to restore in the past.
Does anyone have any idea what have happened? I have not done any changes to the install as far as I know.
This DB is in which format. like .sql or .dump or .backup,
The DB is in .DUMP format ( the built in way)
http://stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line try this way it will help full for you.