Re: starting posgresql for the first time and most probably last :)

From: daq <daq(at)ugyvitelszolgaltato(dot)hu>
To: Robert Morgan <robert_(at)ihug(dot)co(dot)nz>
Cc: psql-novice(at)postgresql(dot)org
Subject: Re: starting posgresql for the first time and most probably last :)
Date: 2004-04-29 12:32:16
Message-ID: 1567517523.20040429143216@ugyvitelszolgaltato.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


RM> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
RM> LOG: could not create IPv6 socket: Address family not supported by protocol
RM> LOG: database system was shut down at 2004-04-29 10:51:19 NZST
RM> LOG: checkpoint record is at 0/9B1058
RM> LOG: redo record is at 0/9B1058; undo record is at 0/0; shutdown TRUE
RM> LOG: next transaction ID: 536; next OID: 17142
RM> LOG: database system is ready

RM> AT THIS POINT I DID CTRL+Z AS NOTHING ELSE HAPPENED

RM> [1]+ Stopped /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

RM> POSMASTER HAS STOPPED

RM> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
RM> FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
RM> HINT: Is another postmaster (PID 19495) running in data directory
RM> "/usr/local/pgsql/data"?
RM> bash-2.05b$

RM> UNABLE TO RESTART? ANOTHER INSTANCE OF POSTMASTER RUNNING? NO!!

I think your Postgres server is runing. After CTRL+Z write bg into the
console to run the postmaster process in background. And now you can
connect to the server.

DAQ

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Hampl 2004-04-29 19:34:52 Query does not use index
Previous Message Andrew Kelly 2004-04-29 07:02:52 Re: starting postgres/psql