Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Oct 10, 2015, at 3:44 PM, Adrian Klaver wrote: > > On 10/10/2015 12:02 PM, Chuck Martin wrote: >> >>> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 02:27 PM, Chuck Martin wrote: > On Sep 5, 2015, at 4:29 PM, Adrian Klaver > wrote: > > On 09/05/

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Adrian Klaver
On 10/10/2015 12:02 PM, Chuck Martin wrote: On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: On 09/05/2015 02:27 PM, Chuck Martin wrote: On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: On 09/05/2015 11:00 AM, Chuck Martin wrote: I had added to my pg_hba.conf hostreplication r

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread John R Pierce
On 10/10/2015 12:02 PM, Chuck Martin wrote: I only find one version of pg_basebackup on the replicant server, but CentOS 7 comes with PG 9.2, so I suspect that pg_basebackup is left over from that installation. But I’m not sure how to update that. yum update pg_basebackup did not work. try,

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: > > On 09/05/2015 02:27 PM, Chuck Martin wrote: >>> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 11:00 AM, Chuck Martin wrote: > I had added to my pg_hba.conf hostreplication rep 64.

Re: [GENERAL] Trouble setting up replication

2015-09-05 Thread Adrian Klaver
On 09/05/2015 02:27 PM, Chuck Martin wrote: On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: On 09/05/2015 11:00 AM, Chuck Martin wrote: I had added to my pg_hba.conf hostreplication rep 64.207.10.121/32 cert From the above the only user that can use replication connecting

Re: [GENERAL] Trouble setting up replication

2015-09-05 Thread Chuck Martin
> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: > > On 09/05/2015 11:00 AM, Chuck Martin wrote: >> Thanks for responding Adrian. >> >> After writing this, I noticed that the list is configure to reply to sender. >> I hope this is not inappropriate. Please tell me if I should re-send >> chan

Re: [GENERAL] Trouble setting up replication

2015-09-05 Thread Adrian Klaver
On 09/05/2015 11:00 AM, Chuck Martin wrote: Thanks for responding Adrian. After writing this, I noticed that the list is configure to reply to sender. I hope this is not inappropriate. Please tell me if I should re-send changing the address to the list. The best way to do it is to use Reply

Re: [GENERAL] Trouble setting up replication

2015-09-05 Thread Adrian Klaver
On 09/04/2015 04:07 PM, clmar...@theombudsman.com wrote: I have been trying to set up "hot standby" replication, but have run into problems, and hope someone here can help. I have configured an ssh tunnel from a computer that is not on a public IP, and was unable to figure out how to run pg_base