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] Buffers: shared hit/read to shared_buffers dependence

2015-09-05 Thread Albe Laurenz
Pavel Suderevsky wrote: > When I have been passing through "Understanding explain" manual > (http://www.dalibo.org/_media/understanding_explain.pdf) > I've faced some strange situation when table with size of 65MB completely > placed in cache with shared_buffers=320MB and it doesn't with shared_b

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

Re: [GENERAL] Any thoughts on a better approach to this query?

2015-09-05 Thread Marc Mamin
>?Formatted query attached in addition to placing it inline. The commentary is >inline with the query. Basically I've already solved this problem but was >wondering if someone has a different perspective; or simply observations. > >TIA, > >David J. > >/* >For a given id there are multiple linke

Re: [GENERAL] error on online backup using pg_basebackup tool

2015-09-05 Thread David Steele
On 9/3/15 5:07 PM, Joseph Kregloh wrote: > You can always move the folder out of there. Depending on the version of > PostgreSQL different steps need to be take. If I remember correctly for > version 9.3 you can move the symlink to point to the new directory. Pre > 9.3 you need to move the symlink