On Mon, Aug 5, 2013 at 10:29 AM, Jorge Torralba <jorge.torralba@xxxxxxxxx> wrote: > I have a primary and secondary running streaming replication with 9.2. > Primary posgresql.conf file is slightly different than standby server conf > file. If i create the trigger file to force the standby into primary mode, > is there a way to make the new primary server use a different config file > configured for a primary after it becomes the primary besides shutting it > down and loading the new primary config file? Unfortunately, there is no such a way. > Or can we just leave it > running as a primary using the config file it used as a standby? Yes, you can. You can also use the same config file for standby as on the master if you does not do anything that requires a specific configuration on standby, of course. -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@xxxxxxxxx -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin