Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to backup my company PostgreSQL database using pgAdmin III, so I selected our company DB from the tree, then right clicked on it and selected 'Backup', selected the destination folder for the backup file then clicked OK. Then I got this error message:

C:/Program Files/PostgreSQL/9.0/bin\pg_dump.exe --host localhost --port 5432 --username "pgres1" --format tar --blobs --encoding UTF8 --verbose --file "E:\DB_Backup\DB_Backup_TEST.backup" \"CompanyDB_TEST\" pg_dump: [archiver (db)] connection to database ""CompanyDB_TEST"" failed: FATAL:  database ""CompanyDB_TEST"" does not exist
pg_dump: *** aborted because of error

Process returned exit code 1.

So can someone please help me by telling me what I am doing wrong here?

I am 100% sure that CompanyDB_TEST do exist.

I am running the PostgreSQL under Windows Server 2003

share|improve this question
Are you sure the name is CompanyDB_TEST rather than companydb_test? – mu is too short Apr 4 at 17:25

migrated from stackoverflow.com Apr 4 at 20:51

1 Answer

up vote 0 down vote

I seem to remember that there has been a pgAdmin version that sometimes generated an incorrect commandline for pg_dump and it looks like the quoting around the DB name is not right. Could you try the following from the command line?

"C:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe" --host localhost --port 5432 --username pgres1 --format tar --blobs --encoding UTF8 --verbose --file "E:\DB_Backup\DB_Backup_TEST.backup" CompanyDB_TEST
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.