Thread: psql error: could not connect to server

psql error: could not connect to server

From
bartvde@xs4all.nl
Date:
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

Re: psql error: could not connect to server

From
Bruno Wolff III
Date:
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.

createdb

From
bartvde@xs4all.nl
Date:
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
>


Re: createdb

From
Bruno LEVEQUE
Date:
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