Where can I find an example shell script and windows batch file for
archive_command for backup?
Thanks.
Jack
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The document recommends a command as below:
archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || cp
-i %p /var/lib/pgsql/archive/%f < /dev/null'
How can this be done using windows batch? I tried the following
command, but it did not work:
archive_command = 'if not exist C:\\pgsql\\b
Hi,
I try to set the statement_timeout so that "select pg_stop_backup();"
will not hang if archive command failed. Below are the command and
errors.
psql.exe" -d mydb -h myhost -p 5432 -U postgres -w -c "set
statement_timeout = 1000; select pg_stop_backup();"
WARNING: pg_stop_backup still waitin
* From: Jun Wang
* To: pgsql-general@postgresql.org
* Subject: set statement_timeout does not work
* Date: Mon, 29 Mar 2010 19:33:55 -0700
* Message-id:
Hi,
I try to set the statement_timeout so that "select pg_stop_backup();"
will not hang if archive command f
