You should run the commands in the following order: 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 <[EMAIL PROTECTED]> 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/ > -- [EMAIL PROTECTED] [EMAIL PROTECTED] 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