Re: [ADMIN] calling pg_dump from perl

2011-06-09 Thread Thomas Bednarz
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

Re: [ADMIN] Streaming replication status and fail over questions

2011-06-09 Thread Greg Smith
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

Re: [ADMIN] calling pg_dump from perl

2011-06-09 Thread Greg Sabino Mullane
-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

[ADMIN] calling pg_dump from perl

2011-06-09 Thread Thomas Bednarz
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 =

[ADMIN] Close jdbc connection

2011-06-09 Thread Joby Joba
Hello ! Is there a parameter usable to close connections after a timeout (like statement_timeout for the statements) ? Thanks Joby