On Wed, Jul 6, 2016 at 11:37 AM, 苏士涛 <tinnnysu@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
