pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFwd: cannot login to psql without specifying host
5+ messages / 4 participants
[nested] [flat]
* Fwd: cannot login to psql without specifying host
@ 2018-10-02 11:12 Mark Steben <mark.steben@drivedominion.com>
2018-10-02 11:30 ` Re: Fwd: cannot login to psql without specifying host Christoph Berg <myon@debian.org>
2018-10-02 14:02 ` Re: cannot login to psql without specifying host Samed YILDIRIM <samed@reddoc.net>
2018-10-02 15:27 ` Re: cannot login to psql without specifying host Craig James <cjames@emolecules.com>
0 siblings, 3 replies; 5+ messages in thread
From: Mark Steben @ 2018-10-02 11:12 UTC (permalink / raw)
To: pgsql-admin
---------- Forwarded message ---------
From: Mark Steben <mark.steben@drivedominion.com>
Good morning,
I run a postgres 9.4.8 standby server, replicating our production server.
I can login using our pguser linux login if I specify the host on the
command line but cannot login if I leave the host off:
* psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01*
*Password for user postgres: *
*psql (9.4.8)*
*Type "help" for help.*
*psql -U postgres prime_production -p 5433 *
*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.5433"?*
I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
because we have another instance pointing to that directory. I restarted
postgres. Didn't help. I have attached our 3 config files along with an
ls -la listing of our database cluster directory. Any insights welcome.
Thank you
--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/; | Autobase
<http://www.autobase.net/;
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/;
<http://autobasedigital.net/marketing/DD12_sig.jpg;
<http://autobasedigital.net/marketing/DD12_sig.jpg;
--
<https://www.drivedominion.com/transform-your-vision/;
Attachments:
cluster.listing (application/octet-stream, 2.3K) download
recovery.conf (application/octet-stream, 2.9K) download
pg_hba.conf (application/octet-stream, 5.9K) download
postgresql.conf (application/octet-stream, 22.6K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fwd: cannot login to psql without specifying host
2018-10-02 11:12 Fwd: cannot login to psql without specifying host Mark Steben <mark.steben@drivedominion.com>
@ 2018-10-02 11:30 ` Christoph Berg <myon@debian.org>
2 siblings, 0 replies; 5+ messages in thread
From: Christoph Berg @ 2018-10-02 11:30 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; +Cc: pgsql-admin
Re: Mark Steben 2018-10-02 <CADyzmyw66x_SgxR=gX+RddQaBgHWVVW=eyNO2w_iygewF+piDw@mail.gmail.com>
> *psql -U postgres prime_production -p 5433 *
> *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.5433"?*
>
> I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
> because we have another instance pointing to that directory. I restarted
> postgres. Didn't help. I have attached our 3 config files along with an
> ls -la listing of our database cluster directory. Any insights welcome.
You can use "psql -h /database/prime_data/PSQL_94/tmp" to use that
socket directory.
In practise, that will fail for any user than the cluster owner
because that is inside your PGDATA, and that is 0700.
Christoph
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: cannot login to psql without specifying host
2018-10-02 11:12 Fwd: cannot login to psql without specifying host Mark Steben <mark.steben@drivedominion.com>
@ 2018-10-02 14:02 ` Samed YILDIRIM <samed@reddoc.net>
2 siblings, 0 replies; 5+ messages in thread
From: Samed YILDIRIM @ 2018-10-02 14:02 UTC (permalink / raw)
To: Mark Steben <mark.steben@drivedominion.com>; pgsql-admin
<div xmlns="http://www.w3.org/1999/xhtml">Dear Mark,</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">When you specify server name with -h parameter, psql uses TCP socket to connect PostgreSQL server. Due to being changed default unix socket directory, you should give socket directory path with -h parameter to psql if you want to create connection via Unix socket. Please try following parameters.</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">psql -p 5433 -h /database/prime_data/PSQL_94/tmp -U postgres prime_production</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">Best regards.</div><div xmlns="http://www.w3.org/1999/xhtml">İyi çalışmalar.</div><div xmlns="http://www.w3.org/1999/xhtml">Samed YILDIRIM</div><div xmlns="http://www.w3.org/1999/xhtml"> </div><div xmlns="http://www.w3.org/1999/xhtml">02.10.2018, 14:13, "Mark Steben" <mark.steben@drivedominion.com>:</div><blockquote xmlns="http://www.w3.org/1999/xhtml"; type="cite"><div> <div>---------- Forwarded message ---------<br />From: <strong>Mark Steben</strong> <span><<a href="mailto:mark.steben@drivedominion.com">mark.steben@drivedominion.com</a>></span><br /> </div> <div>Good morning,<div>I run a postgres 9.4.8 standby server, replicating our production server. I can login using our pguser linux login if I specify the host on the command line but cannot login if I leave the host off:</div><div> </div><div><strong> psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01</strong></div><div><strong>Password for user postgres: </strong></div><div><strong>psql (9.4.8)</strong></div><div><strong>Type "help" for help.</strong></div><div> </div><div><strong>psql -U postgres prime_production -p 5433 </strong></div><div><strong>psql: could not connect to server: No such file or directory</strong></div><div><strong> Is the server running locally and accepting</strong></div><div><strong> connections on Unix domain socket "/tmp/.s.PGSQL.5433"?</strong></div><div> </div><div>I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp because we have another instance pointing to that directory. I restarted postgres. Didn't help. I have attached our 3 config files along with an ls -la listing of our database cluster directory. Any insights welcome.</div><div> </div><div>Thank you</div><div> </div>--<div><span><font color="#888888"><span style="font-family:calibri;font-size:11pt;"><span style="color:#333333;"><strong>Mark Steben</strong></span> </span><br /> Database Administrator<br /><span style="font-family:century gothic;font-size:8pt;"><a target="_blank" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" href="http://www.autorevenue.com/">@utoRevenue</a> <span style="color:#4f81bd;font-size:10pt;">|</span> <a target="_blank" style="color:rgb(79,129,189);font-size:8pt;font-weight:bold;text-decoration:none;" href="http://www.autobase.net/">Autobase</a> <br /> <strong style="color:#4f81bd;font-size:8pt;font-weight:bold;text-decoration:none;">CRM division of Dominion Dealer Solutions</strong> <br /><span style="color:gray;font-size:8pt;">95D Ashley Ave.<br />West Springfield, MA 01089</span><br /><span style="color:gray;font-size:8pt;">t: <a>413.327-3045</a></span><br /><span style="color:gray;font-size:8pt;">f: <a>413.383-9567</a></span> </span></font></span></div><p><span><font color="#888888"><span style="font-family:century gothic;font-size:8pt;"><a target="_blank" href="http://www.fb.com/DominionDealerSolutions">www.fb.com/DominionDealerSolutions</a><br /><a target="_blank" href="http://www.twitter.com/DominionDealer">www.twitter.com/DominionDealer</a><br /><span style="color:gray;font-size:8pt;"> <a target="_blank" href="http://www.autorevenue.com/">www.drivedominion.com</a></span></span></fo... /><br /><br /><br /><br /> </p></div> <div> </div> <div> </div><p><br /><br /><br /> </p></div><br /><a target="_blank" href="https://www.drivedominion.com/transform-your-vision/"><img src="https://drive.google.com/uc?export=download&id=11-V6G0v_RMn85a0Fq4XYXxOHHkcJH6pi"; /></a></blockquote>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: cannot login to psql without specifying host
2018-10-02 11:12 Fwd: cannot login to psql without specifying host Mark Steben <mark.steben@drivedominion.com>
@ 2018-10-02 15:27 ` Craig James <cjames@emolecules.com>
2018-10-02 15:29 ` Re: cannot login to psql without specifying host Craig James <cjames@emolecules.com>
2 siblings, 1 reply; 5+ messages in thread
From: Craig James @ 2018-10-02 15:27 UTC (permalink / raw)
To: mark.steben@drivedominion.com; +Cc: pgsql-admin
On Tue, Oct 2, 2018 at 4:12 AM Mark Steben <mark.steben@drivedominion.com>
wrote:
>
>
> ---------- Forwarded message ---------
> From: Mark Steben <mark.steben@drivedominion.com>
>
>
> Good morning,
> I run a postgres 9.4.8 standby server, replicating our production server.
> I can login using our pguser linux login if I specify the host on the
> command line but cannot login if I leave the host off:
>
> * psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01*
> *Password for user postgres: *
> *psql (9.4.8)*
> *Type "help" for help.*
>
> *psql -U postgres prime_production -p 5433 *
> *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.5433"?*
>
> I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
> because we have another instance pointing to that directory. I restarted
> postgres. Didn't help. I have attached our 3 config files along with an
> ls -la listing of our database cluster directory. Any insights welcome.
>
I've seen this when your postgresql.com "listen_address" isn't sent
properly. It's probably something like this:
listen_addresses = '192.168.58.13'
The error message is telling you that Postgres is not listening on
localhost. Instead, you may want something like this:
listen_addresses = 'localhost,192.168.58.13'
or this:
listen_addresses = '*'
Craig
> Thank you
>
> --
> *Mark Steben*
> Database Administrator
> @utoRevenue <http://www.autorevenue.com/; | Autobase
> <http://www.autobase.net/;
> CRM division of Dominion Dealer Solutions
> 95D Ashley Ave.
> West Springfield, MA 01089
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
> www.drivedominion.com <http://www.autorevenue.com/;
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg;
>
>
>
>
>
>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg;
>
>
>
>
> <https://www.drivedominion.com/transform-your-vision/;
--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
---------------------------------
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: cannot login to psql without specifying host
2018-10-02 11:12 Fwd: cannot login to psql without specifying host Mark Steben <mark.steben@drivedominion.com>
2018-10-02 15:27 ` Re: cannot login to psql without specifying host Craig James <cjames@emolecules.com>
@ 2018-10-02 15:29 ` Craig James <cjames@emolecules.com>
0 siblings, 0 replies; 5+ messages in thread
From: Craig James @ 2018-10-02 15:29 UTC (permalink / raw)
To: mark.steben@drivedominion.com; +Cc: pgsql-admin
Oh wait, my mistake ...
On Tue, Oct 2, 2018 at 8:27 AM Craig James <cjames@emolecules.com> wrote:
> On Tue, Oct 2, 2018 at 4:12 AM Mark Steben <mark.steben@drivedominion.com>
> wrote:
>
>>
>>
>> ---------- Forwarded message ---------
>> From: Mark Steben <mark.steben@drivedominion.com>
>>
>>
>> Good morning,
>> I run a postgres 9.4.8 standby server, replicating our production
>> server. I can login using our pguser linux login if I specify the host on
>> the command line but cannot login if I leave the host off:
>>
>> * psql -U postgres prime_production -p 5433 -h arprodpsqlreplication01*
>> *Password for user postgres: *
>> *psql (9.4.8)*
>> *Type "help" for help.*
>>
>> *psql -U postgres prime_production -p 5433 *
>> *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.5433"?*
>>
>> I have changed the UNIX_SOCKET_DIRECTORIES to something other than /tmp
>> because we have another instance pointing to that directory. I restarted
>> postgres. Didn't help. I have attached our 3 config files along with an
>> ls -la listing of our database cluster directory. Any insights welcome.
>>
>
> I've seen this when your postgresql.com "listen_address" isn't sent
> properly. It's probably something like this:
>
> listen_addresses = '192.168.58.13'
>
>
> The error message is telling you that Postgres is not listening on
> localhost. Instead, you may want something like this:
>
> listen_addresses = 'localhost,192.168.58.13'
>
>
> or this:
>
> listen_addresses = '*'
>
>
I didn't see your attached postgresql.conf, which already has this. Ignore
my suggestion, there's something else that others probably know more about
than me.
Craig
>
> Craig
>
>
>
>> Thank you
>>
>> --
>> *Mark Steben*
>> Database Administrator
>> @utoRevenue <http://www.autorevenue.com/; | Autobase
>> <http://www.autobase.net/;
>> CRM division of Dominion Dealer Solutions
>> 95D Ashley Ave.
>> West Springfield, MA 01089
>> t: 413.327-3045
>> f: 413.383-9567
>>
>> www.fb.com/DominionDealerSolutions
>> www.twitter.com/DominionDealer
>> www.drivedominion.com <http://www.autorevenue.com/;
>>
>> <http://autobasedigital.net/marketing/DD12_sig.jpg;
>>
>>
>>
>>
>>
>>
>>
>> <http://autobasedigital.net/marketing/DD12_sig.jpg;
>>
>>
>>
>>
>> <https://www.drivedominion.com/transform-your-vision/;
>
>
>
> --
> ---------------------------------
> Craig A. James
> Chief Technology Officer
> eMolecules, Inc.
> ---------------------------------
>
--
---------------------------------
Craig A. James
Chief Technology Officer
eMolecules, Inc.
---------------------------------
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2018-10-02 15:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-02 11:12 Fwd: cannot login to psql without specifying host Mark Steben <mark.steben@drivedominion.com>
2018-10-02 11:30 ` Christoph Berg <myon@debian.org>
2018-10-02 14:02 ` Samed YILDIRIM <samed@reddoc.net>
2018-10-02 15:27 ` Craig James <cjames@emolecules.com>
2018-10-02 15:29 ` Craig James <cjames@emolecules.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox