This question has been flagged
1 Reply
7291 Views
databasebackuprestore
Avatar
Lars

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.

Avatar
Discard
sridhar

This DB is in which format. like .sql or .dump or .backup,

Lars
Author

The DB is in .DUMP format ( the built in way)

sridhar

http://stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line try this way it will help full for you.

Avatar
Francisco Martínez
Best Answer

If you have a problem with "database manager" method, you can try with this:

DUMP DataBase from source server:

pg_dump -f oe-mydatabase_backup.sql mydatabase_name

RESTORE on destination server:

psql -f mydatabase_backup.sql mydatabase_name

You need remember if have a custom addons then need copy the server files.

Avatar
Discard