Re: Initdb problem - catch 22?

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 <glynastill(at)yahoo(dot)co(dot)uk> 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[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ 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