Hi list,

I just downloaded the source from PostgreSQL 7.4.1 and installed it on Red
Hat 9. Install was succesfull. After this I installed PostGIS 0.8.0.

To test the PostGIS install I need the perform the following command:

createlang plpgsql postgistest

But on performing this I get the following error:

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"?
createlang: external error

Anybody have an idea what could be the problem?

Thanks in advance!

Best regards,
Bart

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Fri, Jan 09, 2004 at 22:39:09 +0100,
bartvde (AT) xs4all (DOT) nl wrote:
Most likely the server isn't running.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Hi,

I got it up and running with:

[root@localhost init.d]# ./postgresql start
Initializing database: [ OK ]
Starting postgresql service: [ OK ]

But now I want to create a database, but I cannot do this with the root
user. What is the best way to do this?

I tried with user postgresql but what password to use?

createdb --username=postgresql mydb

Thanks in advance.

Best regards,
Bart


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

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

Hi,

I think you have a problem with the installation. You MUSN'T install
postgresql with root account. The user of the installation is the
administrator of the database and you can create database with it
without password (till you give one to it).

Bruno

bartvde (AT) xs4all (DOT) nl wrote:

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque (AT) net6d (DOT) com
http://www.net6d.com


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