Initalizing PostgreSQL Database

[KG]

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 a
/usr/local/etc/rc.d/010.pgsql.sh start all I get is this:

freebsd# sh 010.pgsql.sh start
pgsqlfreebsd#

$ 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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

KG <li***@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[KG]

Quoting Richard Huxton <de*@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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Vivek Khera]

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

TL> KG <li***@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: kh***@kciLink.com Rockville, MD [phone]
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html