Re: starting posgresql for the first time and most probably last :) - Mailing list pgsql-novice

From daq
Subject Re: starting posgresql for the first time and most probably last :)
Date
Msg-id 1567517523.20040429143216@ugyvitelszolgaltato.hu
Whole thread Raw
In response to starting posgresql for the first time and most probably last :)  (Robert Morgan <robert_@ihug.co.nz>)
List 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


pgsql-novice by date:

Previous
From: Andrew Kelly
Date:
Subject: Re: starting postgres/psql
Next
From: Martin Hampl
Date:
Subject: Query does not use index