From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-admin@postgresql.org
Cc: pub@bednarz.ch
Subject: Re: calling pg_dump from perl
Date: Thu, 9 Jun 2011 20:16:24 -0000
Message-ID: <ec9569b32dcf5f893370c314391a91a8@biglumber.com> (raw)
In-Reply-To: <4DF11C79.2000505@bednarz.ch>
-----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@turnstep.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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@turnstep.com, pub@bednarz.ch
Subject: Re: calling pg_dump from perl
In-Reply-To: <ec9569b32dcf5f893370c314391a91a8@biglumber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox