[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] pgdg96 repo with centos 7.x - server starts only on loopback
From: Scott Whitney <scott () journyx ! com>
Date: 2017-07-28 22:19:40
Message-ID: CY4PR11MB1575A3DA9EC3E3EB15016F14A7BF0 () CY4PR11MB1575 ! namprd11 ! prod ! outlook ! com
[Download RAW message or body]
Is SELINUX on?
________________________________
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf \
of Tom Lane <tgl@sss.pgh.pa.us>
Sent: Friday, July 28, 2017 4:55 PM
To: lejeczek
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pgdg96 repo with centos 7.x - server starts only on loopback
lejeczek <peljasz@yahoo.co.uk> writes:
> I'm using PostgreSQL 9.6 7 - x86_64 repo with centos 7.3.
> Configuration pretty standard, including this among the lines:
> ...
> listen_addresses = 'localhost, 192.168.2.200, 10.5.6.100'
> ...
> and yet, after system reboot I get process listening only on:
> tcp 0 0 127.0.0.1:15432 0.0.0.0:*
> LISTEN 5373/postmaster
> tcp6 0 0 ::1:15432 :::* LISTEN
> 5373/postmaster
> What can be wrong?
Looking into the postmaster's log would be informative, but I suspect
what is happening is that systemd is allowing the postmaster to start
before those non-default interfaces are up. This is one of the ways
systemd sucks :-( ... it's actually quite hard to prevent that.
"After=network.target" does *not* do it, at least not without munging
the definition of that target.
I don't offhand recall the solution for this, but it's a systemd
question not a Postgres question. Googling on that basis might help.
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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? Click here \
<http://journyx.com/communication-preferences> or visit \
http://journyx.com/communication-preferences to unsubscribe.
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} \
--></style> </head>
<body dir="ltr">
<div id="divtagdefaultwrapper" \
style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" \
dir="ltr"> <p>Is SELINUX on?</p>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" \
style="font-size:11pt"><b>From:</b> pgsql-admin-owner@postgresql.org \
<pgsql-admin-owner@postgresql.org> on behalf of Tom Lane \
<tgl@sss.pgh.pa.us><br> <b>Sent:</b> Friday, July 28, 2017 4:55 PM<br>
<b>To:</b> lejeczek<br>
<b>Cc:</b> pgsql-admin@postgresql.org<br>
<b>Subject:</b> Re: [ADMIN] pgdg96 repo with centos 7.x - server starts only on \
loopback</font> <div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">lejeczek <peljasz@yahoo.co.uk> writes:<br>
> I'm using PostgreSQL 9.6 7 - x86_64 repo with centos 7.3.<br>
> Configuration pretty standard, including this among the lines:<br>
> ...<br>
> listen_addresses = 'localhost, 192.168.2.200, 10.5.6.100'<br>
> ...<br>
> and yet, after system reboot I get process listening only on:<br>
<br>
> tcp 0 0 \
127.0.0.1:15432 0.0.0.0:* <br> > \
LISTEN 5373/postmaster<br> > \
tcp6 0 0 \
::1:15432 \
:::* LISTEN <br> > 5373/postmaster<br>
<br>
> What can be wrong?<br>
<br>
Looking into the postmaster's log would be informative, but I suspect<br>
what is happening is that systemd is allowing the postmaster to start<br>
before those non-default interfaces are up. This is one of the ways<br>
systemd sucks :-( ... it's actually quite hard to prevent that.<br>
"After=network.target" does *not* do it, at least not without munging<br>
the definition of that target.<br>
<br>
I don't offhand recall the solution for this, but it's a systemd<br>
question not a Postgres question. Googling on that basis might help.<br>
<br>
\
regards, tom lane<br> <br>
<br>
-- <br>
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-admin" id="LPlnk248065" \
previewremoved="true">http://www.postgresql.org/mailpref/pgsql-admin</a><br> </div>
</span></font></div>
</div>
<div style="\"font-family:" \
timesnewroman,newyork,times,serif;font-size:12pt;color:#000000\?=""> <br>
<div><br>
</div>
<div><span name="\"x\""></span>
<div><span style="\"font-size:" 12pt;\?="">Journyx, Inc.</span></div>
<div>7600 Burnet Road #300 <br>
Austin, TX 78757 <br>
www.journyx.com <br>
</div>
<div><br>
</div>
<div>
<div><span style="\"font-size:" 12pt;\?data-mce-style="\"font-size:" \
12pt;\?="">p 512.834.8888 </span></div> <div>f 512-834-8858 </div>
<div><br>
</div>
</div>
<div>Do you receive our promotional emails? Click <a \
href="http://journyx.com/communication-preferences"> here </a>or visit \
http://journyx.com/communication-preferences to unsubscribe.<br> </div>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic