Thread: 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
-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
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>
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