pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlisten_addresses = '*' postgresql 9.5 does not allow local connect
12+ messages / 8 participants
[nested] [flat]
* listen_addresses = '*' postgresql 9.5 does not allow local connect
@ 2017-06-04 02:51 kschindl <chuck666xx@gmail.com>
2017-06-04 03:07 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect David G. Johnston <david.g.johnston@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: kschindl @ 2017-06-04 02:51 UTC (permalink / raw)
To: pgsql-admin
when i add the listen_addresses = '*' i cannot connect local (with or without
pgadmin)
as soon as i comment this out i can connect local where the server is
installed
--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 03:07 ` David G. Johnston <david.g.johnston@gmail.com>
2017-06-04 03:27 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: David G. Johnston @ 2017-06-04 03:07 UTC (permalink / raw)
To: kschindl <chuck666xx@gmail.com>; +Cc: pgsql-admin
On Saturday, June 3, 2017, kschindl <chuck666xx@gmail.com> wrote:
> when i add the listen_addresses = '*' i cannot connect local (with or
> without
> pgadmin)
> as soon as i comment this out i can connect local where the server is
> installed
>
>
Please show some psql commands and resultant error messages.
David J.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 03:07 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect David G. Johnston <david.g.johnston@gmail.com>
@ 2017-06-04 03:27 ` kschindl <chuck666xx@gmail.com>
2017-06-04 03:39 ` Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Михаил Шурутов <m.shurutov@postgrespro.ru>
0 siblings, 1 reply; 12+ messages in thread
From: kschindl @ 2017-06-04 03:27 UTC (permalink / raw)
To: pgsql-admin
David G Johnston wrote
> On Saturday, June 3, 2017, kschindl <
> chuck666xx@
> > wrote:
>
> Please show some psql commands and resultant error messages.
>
> David J.
kschindl@BelgarathUbuntu:~$ sudo -u postgres psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Pgadmin:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused Is the server running on
host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
as soon as i remove the listen_addresses it works and connects on port 5432
--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 03:07 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect David G. Johnston <david.g.johnston@gmail.com>
2017-06-04 03:27 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 03:39 ` Михаил Шурутов <m.shurutov@postgrespro.ru>
0 siblings, 0 replies; 12+ messages in thread
From: Михаил Шурутов @ 2017-06-04 03:39 UTC (permalink / raw)
To: pgsql-admin
Please set listen_addresses parameter and show output of command
netstat -ltxn|grep 5432
04.06.2017 06:27, kschindl пишет:
> David G Johnston wrote
>> On Saturday, June 3, 2017, kschindl <
>
>> chuck666xx@
>
>> > wrote:
>>
>> Please show some psql commands and resultant error messages.
>>
>> David J.
>
> kschindl@BelgarathUbuntu:~$ sudo -u postgres psql
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>
> Pgadmin:
> Server doesn't listen
> The server doesn't accept connections: the connection library reports
> could not connect to server: Connection refused Is the server running on
> host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
>
> as soon as i remove the listen_addresses it works and connects on port 5432
>
>
>
> --
> View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
--
WBR, Michail Shurutov
Postgres Professional: http://www.postgrespro.ru
The Russian Postgres Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 05:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:37 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
1 sibling, 2 replies; 12+ messages in thread
From: Scott Marlowe @ 2017-06-04 05:01 UTC (permalink / raw)
To: kschindl <chuck666xx@gmail.com>; +Cc: pgsql-admin
On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx@gmail.com> wrote:
> when i add the listen_addresses = '*' i cannot connect local (with or without
> pgadmin)
> as soon as i comment this out i can connect local where the server is
> installed
Is there another listen_addresses line in your conf file?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
@ 2017-06-04 05:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Tom Lane @ 2017-06-04 05:20 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: kschindl <chuck666xx@gmail.com>; pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Sat, Jun 3, 2017 at 8:51 PM, kschindl <chuck666xx@gmail.com> wrote:
>> when i add the listen_addresses = '*' i cannot connect local (with or without
>> pgadmin)
>> as soon as i comment this out i can connect local where the server is
>> installed
> Is there another listen_addresses line in your conf file?
I'd counsel looking into the postmaster log file. The described symptoms
sound like the postmaster is failing to start when given this setting,
and the log should offer some clue as to why.
I think we've seen similar reports that eventually traced to local DNS
misconfiguration, but that's theorizing in advance of the evidence.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
@ 2017-06-04 05:42 ` kschindl <chuck666xx@gmail.com>
2017-06-04 05:57 ` Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Julien Rouhaud <julien.rouhaud@dalibo.com>
2017-06-04 06:00 ` Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Rady, Doug <radydoug@amazon.com>
2017-06-04 07:11 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
0 siblings, 3 replies; 12+ messages in thread
From: kschindl @ 2017-06-04 05:42 UTC (permalink / raw)
To: pgsql-admin
Tom Lane-2 wrote
> I'd counsel looking into the postmaster log file. The described symptoms
> sound like the postmaster is failing to start when given this setting,
> and the log should offer some clue as to why.
>
> I think we've seen similar reports that eventually traced to local DNS
> misconfiguration, but that's theorizing in advance of the evidence.
>
> regards, tom lane
>
>
> --
> Sent via pgsql-admin mailing list (
> pgsql-admin@
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
thx.
That is what the log says:
2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type
"listen_addresses"
2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file
"/etc/postgresql/9.5/main/pg_hba.conf"
2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf
That is line 74
listen_addresses = '*'
copied from manual
so i am lost
--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 05:57 ` Julien Rouhaud <julien.rouhaud@dalibo.com>
2 siblings, 0 replies; 12+ messages in thread
From: Julien Rouhaud @ 2017-06-04 05:57 UTC (permalink / raw)
To: kschindl <chuck666xx@gmail.com>; pgsql-admin
On 04/06/2017 07:42, kschindl wrote:
> That is what the log says:
> 2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type
> "listen_addresses"
> 2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file
> "/etc/postgresql/9.5/main/pg_hba.conf"
> 2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf
>
> That is line 74
> listen_addresses = '*'
>
> copied from manual
>
> so i am lost
listen_addresses, like other configuration options, has to be configured
in postgresql.conf, not pg_hba.conf.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 06:00 ` Rady, Doug <radydoug@amazon.com>
2 siblings, 0 replies; 12+ messages in thread
From: Rady, Doug @ 2017-06-04 06:00 UTC (permalink / raw)
To: kschindl <chuck666xx@gmail.com>; pgsql-admin
On 6/3/17, 22:42, "pgsql-admin-owner@postgresql.org on behalf of kschindl" <pgsql-admin-owner@postgresql.org on behalf of chuck666xx@gmail.com> wrote:
Tom Lane-2 wrote
I'd counsel looking into the postmaster log file. The described symptoms
sound like the postmaster is failing to start when given this setting,
and the log should offer some clue as to why.
I think we've seen similar reports that eventually traced to local DNS
misconfiguration, but that's theorizing in advance of the evidence.
regards, tom lane
thx.
That is what the log says:
2017-06-04 10:25:38 ICT [938-1] LOG: invalid connection type
"listen_addresses"
2017-06-04 10:25:38 ICT [938-2] CONTEXT: line 74 of configuration file
"/etc/postgresql/9.5/main/pg_hba.conf"
2017-06-04 10:25:38 ICT [938-3] FATAL: could not load pg_hba.conf
That is line 74
listen_addresses = '*'
copied from manual
so i am lost
The listen_addresses parameter goes in: postgresql.conf
doug
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 07:11 ` kschindl <chuck666xx@gmail.com>
2017-06-04 09:19 ` Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Steven Chang <stevenchang1213@gmail.com>
2 siblings, 1 reply; 12+ messages in thread
From: kschindl @ 2017-06-04 07:11 UTC (permalink / raw)
To: pgsql-admin
thx that was it.
--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 07:11 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
@ 2017-06-04 09:19 ` Steven Chang <stevenchang1213@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Steven Chang @ 2017-06-04 09:19 UTC (permalink / raw)
To: kschindl <chuck666xx@gmail.com>; +Cc: pgsql-admin
Hello,
check your pg_hba.conf.
here is my record :
# "local" is for Unix domain socket connections only
local all all md5
then testing connection :
oot@jessie:/etc/postgresql/9.6/main6# psql -U postgres -p 5437
Password for user postgres:
psql (9.6.3)
Type "help" for help.
postgres=#
Steven
2017-06-04 15:11 GMT+08:00 kschindl <chuck666xx@gmail.com>:
> thx that was it.
>
>
>
>
> --
> View this message in context: http://www.postgresql-archive.
> org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-
> tp5964669p5964685.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: listen_addresses = '*' postgresql 9.5 does not allow local connect
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 05:01 ` Re: listen_addresses = '*' postgresql 9.5 does not allow local connect Scott Marlowe <scott.marlowe@gmail.com>
@ 2017-06-04 05:37 ` kschindl <chuck666xx@gmail.com>
1 sibling, 0 replies; 12+ messages in thread
From: kschindl @ 2017-06-04 05:37 UTC (permalink / raw)
To: pgsql-admin
Scott Marlowe-2 wrote
> Is there another listen_addresses line in your conf file?
>
> No did a search
> --
> Sent via pgsql-admin mailing list (
> pgsql-admin@
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
View this message in context: http://www.postgresql-archive.org/listen-addresses-postgresql-9-5-does-not-allow-local-connect-tp596...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2017-06-04 09:19 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-06-04 02:51 listen_addresses = '*' postgresql 9.5 does not allow local connect kschindl <chuck666xx@gmail.com>
2017-06-04 03:07 ` David G. Johnston <david.g.johnston@gmail.com>
2017-06-04 03:27 ` kschindl <chuck666xx@gmail.com>
2017-06-04 03:39 ` Михаил Шурутов <m.shurutov@postgrespro.ru>
2017-06-04 05:01 ` Scott Marlowe <scott.marlowe@gmail.com>
2017-06-04 05:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-06-04 05:42 ` kschindl <chuck666xx@gmail.com>
2017-06-04 05:57 ` Julien Rouhaud <julien.rouhaud@dalibo.com>
2017-06-04 06:00 ` Rady, Doug <radydoug@amazon.com>
2017-06-04 07:11 ` kschindl <chuck666xx@gmail.com>
2017-06-04 09:19 ` Steven Chang <stevenchang1213@gmail.com>
2017-06-04 05:37 ` kschindl <chuck666xx@gmail.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