pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsynchronous_standby_name format
4+ messages / 3 participants
[nested] [flat]
* synchronous_standby_name format
@ 2017-07-14 14:58 John Scalia <jayknowsunix@gmail.com>
2017-07-14 15:36 ` Re: synchronous_standby_name format Ashish Tiwari <tashish786@gmail.com>
2017-07-14 15:56 ` Re: synchronous_standby_name format Jerry Sievers <gsievers19@comcast.net>
0 siblings, 2 replies; 4+ messages in thread
From: John Scalia @ 2017-07-14 14:58 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I've been asked to make our setup a little more secure. So, I thought I
would restrict which servers could replicate from our primary. However, it
does not appear that 9.6.3 can use a FQDN entry for this parameter. Plus,
our hostnames include "-" characters, and that seems to break the system as
well. Shouldn't synchronous_standby_names accept a FQDN with a dot or a
dash in the hostname or is this maybe a bug? (Flame suit on)
--
Jay
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: synchronous_standby_name format
2017-07-14 14:58 synchronous_standby_name format John Scalia <jayknowsunix@gmail.com>
@ 2017-07-14 15:36 ` Ashish Tiwari <tashish786@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Ashish Tiwari @ 2017-07-14 15:36 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
Hi John,
Please refer the below links . This may help you.
https://googleweblight.com/i?u=https://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html&...
Thanks.
On Jul 14, 2017 8:29 PM, "John Scalia" <jayknowsunix@gmail.com> wrote:
> Hi all,
>
> I've been asked to make our setup a little more secure. So, I thought I
> would restrict which servers could replicate from our primary. However, it
> does not appear that 9.6.3 can use a FQDN entry for this parameter. Plus,
> our hostnames include "-" characters, and that seems to break the system as
> well. Shouldn't synchronous_standby_names accept a FQDN with a dot or a
> dash in the hostname or is this maybe a bug? (Flame suit on)
> --
> Jay
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: synchronous_standby_name format
2017-07-14 14:58 synchronous_standby_name format John Scalia <jayknowsunix@gmail.com>
@ 2017-07-14 15:56 ` Jerry Sievers <gsievers19@comcast.net>
2017-07-14 16:34 ` Re: synchronous_standby_name format John Scalia <jayknowsunix@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Jerry Sievers @ 2017-07-14 15:56 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
John Scalia <jayknowsunix@gmail.com> writes:
> Hi all,
>
> I've been asked to make our setup a little more secure. So, I thought
> I would restrict which servers could replicate from our primary.
> However, it does not appear that 9.6.3 can use a FQDN entry for this
> parameter. Plus, our hostnames include "-" characters, and that seems
> to break the system as well. Shouldn't synchronous_standby_names
> accept a FQDN with a dot or a dash in the hostname or is this maybe a
> bug? (Flame suit on)
HBA file is where you restrict access based on IP/netmask or DNS names.
synchronous_standby_names has nothing whatsoever to do with this.
HTH
> --
> Jay
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
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] 4+ messages in thread
* Re: synchronous_standby_name format
2017-07-14 14:58 synchronous_standby_name format John Scalia <jayknowsunix@gmail.com>
2017-07-14 15:56 ` Re: synchronous_standby_name format Jerry Sievers <gsievers19@comcast.net>
@ 2017-07-14 16:34 ` John Scalia <jayknowsunix@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: John Scalia @ 2017-07-14 16:34 UTC (permalink / raw)
To: Jerry Sievers <gsievers19@comcast.net>; +Cc: pgsql-admin
Sorry, I should have better explained this. I was trying to build the
application_name using the server's FQDN, and yes, I tried various forms of
quoting the name to no avail. The real issue here though arose from trying
to configure this using ansible. I was just trying to add a new replica
using a new plaubook without defining a lot a variables.
On Jul 14, 2017 11:56 AM, "Jerry Sievers" <gsievers19@comcast.net> wrote:
> John Scalia <jayknowsunix@gmail.com> writes:
>
> > Hi all,
> >
> > I've been asked to make our setup a little more secure. So, I thought
> > I would restrict which servers could replicate from our primary.
> > However, it does not appear that 9.6.3 can use a FQDN entry for this
> > parameter. Plus, our hostnames include "-" characters, and that seems
> > to break the system as well. Shouldn't synchronous_standby_names
> > accept a FQDN with a dot or a dash in the hostname or is this maybe a
> > bug? (Flame suit on)
>
> HBA file is where you restrict access based on IP/netmask or DNS names.
>
> synchronous_standby_names has nothing whatsoever to do with this.
>
> HTH
>
> > --
> > Jay
> >
> >
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres.consulting@comcast.net
> p: 312.241.7800
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-07-14 16:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-14 14:58 synchronous_standby_name format John Scalia <jayknowsunix@gmail.com>
2017-07-14 15:36 ` Ashish Tiwari <tashish786@gmail.com>
2017-07-14 15:56 ` Jerry Sievers <gsievers19@comcast.net>
2017-07-14 16:34 ` John Scalia <jayknowsunix@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