Hi Greg,
Yeah, thanks a lot. Works perfect. The correct perl code is:
my $backupargs = sprintf("-f \"%s\" -F p --clean -U postgres -h
localhost %s", $backupfile, $DBName);
Cheers
Thomas
Am 09.06.2011 22:16, schrieb Greg Sabino Mullane:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Michael Holt wrote:
1) I've seen things about using pg_current_xlog_location(),
pg_last_xlog_replay_location(), pg_last_xlog_receive_location() to
check replication status, but how can this tell me either the time lag
or actual query lag? Do I need to wait for 9.1 and it's replication
monitori
-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
Hi everyone,
I try to do scheduled backups with a perl script on a windose box. For
some reason this does not work and I am to stupid to see the reason why.
Maybe there is somebody out there who can help me.
Here is the relevant part of my perl script:
my $tm = localtime();
my $backupfile =
Hello !
Is there a parameter usable to close connections after a timeout (like
statement_timeout for the statements) ?
Thanks
Joby