archive_mode=on on a Slave in streaming replication mode

Started by James Sewellabout 13 years ago2 messagesgeneral
Jump to latest
#1James Sewell
james.sewell@lisasoft.com

Hello,

As per the topic is it possible to set archive_mode and archive_command on a
server which is configured as a streaming replication hot standby?

I've tried and it doesn't seem to work, so I'm guessing maybe it's disabled.

Cheers,
James

--
View this message in context: http://postgresql.1045698.n5.nabble.com/archive-mode-on-on-a-Slave-in-streaming-replication-mode-tp5744666.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: James Sewell (#1)
Re: archive_mode=on on a Slave in streaming replication mode

james.sewell wrote:

As per the topic is it possible to set archive_mode and archive_command on a
server which is configured as a streaming replication hot standby?

I've tried and it doesn't seem to work, so I'm guessing maybe it's disabled.

It works fine, only the server will not generate WAL while
it is in recovery. As soon as you promote the standby,
it will archive ist WALs.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general