initdb
pg_ctl -D <data_dir> -w start # (recommended way of starting the the server)
createdb #(optional, since default DB postgres is already there)
On Dec 19, 2007 6:17 AM, Glyn Astill <glynastill@xxxxxxxxxxx> wrote:
Hi people,
Right I've setup postgres numerous times without a problem, and this
time I'm using all the same stuff but running into a problem where
initdb won't run without the postgres server running, and the
postgres server will not run without the postgresql.conf etc that
initdb creates!
To start with I tried the following:
#/usr/local/pgsql/bin/createdb SEE --encoding='LATIN1'
Which gave me the error :
createdb: could not connect to database
postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
So okay, I'll try and start the server:
#/usr/local/pgsql/bin/postgres -D /data/postgres
>/data/postgres/psql.log 2>&1 &
and in psql.log I get the error:
"postgres cannot access the server configuration file
"/data/postgres/postgresql.conf": No such file or directory"
I shout at it I know!!!! Initdb should have done it!!
Anyone got any idea what's eating my lunch? Maybe I ran something in
the wrong order?
Thanks
Glyn
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco *
http://gurjeet.frihost.net
Mail sent from my BlackLaptop device
