Skip site navigation (1) Skip section navigation (2)

Re: starting postgresql for first time

From: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
To: postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Re: starting postgresql for first time
Date: 2004-04-29 04:32:42
Message-ID: 20040429043242.GA20807@www.sirfsup.com (view raw or flat)
Thread:
Lists: pgsql-novice
hi robert ,
nothing like some fun!
On Thu, Apr 29, 2004 at 11:30:01AM +1200, Robert Morgan wrote:
> Thankyou to all the people who have taken the time to reply my posts, 
> unfortunately nothing has worked.
:)
> 
> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
> LOG: could not create IPv6 socket: Address family not supported by protocol
> LOG: database system was shut down at 2004-04-29 10:51:19 NZST
> LOG: checkpoint record is at 0/9B1058
> LOG: redo record is at 0/9B1058; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 536; next OID: 17142
> LOG: database system is ready
> 
> AT THIS POINT I DID CTRL+Z AS NOTHING ELSE HAPPENED
> 
> [1]+ Stopped /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
> 
> POSMASTER HAS STOPPED
> 
> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
> FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
> HINT: Is another postmaster (PID 19495) running in data directory 
> "/usr/local/pgsql/data"?
> bash-2.05b$
> 
> UNABLE TO RESTART? ANOTHER INSTANCE OF POSTMASTER RUNNING? NO!!
> 
> If someone could explain to me what is going on I would appreciate it.
> 
> Without a doubt one of the more user unfriendly programmes I have come 
> across!

:) developers, any plans for a desktop icon? A tooltray icon would help, too.

> 
> Bob
>
at that point where you hit CTRL-Z you could just hit return.  When you did that, you stopped the postmaster by setting it to 

joe      20879  0.0  0.0  1328  340 pts/5    T    23:22   0:00 ./program_network_server.exe infile localhost 8888

the eighth field is now a T.  That means traced/stopped. 

are you in new zealand? (is NZST really new zealand standard time?)

to restart, don't just delete the 

 lock file "/usr/local/pgsql/data/postmaster.pid"

YOu need to put the job in the foreground .  The way to unstop a process is fg (bash) which you are in.

again.  

YOu shouldn't need to do CTRL-z as you can just hit return.  those are just messgaes on the console, you can ignore them and continue.




In response to

pgsql-novice by date

Next:From: joseph speigleDate: 2004-04-29 04:40:34
Subject: Re: starting postgresql for first time
Previous:From: Avi SchwartzDate: 2004-04-29 04:30:29
Subject: Re: starting postgresql for first time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group