Re: How sync settings or extensions in streaming replication

On Wed, Jul 6, 2016 at 11:37 AM, 苏士涛 <tinnnysu@gmail.com> wrote:
> I am new to PostgreSQL, and i have a question about streaming
> replication. If i enable some extension on master with or without
> native code(in c), do I need to enable this extension on slave? Or
> PostgreSQL sync this automatic. Same to settings in postgresql.conf.

You don't need to enable it on the slave. The command CREATE EXTENSION
generates some WAL, so it would get replayed on the standby node as
well. If you are using synchronous_standby_names, you are sure as well
that the WAL of this CREATE EXTENSION command has been flushed to disk
on the standby, so it would not be lost in case of a master crash.
--
Michael