Re: [ADMIN] pg_dump and pg_dumpall is hanging

2007-03-12 Thread Glen W. Mabey
On Sun, Mar 11, 2007 at 08:14:38AM +0530, Rajesh Kumar Mallah wrote: > have you used the verbose option by adding a couple of -v with > pg_dump or pg_dumpall ? try it it may give a hit > > regds > mallah > > On 3/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote: > >Hi, > > > >I am using

Re: [ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-12 Thread Glen W. Mabey
On Fri, Mar 09, 2007 at 06:29:21PM -0500, Tom Lane wrote: > "Glen W. Mabey" <[EMAIL PROTECTED]> writes: > > What I see is a bunch of stuff related to the Acquisitions table, > > including a relation for the primary key, which was created back when > > the tabl

Re: [ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-09 Thread Glen W. Mabey
On Fri, Mar 09, 2007 at 08:51:44PM +, Greg Sabino Mullane wrote: > > Hash: RIPEMD160 > > > > > > When I SELECT any records from a certain table ("Acquisitions"), I get: > > > > > > > acqlibdb=> select * from "Acquisitions"; > > > > ERROR: relation "Acquisitions" does not exist > ..

Re: [ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-09 Thread Glen W. Mabey
> basic table? > M.b. it'll point you to the actual table location. > > Igor > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Glen W. Mabey > Sent: Friday, March 09, 2007 12:01 PM > To: Tom Lane > Cc: PostgreSQL

Re: [ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-09 Thread Glen W. Mabey
On Fri, Mar 09, 2007 at 11:01:08AM -0600, Glen W. Mabey wrote: > On Fri, Mar 09, 2007 at 11:41:23AM -0500, Tom Lane wrote: > > "Glen W. Mabey" <[EMAIL PROTECTED]> writes: > > > When I SELECT any records from a certain table ("Acquisitions"), I

Re: [ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-09 Thread Glen W. Mabey
On Fri, Mar 09, 2007 at 11:41:23AM -0500, Tom Lane wrote: > "Glen W. Mabey" <[EMAIL PROTECTED]> writes: > > When I SELECT any records from a certain table ("Acquisitions"), I get: > > > acqlibdb=> select * from "Acquisitions"

[ADMIN] problem upgrading from 8.1.6 to 8.1.8 --- relation does not exist

2007-03-09 Thread Glen W. Mabey
Hello, After upgrading from 8.1.6 to 8.1.8 (using Debian testing packages) I started to get a really strange error, and I have not been able to gain any insights into this from the list archives. When I SELECT any records from a certain table ("Acquisitions"), I get: acqlibdb=> select * from