John DeSoi wrote: > I have a 9.2.4 (CentOS 6.5) standby that has been working with no problems > using log shipping. I > wanted to add streaming replication which I thought would be as simple as > adding primary_conninfo to > recovery.conf and restarting the standby. But on restart there is no message > or error about connecting > to the primary for replication. pg_stat_replication is empty on the primary > and I don't see any errors > on the primary either. > > Here is what I have on the standby: > > postgresql.conf > > hot_standby = on > max_wal_senders = 2 > wal_level = hot_standby
You should set the same parameters on the primary, else it won't work. > recovery.conf > > standby_mode = 'on' > trigger_file = '/pgsql/9.2/data/failover.trigger' > primary_conninfo = 'host=localhost port=21333 user=postgres' > restore_command = 'pg_standby -t /pgsql/9.2/data/failover.trigger > /shared/pgbackup %f %p %r' > archive_cleanup_command = 'pg_archivecleanup /shared/pgbackup %r' > > > I have a ssh tunnel setup on localhost and have verified the replication user > can connect to the > primary. > > Am I missing something obvious? Do I have to back up the primary again to > make this change? No, that shouldn't be necessary. What are the messages in the secondary's log after you start it? 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