Initalizing PostgreSQL Database

On Monday 15 September 2003 15:10, KG wrote:

I'm getting the following error message when I try to create a user or
database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports
directory but I'm stumped when I got the following error message. When I do

I don't know anything about the BSDs but 7.2.4 was the last of the 7.2 series
- upgrade if at all possible.

$ createdb test1
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

Does a "ps" show anything running (postmaster)? I'm guessing not, since it
can't find the socket.
Have you run "initdb"? You need to do this to initialise the system, create
required files etc. I don't know if your startup script does this for you.
Is the "postgres" or "pgsql" (or whatever) user setup, does it have permission
to access your target data/base directory?

--
Richard Huxton
Archonet Ltd

KG <lists@i2iwebsolutions.com> writes:

I'm stumped when I got the following error message. When I do a
/usr/local/etc/rc.d/010.pgsql.sh start all I get is this:
freebsd# sh 010.pgsql.sh start
pgsqlfreebsd#

There are a lot of shoddy start scripts running around :-(. Yours is
probably dumping the postmaster's stderr output to /dev/null, so
whatever error message it puts out about being unable to start is
just vanishing. Or, if you're lucky, stderr is being sent to a logfile
you can look at. I'd suggest modifying the script if necessary so that
you can see what the postmaster is complaining about.

regards, tom lane

Quoting Richard Huxton <dev@archonet.com>:

On Monday 15 September 2003 15:10, KG wrote:

I'm getting the following error message when I try to create a user or
database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports
directory but I'm stumped when I got the following error message. When I

do

I don't know anything about the BSDs but 7.2.4 was the last of the 7.2 series

- upgrade if at all possible.

$ createdb test1
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

Does a "ps" show anything running (postmaster)? I'm guessing not, since it
can't find the socket.
Have you run "initdb"? You need to do this to initialise the system, create
required files etc. I don't know if your startup script does this for you.
Is the "postgres" or "pgsql" (or whatever) user setup, does it have
permission
to access your target data/base directory?

--
Richard Huxton
Archonet Ltd

Thanks I figured it out. I went to the /usr/local/pgsql directory and ran
initdb. All is well now.

Kevin

"TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:

TL> KG <lists@i2iwebsolutions.com> writes:

I'm stumped when I got the following error message. When I do a
/usr/local/etc/rc.d/010.pgsql.sh start all I get is this:
freebsd# sh 010.pgsql.sh start
pgsqlfreebsd#

TL> There are a lot of shoddy start scripts running around :-(. Yours is
TL> probably dumping the postmaster's stderr output to /dev/null, so
TL> whatever error message it puts out about being unable to start is

The one in the FreeBSD port doesn't fall into that category... look in
/var/log/postgres.log or something similar to that name.

Looks like he never ran initdb...

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/