X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4D344D1B9E5 for ; Sun, 22 Feb 2004 23:04:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 79356-10 for ; Sun, 22 Feb 2004 19:04:03 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 6146DD1B901 for ; Sun, 22 Feb 2004 19:04:00 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1MN42Tf019267; Sun, 22 Feb 2004 18:04:02 -0500 (EST) To: "Bethany A.Benzur" Cc: pgsql-admin@postgresql.org Subject: Re: pg_user does not exist In-reply-to: <34FBD90C-6243-11D8-9862-000A957A02C8@rawkawn.com> References: <9B5FE928-61A5-11D8-9862-000A957A02C8@oit.gatech.edu> <20288.1077077160@sss.pgh.pa.us> <2E59D325-621C-11D8-9862-000A957A02C8@oit.gatech.edu> <34FBD90C-6243-11D8-9862-000A957A02C8@rawkawn.com> Comments: In-reply-to "Bethany A.Benzur" message dated "Wed, 18 Feb 2004 13:49:39 -0500" Date: Sun, 22 Feb 2004 18:04:02 -0500 Message-ID: <19266.1077491042@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/326 X-Sequence-Number: 12500 "Bethany A.Benzur" 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