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 se
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 INTEGER
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
> 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 if th
r
> (1 row)
> And only table aa exists.
>
> Here is more input after resume xlog replay.
> mpaquier=# create table bb (a int); -- Node is still in read-only mode
> ERROR: 25006: cannot execute CREATE TABLE in a read-only transaction
> LOCATION: PreventCommandIfReadO
