On Tue, 2013-09-24 at 08:59 -0500, John DeSoi wrote:
On Sep 24, 2013, at 5:48 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote:
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 Sep 25, 2013, at 8:36 AM, Guillaume Lelarge guilla...@lelarge.info wrote:
Your config file and your debug logs don't match. Your config file says
that the restore command is rsync, but your logs say its pg_standby.
Check if you have a pg_standby process on the slave. That would explain
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
On Sep 24, 2013, at 5:48 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote:
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.
On the primary I have
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
On Sep 23, 2013, at 11:20 AM, John DeSoi de...@pgedit.com wrote:
Am I missing something obvious? Do I have to back up the primary again to
make this change?
you didn't mention a pg_hba.conf rule. did you add one for the replication
user?
--
Sent via pgsql-general mailing list
On Sep 23, 2013, at 1:00 PM, Ray Stell ste...@vt.edu wrote:
Am I missing something obvious? Do I have to back up the primary again to
make this change?
you didn't mention a pg_hba.conf rule. did you add one for the replication
user?
You mean on the primary, right? Yes, I have one
On Sep 23, 2013, at 1:00 PM, Ray Stell ste...@vt.edu wrote:
Am I missing something obvious? Do I have to back up the primary again to
make this change?
you didn't mention a pg_hba.conf rule. did you add one for the replication
user?
You mean on the primary, right? Yes, I have one
On Sep 23, 2013, at 4:47 PM, John DeSoi wrote:
You mean on the primary, right?
right
Yes, I have one there. But even if I did not, I would expect to see a
connection error in the log on the standby. No error or any indication the
streaming replication process is running on the standby.
On 9/23/2013 9:30 PM, Ray Stell wrote:
On Sep 23, 2013, at 4:47 PM, John DeSoi wrote:
You mean on the primary, right?
right
Yes, I have one there. But even if I did not, I would expect to see a
connection error in the log on the standby. No error or any
indication the streaming
10 matches
Mail list logo