[ADMIN] PSQLException: ERROR: could not open relation with OID xxxx

2011-03-11 Thread Gnanakumar
Hi, We're using PostgreSQL v8.2.3. Ours is a web-based application, language is Java and we're using pgpool-II v 2.0.1 purely for connection pooling (we don't use other features of pgpool like Replication, Load Balancing, etc.). We're running a complex report as explained below. Sometimes, the

Re: [ADMIN] pg_upgrade with link option

2011-03-11 Thread Robert Treat
On Thu, Mar 10, 2011 at 1:30 PM, Bruce Momjian wrote: > Mark Johnson wrote: >> export PGPORT1=5432 >> export PGPORT2=5432 >> export PGDATA1=/pgdata1/test >> export PGDATA2=/pgdata1/test >> export PGBIN1=/pghome/9.0.2/bin >> export PGBIN2=/pghome/9.0.3/bin ISTM you need to change the pgdata and pg

Re: [ADMIN] pg_upgrade with link option

2011-03-11 Thread Bruce Momjian
Robert Treat wrote: > On Thu, Mar 10, 2011 at 1:30 PM, Bruce Momjian wrote: > > Mark Johnson wrote: > >> export PGPORT1=5432 > >> export PGPORT2=5432 > >> export PGDATA1=/pgdata1/test > >> export PGDATA2=/pgdata1/test > >> export PGBIN1=/pghome/9.0.2/bin > >> export PGBIN2=/pghome/9.0.3/bin > > I

Re: [ADMIN] Listen on IPv6 only

2011-03-11 Thread Bruce Momjian
Gilberto Castillo Mart?nez wrote: > > > El jue, 10-03-2011 a las 15:33 -0500, Bruce Momjian escribi?: > > Dyonisius Visser wrote: > > > On 10 March 2011 21:03, Bruce Momjian wrote: > > > > > > > OK, let's skip documenting this then. ?They can already do this via > > > > pg_hba.conf. > > > > >

Re: [ADMIN] PSQLException: ERROR: could not open relation with OID xxxx

2011-03-11 Thread Kevin Grittner
"Gnanakumar" wrote: > We're using PostgreSQL v8.2.3. That version is over four years old, and there have been 17 minor releases for 8.2 containing nothing except fixes for bugs and security issues since then. It's asking a lot to expect other people to remember every single bug fixed over the