Re: pg_user does not exist - Mailing list pgsql-admin

From Bethany A.Benzur
Subject Re: pg_user does not exist
Date
Msg-id CBD81D83-6618-11D8-A7B5-000A957A02C8@rawkawn.com
Whole thread Raw
In response to Re: pg_user does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom,
I only see this in pg_clog:

[root@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@rawkawn.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
>


pgsql-admin by date:

Previous
From: "Derek Dilts"
Date:
Subject: psql command to find open statements
Next
From: Anthony Raj
Date:
Subject: How to Recover From Accidental Deletes ?