On 04/30/2015 07:03 AM, Charlton Galvarino wrote:
So what is your archive_command?
archive_mode = on
archive_command = 'cp -v %p /var/lib/pgsql/archives/%f'
archive_timeout = 300
So where does the rsync you mentioned previously fit into this?
Where is the listing below from?:
The below listing was warm_standby: /var/lib/pgsql/archives/
-rw------- 1 postgres postgres 16777216 Apr 29 05:07
00000001000010E5000000EA
-rw------- 1 postgres postgres 16777216 Apr 29 05:11
00000001000010E5000000EB
-rw------- 1 postgres postgres 16777216 Apr 29 05:15
00000001000010E5000000EC
-rw------- 1 postgres postgres 16777216 Apr 29 05:15
00000001000010E5000000ED
-rw------- 1 postgres postgres 16777216 Apr 29 05:15
00000001000010E5000000EE
-rw------- 1 postgres postgres 12337152 Apr 29 05:20
00000001000010E5000000EF
-rw------- 1 postgres postgres 16777216 Apr 29 05:25
00000001000010E5000000F0
-rw------- 1 postgres postgres 16777216 Apr 29 05:30
00000001000010E5000000F1
# warm_standby:/var/lib/pgsql/data/recovery.conf
restore_command = 'pg_standby -l -d -s 2 -t /tmp/pgsql.trigger /var/lib/pgsql/archives %f %p %r 2>>standby.log'
I do not see an -l option in the 8.4.x version of pg_standby, I do see
it in the 8.3 version.
Where are you getting pg_standby from?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
