Skip site navigation (1) Skip section navigation (2)

Re: pg_user does not exist

From: Bethany A(dot)Benzur <bethany(at)rawkawn(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_user does not exist
Date: 2004-02-23 15:56:09
Message-ID: CBD81D83-6618-11D8-A7B5-000A957A02C8@rawkawn.com (view raw or flat)
Thread:
Lists: pgsql-admin
Tom,
I only see this in pg_clog:

[root(at)steel data]# ls pg_clog/
0000

No, I had not been running Vacuum on a regular interval. :( I just 
added "vacuumdb --all" to my daily cron, though...


On Feb 22, 2004, at 6:04 PM, Tom Lane wrote:

> "Bethany A.Benzur" <bethany(at)rawkawn(dot)com> writes:
>> Argg... I guess I won't be rebuilding template1 from template0 seeing
>> as I have no template0!! :(
>
>> template1=> UPDATE pg_database SET datallowconn = TRUE
>> template1-> WHERE datname = 'template0';
>> UPDATE 0
>
> Hm.  I'm beginning to think you've got a transaction counter wraparound
> issue.  What filenames do you have in $PGDATA/pg_clog/ ?  How long has
> this database been running, and have you been doing full-database
> VACUUMs at regular intervals?  (See the "routine maintenance" section 
> of
> the Admin Guide for background.)
>
> 			regards, tom lane
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


In response to

pgsql-admin by date

Next:From: Oli SennhauserDate: 2004-02-23 18:12:01
Subject: Re: FW: FW:
Previous:From: Lamar OwenDate: 2004-02-23 15:35:38
Subject: Re: 7.4.1 binary for RH9?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group