From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | pub(at)bednarz(dot)ch |
Subject: | Re: calling pg_dump from perl |
Date: | 2011-06-09 20:16:24 |
Message-ID: | ec9569b32dcf5f893370c314391a91a8@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> COMMAND: E:\PostgreSQL\8.4SS\bin/pg_dump.exe -f
> //nas-tb/DBBackups/PostgresDBBackup_TB-WS_misdwh_20110609151147.bak -F p
> --clean -U postgres -h localhost misdwh
...
> The interesting thing is, that it asks for a password for a database
> named "TB". Only god knows where that comes from! The name of my
> database is 'misdwh' and as can be seen on the command is passed as last
> parameter.
I would guess that TB is coming from the underscore in the filename.
Try quoting the entire argument to -f like so:
E:\PostgreSQL\8.4SS\bin/pg_dump.exe
-f "//nas-tb/DBBackups/PostgresDBBackup_TB-WS_misdwh_20110609151147.bak"
-F p --clean -U postgres -h localhost misdwh
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106091615
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAk3xKfEACgkQvJuQZxSWSsgyVACfQhuu35ITUETQ9aGT0muPrGb+
fnsAnRrfEaMdBNcou9UVvln0EpxYfvHf
=SNZ6
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-06-10 04:02:36 | Re: Streaming replication status and fail over questions |
Previous Message | Thomas Bednarz | 2011-06-09 19:18:17 | calling pg_dump from perl |