Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
On Apr 8, 2013, at 5:52 PM, Tatsuo Ishii wrote: >> 2013/4/9 Tatsuo Ishii : While debugging this with a coworker we figured out that pg_ctl was attaching to the tty and then it clicked that we needed to be using '-t' where I was using -T or (neither). >>> >>> Are you sure? I chec

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread Tatsuo Ishii
> 2013/4/9 Tatsuo Ishii : >>> While debugging this with a coworker we figured out that pg_ctl was >>> attaching to the tty and then it clicked >>> that we needed to be using '-t' where I was using -T or (neither). >> >> Are you sure? I checked the pg_ctl source code and could not find any >> place

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread Ian Lawrence Barwick
2013/4/9 Tatsuo Ishii : >> While debugging this with a coworker we figured out that pg_ctl was >> attaching to the tty and then it clicked >> that we needed to be using '-t' where I was using -T or (neither). > > Are you sure? I checked the pg_ctl source code and could not find any > place attachi

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread Tatsuo Ishii
> While debugging this with a coworker we figured out that pg_ctl was attaching > to the tty and then it clicked > that we needed to be using '-t' where I was using -T or (neither). Are you sure? I checked the pg_ctl source code and could not find any place attaching to the tty. -- Tatsuo Ishii S

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
On Mon, Apr 08, 2013 at 04:24:45PM -0700, David Kerr wrote: - On Mon, Apr 08, 2013 at 02:59:56PM -0700, David Kerr wrote: - - On Mon, Apr 08, 2013 at 02:09:42PM -0700, David Kerr wrote: - - - On Mon, Apr 08, 2013 at 02:14:14PM -0600, Quentin Hartman wrote: - - - - What version of pgpool are you usi

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
On Mon, Apr 08, 2013 at 02:59:56PM -0700, David Kerr wrote: - On Mon, Apr 08, 2013 at 02:09:42PM -0700, David Kerr wrote: - - On Mon, Apr 08, 2013 at 02:14:14PM -0600, Quentin Hartman wrote: - - - What version of pgpool are you using? - - - - - - Are there other commands you have a problem with? I

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
On Mon, Apr 08, 2013 at 02:09:42PM -0700, David Kerr wrote: - On Mon, Apr 08, 2013 at 02:14:14PM -0600, Quentin Hartman wrote: - - What version of pgpool are you using? - - - - Are there other commands you have a problem with? I would suspect that the - - restart is causing the postgres server to

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
On Mon, Apr 08, 2013 at 02:14:14PM -0600, Quentin Hartman wrote: - What version of pgpool are you using? - - Are there other commands you have a problem with? I would suspect that the - restart is causing the postgres server to go away, pgpool decides to - disconnect, and then it has to be manuall

Re: [GENERAL] AWS and postgres issues

2013-04-08 Thread Quentin Hartman
What version of pgpool are you using? Are there other commands you have a problem with? I would suspect that the restart is causing the postgres server to go away, pgpool decides to disconnect, and then it has to be manually added back to the cluster. Unless of course you've got automatic failback

[GENERAL] AWS and postgres issues

2013-04-08 Thread David Kerr
Howdy, I'm having a couple of problems that I believe are related to AWS and I'm wondering if anyone's seen them / overcome them. Brief background, I'm running PG 9.2.4 in a VPC on Amazon Linux. I'm also (attempting) to use PgPool for load balancing/failover. The overall problem is that it seem