From: | "Richard Harris" <Richard_Harris(at)adp(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Execute pg_dump using psql |
Date: | 2004-08-12 19:25:23 |
Message-ID: | D6EE939FB590D84CB70371C2CB8CA34C1AE7B7@nexus.plaza.ds.adp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm trying to use the psql application to execute pg_dump to backup a
database named test_db. When I run psql interactively, as user dba
connected to database test_db, and enter the command
\! pg_dump -U dba -f /backup/adp_test_db.bak -F c test_db
The command executes with no error and the database gets backed up.
However, when I put the command in the file /backup/backup.cmd and pass
the file to psql as
psql -f /backup/backup.cmd test_db dba
The command fails with the message " does not exist database
"test_dbdatabase "test_db.
Please tell me what I am doing wrong.
Thanks,
Rich Harris
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-12 21:17:28 | Re: redhat Ent3 et postegresql v7.4.3 |
Previous Message | Samuel Abreu de Paula | 2004-08-12 18:02:30 | Lost permission after get "out-of-space" in the partition! |