On Sep 25, 2013, at 8:36 AM, Guillaume Lelarge 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
> why the slave neve
On Tue, 2013-09-24 at 08:59 -0500, John DeSoi wrote:
> On Sep 24, 2013, at 5:48 AM, Albe Laurenz 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 paramete
On Sep 24, 2013, at 5:48 AM, Albe Laurenz 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
wal_level
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 me
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 str
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 stan
On Sep 23, 2013, at 1:00 PM, Ray Stell 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 there.
On Sep 23, 2013, at 1:00 PM, Ray Stell 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 there.
On Sep 23, 2013, at 11:20 AM, John DeSoi 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 (pgsql-general@postgres
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 connec
10 matches
Mail list logo
