Received: from snatch.newsnipple.com ([64.71.188.74]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4LG8oA28236 for ; Mon, 21 May 2001 12:08:51 -0400 (EDT) (envelope-from adam@snatch.newsnipple.com) Received: by snatch.newsnipple.com (Postfix, from userid 100) id 97F364B3A9; Mon, 21 May 2001 09:06:07 -0700 (PDT) Date: Mon, 21 May 2001 09:06:07 -0700 From: Adam Haberlach To: Subhramanya Shiva Cc: pgsql-jdbc@postgresql.org Subject: Re: problem while starting server ??? Message-ID: <20010521090607.A19785@newsnipple.com> References: <1058.192.168.0.5.990378967.squirrel@mail.archeanit.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1058.192.168.0.5.990378967.squirrel@mail.archeanit.net>; from shiva@archeanit.com on Sun, May 20, 2001 at 10:46:07PM +0530 X-Archive-Number: 200105/193 X-Sequence-Number: 684 On Sun, May 20, 2001 at 10:46:07PM +0530, Subhramanya Shiva wrote: > Hi all > > I installed postgresql successfully. > But when i starting the server it is showing the server status differently > > DEBUG: CheckPoint record at (0, 1522288) > DEBUG: Redo record at (0, 1522288); Undo record at (0, 0); Shutdown TRUE > DEBUG: NextTransactionId: 618; NextOid: 18720 > DEBUG: database system is in production state This is normal. > after this > when i was starting the psql > it was giving error "user not found in the system catalog" You probably want to start psql with the '-U' option and specify that you are connecting with the 'postgres' user. Then you can use the "CREATE USER" command to make one with your username. -- Adam Haberlach | adam@newsnipple.com | http://youlook.org http://www.newsnipple.com | '88 EX500 '00 >^< |