Thread: psql error: could not connect to server
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
On Fri, Jan 09, 2004 at 22:39:09 +0100, bartvde@xs4all.nl wrote: > 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? Most likely the server isn't running.
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 > On Fri, Jan 09, 2004 at 22:39:09 +0100, > bartvde@xs4all.nl wrote: >> 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? > > Most likely the server isn't running. > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
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@xs4all.nl wrote: >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 > > > >>On Fri, Jan 09, 2004 at 22:39:09 +0100, >> bartvde@xs4all.nl wrote: >> >> >>>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? >>> >>> >>Most likely the server isn't running. >> >>---------------------------(end of broadcast)--------------------------- >>TIP 7: don't forget to increase your free space map settings >> >> >> > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > > -- Bruno LEVEQUE System Engineer SARL NET6D bruno.leveque@net6d.com http://www.net6d.com