Look in the Admin Docs: Starting the Server. pg_ctl -o "-i <other options>".
Or edit the TCPIP_SOCKETS parameter in pogresql.conf.
Jay
sysadmin@sysadmincorner.com
www.sysadmincorner.com
"Andy Jenks" <andy@compete.com> wrote in message
news:9flpfb$559$1@news.tht.net...
> after starting the postmaster:
> pg_ctl -o "-o -F -B 3000 -S -N2 -ps -pn" start
> postmaster successfully started
>
> so the postmaster is started right? but I keep on getting the following
> createdb test1
> psql: connectDBStart() -- connect() failed: No such file or directory
> Is the postmaster running locally
> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> createdb: database creation failed
> any ideas why it says the system is started but I still can't connect?
I've
> removed /tmp/.s.PGSQL.5432 and tried again but still had the same result.
> any help would be appreciated.
> thanks
> andy
> --
> Andy Jenks
> Compete Inc.
> andy@compete.com
>
>