On Sat, 19 Jul 2003, Dr. Slack wrote:
> /usr/local/pgsql/data >logfile
>
> La pasul :
> /usr/local/pgsql/bin/createdb test
> primesc urmatoarea eroare:
> psql: 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"?
> createdb: database creation failed
Vezi care-i treaba in logfilele ala. Vezi ce zice la tine
urmatoarea linie:
su -l postgres -s /bin/sh -c "/usr/local/bin/pg_ctl -D
/usr/local/pgsql/data -p /usr/local/bin/postmaster -o '-p 5432' start"
Whatever, daca nu am nimerit caile catre pg_ctl, postmaster,
etc, le corectezi tu, cel mai important e ce mesaj de eroare obtii dupa
ce le scrii corect, mesaj pe care va trebui apoi sa-l interpretezi si sa
iei masurile de rigoare.
Nu uita sa arunci o privire in postgresql.conf, sa maresti
vacuum_mem si sort_mem la niste valori mai rezonabile (8-16-32MB, in
functie de ce ai nevoie, eu merg cu 128MB pe ambele). De asemenea nu
uita de max_fsm_*. ++citeste doacele cu care vine referitor la Server
Administration (mai ales runtime configuration).
--
Any views or opinions presented within this e-mail are solely those of
the author and do not necessarily represent those of any company, unless
otherwise expressly stated.
