Thread: problem while starting server ???
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 after this when i was starting the psql it was giving error "user not found in the system catalog" what could be the problem.... Installation i did it correctly. after gmake and gmake install ..it showed ...Postregsql Installed successfully. regards shiva. -- Subhramanya Shiva, Programmer Archean InfoTech pvt.Ltd. Hyderabad, India http://www.archeanit.com
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 >^< |
psql -U postgres template1 On Sun, 20 May 2001, 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 > > after this > when i was starting the psql > it was giving error "user not found in the system catalog" > > what could be the problem.... Installation i did it correctly. > after gmake and gmake install ..it showed ...Postregsql > Installed successfully. > > regards > shiva.
On Sun, 20 May 2001, Subhramanya Shiva wrote: > when i was starting the psql > it was giving error "user not found in the system catalog" Did it say something like this? psql: FATAL 1: Database "shiva" does not exist in the system catalog. By default psql looks for a database named the same as your user ID. If you want to use a database by a different name, then say "psql different_name" To get a list of what databases you have, use "psql -l" To create a new database use the createdb command. -- Tod McQuillin