Re: [BUGS] Recovery.conf PITR by recovery_target_time

2013-08-14 Thread ascot.m...@gmail.com
pg_xlog_replay_resume(); pg_xlog_replay_resume --- (1 row) mpaquier=# create table bb (a int); CREATE TABLE Et voila! On Mon, Aug 12, 2013 at 7:34 PM, ascot.m...@gmail.com ascot.m...@gmail.com wrote: - check tables from psql: postgres

[BUGS] Recovery.conf PITR by recovery_target_time

2013-08-12 Thread ascot.m...@gmail.com
Hi, I have tried following test cases about PITR: a) Time and events on Master : 16:32:03 HKTBegin; CREATE TABLE test22 (id INTEGER PRIMARY KEY); INSERT INTO test22 VALUES (generate_series(1,22)); End; Commit; 16:35:02 HKTBegin; CREATE TABLE test23 (id

Re: [BUGS] Enable WAL Archive in Replication server

2013-08-12 Thread ascot.m...@gmail.com
Thanks so much. On 12 Aug 2013, at 6:45 AM, Michael Paquier wrote: On Mon, Aug 12, 2013 at 1:53 AM, ascot.m...@gmail.com ascot.m...@gmail.com wrote: I want to enable WAL archive on the replica, I am advised that WAL archive can only be enabled on the Master, can you please advise

[BUGS] Enable WAL Archive in Replication server

2013-08-11 Thread ascot.m...@gmail.com
Hi, I want to enable WAL archive on the replica, I am advised that WAL archive can only be enabled on the Master, can you please advise if this is a bug and any workaround available? regards now you can only enable WAL archive on the Master server,it will not take effect on replication