From: | Michael Wood <esiotrot(at)gmail(dot)com> |
---|---|
To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
Cc: | "Struckhoff, Kevin" <StruckhoffK(at)gsicommerce(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: psql thinks we should be listening on port 5432 |
Date: | 2012-02-22 08:18:37 |
Message-ID: | CAP6d-HXpZACFBUUReOMv87kFz_A5tnH9j4NnR_=SfCcfWXN+mQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 22 February 2012 09:25, Lonni J Friedman <netllama(at)gmail(dot)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(at)gsicommerce(dot)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(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | ZXAEGAKKA001, ext | 2012-02-22 11:16:06 | Export Control Classification Number (ECCN) Request |
Previous Message | Andreas Kretschmer | 2012-02-22 07:26:56 | Re: psql think we should be on port 5432 |