Re: Relation 'pg_largeobject' does not exist

From: Brandon Keepers <bkeepers(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Relation 'pg_largeobject' does not exist
Date: 2006-03-24 15:41:29
Message-ID: 1143214889.28903.20.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

On Fri, 2006-03-17 at 23:48 -0500, Tom Lane wrote:
> "Brandon Keepers" <bkeepers(at)gmail(dot)com> writes:
> > If it makes a difference, when I un-tar the dump file from each failed
> > dump, it always has 2937 files in it.
>
> That's pretty consistent with the idea that you're running out of
> locktable space --- you'd expect that to fail at a certain number of
> dumped blobs.
>
> However, this makes me wonder whether you really did successfully
> increase max_connections as I suggested; that should have had at least
> some impact. 7.0 is far enough back that I don't remember exactly where
> one sets the maximum number of backends in that version --- better
> double-check the docs for 7.0.
>
> regards, tom lane

The 7.0 docs revealed that I needed to start up postmaster with "-N
300". I tried to get the admin of the box to do that, but it kept
failing at exactly the same spot. I ended up just having the admin of
the server send me a copy of the data directory, and I compiled 7.0.3
myself and it worked beautifully.

Thanks a lot for your help!

Brandon

In response to

Browse pgsql-general by date

  From Date Subject
Next Message roman.motyka 2006-03-24 15:44:57 Re: ADO.NET ExecuteReader returns no rows
Previous Message Ian Harding 2006-03-24 15:16:49 Re: PostgreSQL 8.1 v. Oracle 10g xe