Thread: psql thinks we should be listening on port 5432

psql thinks we should be listening on port 5432

From
"Struckhoff, Kevin"
Date:

Hello,

 

I’m running postgres 8.4.5, it was bundled w/ Actuate 11 Iserver. It was configured to run on port 8432 (not sure why or if that can be changed, I suspect it doesn’t matter in the long run). When I try to run psql, I get this error:

 

/usr/local/actuate11/AcServer/postgresql/bin->psql -d ac_dr_reports

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"?

/usr/local/actuate11/AcServer/postgresql/bin->

 

How do I tell it to look on port 8432?

 

Here’s the files in /tmp:

 

srwxrwxrwx  1 actuate actuate     0 Feb 21 15:23 .s.PGSQL.8432

-rw-------  1 actuate actuate    62 Feb 21 15:23 .s.PGSQL.8432.lock

 

 

Thanks.

 

Kevin

 

Re: psql thinks we should be listening on port 5432

From
Lonni J Friedman
Date:
-p, --port=PORT          database server port (default: "5432")

On Tue, Feb 21, 2012 at 3:59 PM, Struckhoff, Kevin
<StruckhoffK@gsicommerce.com> wrote:
> Hello,
>
>
>
> I’m running postgres 8.4.5, it was bundled w/ Actuate 11 Iserver. It was
> configured to run on port 8432 (not sure why or if that can be changed, I
> suspect it doesn’t matter in the long run). When I try to run psql, I get
> this error:
>
>
>
> /usr/local/actuate11/AcServer/postgresql/bin->psql -d ac_dr_reports
>
> 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"?
>
> /usr/local/actuate11/AcServer/postgresql/bin->
>
>
>
> How do I tell it to look on port 8432?
>
>
>
> Here’s the files in /tmp:
>
>
>
> srwxrwxrwx  1 actuate actuate     0 Feb 21 15:23 .s.PGSQL.8432
>
> -rw-------  1 actuate actuate    62 Feb 21 15:23 .s.PGSQL.8432.lock
>
>
>
>
>
> Thanks.
>
>
>
> Kevin
>
>



--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       https://netllama.linux-sxs.org

Re: psql thinks we should be listening on port 5432

From
Michael Wood
Date:
On 22 February 2012 09:25, Lonni J Friedman <netllama@gmail.com> wrote:
> -p, --port=PORT          database server port (default: "5432")

Also, from http://www.postgresql.org/docs/8.4/static/app-psql.html :

"When the defaults aren't quite right, you can save yourself some
typing by setting the environment variables PGDATABASE, PGHOST, PGPORT
and/or PGUSER to appropriate values. (For additional environment
variables, see Section 30.13.[1])"

[1] http://www.postgresql.org/docs/8.4/static/libpq-envars.html

> On Tue, Feb 21, 2012 at 3:59 PM, Struckhoff, Kevin
> <StruckhoffK@gsicommerce.com> wrote:
>> Hello,
>>
>> I’m running postgres 8.4.5, it was bundled w/ Actuate 11 Iserver. It was
>> configured to run on port 8432 (not sure why or if that can be changed, I
>> suspect it doesn’t matter in the long run). When I try to run psql, I get
>> this error:
>>
>> /usr/local/actuate11/AcServer/postgresql/bin->psql -d ac_dr_reports
>>
>> 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"?
>>
>> /usr/local/actuate11/AcServer/postgresql/bin->
>>
>> How do I tell it to look on port 8432?
>>
>> Here’s the files in /tmp:
>>
>> srwxrwxrwx  1 actuate actuate     0 Feb 21 15:23 .s.PGSQL.8432
>>
>> -rw-------  1 actuate actuate    62 Feb 21 15:23 .s.PGSQL.8432.lock
>>
>> Thanks.

--
Michael Wood <esiotrot@gmail.com>

Re: psql thinks we should be listening on port 5432

From
"Day, David"
Date:

Hi

 

I suggest you start psql with the port declaration switch –p 8432,

By default it is using 5432

 

Rgds

 

 

Dave

 

From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Struckhoff, Kevin
Sent: Tuesday, February 21, 2012 7:00 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] psql thinks we should be listening on port 5432

 

Hello,

 

I’m running postgres 8.4.5, it was bundled w/ Actuate 11 Iserver. It was configured to run on port 8432 (not sure why or if that can be changed, I suspect it doesn’t matter in the long run). When I try to run psql, I get this error:

 

/usr/local/actuate11/AcServer/postgresql/bin->psql -d ac_dr_reports

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"?

/usr/local/actuate11/AcServer/postgresql/bin->

 

How do I tell it to look on port 8432?

 

Here’s the files in /tmp:

 

srwxrwxrwx  1 actuate actuate     0 Feb 21 15:23 .s.PGSQL.8432

-rw-------  1 actuate actuate    62 Feb 21 15:23 .s.PGSQL.8432.lock

 

 

Thanks.

 

Kevin