Re: [GENERAL] Problem with database connections timing out for long-running queries

2015-08-24 Thread Rich Schaaf
Schaaf Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem with database connections timing out for long-running queries You might check the stunnel settings. A quick search of "stunnel 12-hours" indicates that this is the stunnel default for idle connections. Chee

Re: [GENERAL] Problem with database connections timing out for long-running queries

2015-08-21 Thread Steve Crawford
You might check the stunnel settings. A quick search of "stunnel 12-hours" indicates that this is the stunnel default for idle connections. Cheers, Steve On Fri, Aug 21, 2015 at 11:16 AM, Rich Schaaf wrote: > I’m running into a problem where the connection between application its > database is

Re: [GENERAL] Problem with database connections timing out for long-running queries

2015-08-21 Thread Adrian Klaver
On 08/21/2015 11:16 AM, Rich Schaaf wrote: I’m running into a problem where the connection between application its database is timing out after 12 hours. Here’s the context: ·Two servers (one running the application and another hosting the database) in the Amazon AWS environment on different su

[GENERAL] Problem with database connections timing out for long-running queries

2015-08-21 Thread Rich Schaaf
I'm running into a problem where the connection between application its database is timing out after 12 hours. Here's the context: . Two servers (one running the application and another hosting the database) in the Amazon AWS environment on different subnets within a virtual private cl

[GENERAL] Problem with database

2004-12-21 Thread lothar . behrens
Hi, I had a crash with my hdd and now I have recovered the database with the directory found in lost and found. Now I get an error, if I try to open the database admin tool PGAdmin III: cannot open relation pg_amop What is missing ? Coul'd this corrected ? Thanks Lothar -

Re: [GENERAL] Problem with database: FATAL 1: cannot find attribute 24

2001-09-17 Thread Tom Lane
"Tauren Mills" <[EMAIL PROTECTED]> writes: > Then, I try running postgres like this: > bash$ postgres -d 5 -D /var/lib/pgsql/data dans_pgsql > AATAL 1: cannot find attribute 24 of relation Since there aren't any system catalogs with as many as 24 columns, the problem is clearly a level or two do

Re: [GENERAL] Problem with database: FATAL 1: cannot find attribute 24

2001-09-16 Thread Justin Clift
Hi Tauren, Have you found the solution for this yet? It really sounds like part of your customer's database has been deleted or gone missing. Which version of PostgreSQL are you using, and which operating system is it on? :-) Regards and best wishes, Justin Clift Tauren Mills wrote: > > S

[GENERAL] Problem with database: FATAL 1: cannot find attribute 24 of relation

2001-09-14 Thread Tauren Mills
Sorry for cross-posting this to both admin and general. I first posted to admin, but as I'm desperate here and there is more activity in the general list, I'm now posting it here as well. --- Help! One of my customers is having a problem with their database causing all of their sites to be dow