On Tue, Mar 3, 2015 at 04:55:56PM +0300, Vladimir Borodin wrote: > OK, hmmm. Thanks for testing. It feels like you didn't have your new > master set up for streaming replication when you ran pg_upgrade. Is > that correct? Should I specify that specifically in the instructions? > > > After running pg_upgrade I do put in new PGDATA on master old pg_hba.conf and > postgresql.conf with wal_level = hot_standby. The full content of > postgresql.conf could be seen here - http://pastie.org/9995902. Then I do > rsync > to replica, put recovery.conf and try to start both - first master, then > replica. If I turn off hot_standby in replica configuration, it starts. What > am > I doing wrong?
After running initdb to create the new master, but before running pg_upgrade, modify the new master's postgresql.conf and change wal_level = hot_standby. (Don't modify pg_hba.conf at this stage.) I didn't think that was necessary, but this might be some 9.3-specific problem, but let's get it working first. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
