Re: starting postgresql for first time

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
itto  

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
themand continue.