X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 00898D1B1D1 for ; Wed, 21 Jul 2004 03:11:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32285-05 for ; Wed, 21 Jul 2004 06:11:03 +0000 (GMT) Received: from my.mu.edu.ph (unknown [203.177.157.4]) by svr1.postgresql.org (Postfix) with ESMTP id 406D4D1B179 for ; Wed, 21 Jul 2004 03:10:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by my.mu.edu.ph (Postfix) with ESMTP id 373A47378A for ; Wed, 21 Jul 2004 14:24:13 +0800 (PHT) Received: from my.mu.edu.ph ([127.0.0.1]) by localhost (my.mu.edu.ph [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06807-01 for ; Wed, 21 Jul 2004 14:24:09 +0800 (PHT) Received: from localhost (my.mu.edu.ph [203.177.157.4]) by my.mu.edu.ph (Postfix) with ESMTP id 3A83E73787 for ; Wed, 21 Jul 2004 14:24:09 +0800 (PHT) Received: from 203.177.157.7 ([203.177.157.7]) by sulat.mu.edu.ph (IMP) with HTTP for ; Wed, 21 Jul 2004 14:24:09 +0800 Message-ID: <1090391049.40fe0c0920ede@sulat.mu.edu.ph> Date: Wed, 21 Jul 2004 14:24:09 +0800 From: Howard Bagcat To: pgsql-admin@postgresql.org Subject: Re: Invalid User ID: 0 References: <1090372445.40fdc35da9a55@sulat.mu.edu.ph> <20040721051914.GB32649@localhost.localdomain> In-Reply-To: <20040721051914.GB32649@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.2 X-Virus-Scanned: by amavisd-new at my.mu.edu.ph X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/234 X-Sequence-Number: 14302 > What account is the postmaster service running under? Postgres or someother account? Not postgres but a different account. The same username used during the "initdb" process. As for your information, the said account/username can get into any of my local database without problems. Only yesterday when I tried to connect to template1 or to any local database that it displayed the "Fatal: Invalid User ID: 0" for some reason that I dont know of. Is there any way we can execute a user-defined BKI so we could probably add new account in both pg_shadow and pg_user? > What version of postgres and windows is this running on? I am using postgresql 7.4 on top of Cygwin 2.416 running under Win 98SE. Kumusta, Howard. > > I am troubled on logging on to my postgresql running under Cygwin. Postmaster says, "Fatal: Invalid User ID 0" after > connecting. I > > know for sure that the username that I am using to log is existing. Thinking that having a new user will solve the problem, > I > > tried creating a new user but same error was displayed. I tried working on psql in the hope that I can connect to postgresql > but > > the same has occured. > > > > I checked the Postmaster if it can determine the availability of the database in the system catalog by logging on to a > > non-existing database and the Postmaster says, "Fatal: database "foo" does not exist in the system catalog". But as I tried > to > > connect to an existing database, "Invalid User ID 0" showed up. It seems to me that pgsql users' database have been > corrupted. > > > > BTW, postmaster started without errors. > > > > Your guiding ideas and tips are highly appreciated. > > > > PS. The database that I am trying to connect to is a production database working for 3 days and in a snap back-up cannot be > > created due to the above problem. Hope anyone of you can help. E-Sulat v.0.0.1 ( Manna ) ....................................................................................... An extended module for MUWeb4 Project Powered by Horde, Postfix, PostgreSQL & Courier-IMAP