pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql admin
3+ messages / 2 participants
[nested] [flat]
* postgresql admin
@ 2017-02-22 19:45 Gone, Sajan <SGone@lb.com>
2017-02-23 09:04 ` Re: postgresql admin Stéphane KANSCHINE <stephane@hexack.fr>
0 siblings, 1 reply; 3+ messages in thread
From: Gone, Sajan @ 2017-02-22 19:45 UTC (permalink / raw)
To: pgsql-admin
Hi All,
Recently we have created coupIe of postgres instances in our enterprise and I am pretty new to postgres DB administration. All of these postgres instances are running on Solaris Smart OS systems. We want to set up LDAP user access to our team(Database) members and I am pretty new to LDAP and not exactly sure how to set it LDAP on a posters server. Please let me know the proper way to accomplish this.
Any documentation on this is highly appreciated.
Below are the OS specifications:
-bash-4.3$ uname -a
SunOS cmh-dbdevtools-002 5.11 joyent_20160622T234741Z i86pc i386 i86pc Solaris
Thanks,
Sajan Gone.
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql admin
2017-02-22 19:45 postgresql admin Gone, Sajan <SGone@lb.com>
@ 2017-02-23 09:04 ` Stéphane KANSCHINE <stephane@hexack.fr>
2017-02-23 18:15 ` Re: postgresql admin Gone, Sajan <SGone@lb.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stéphane KANSCHINE @ 2017-02-23 09:04 UTC (permalink / raw)
To: Gone, Sajan <SGone@lb.com>; +Cc: pgsql-admin
Le mer. 22 févr., vers 19:45, Gone, Sajan exprimait :
> Hi All,
Hey !
> Recently we have created coupIe of postgres instances in our
> enterprise and I am pretty new to postgres DB administration.
> All of these postgres instances are running on Solaris Smart OS
> systems. We want to set up LDAP user access to our
> team(Database) members and I am pretty new to LDAP and not
> exactly sure how to set it LDAP on a posters server. Please let
> me know the proper way to accomplish this.
You just have to edit your pg_hba.conf like this (first result for ldap
auth postgresql on duckduckgo) :
https://wiki.postgresql.org/wiki/LDAP_Authentication_against_AD
Regards,
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
＠ stephane@hexack.fr
+33 6 64 31 72 52
--
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] 3+ messages in thread
* Re: postgresql admin
2017-02-22 19:45 postgresql admin Gone, Sajan <SGone@lb.com>
2017-02-23 09:04 ` Re: postgresql admin Stéphane KANSCHINE <stephane@hexack.fr>
@ 2017-02-23 18:15 ` Gone, Sajan <SGone@lb.com>
0 siblings, 0 replies; 3+ messages in thread
From: Gone, Sajan @ 2017-02-23 18:15 UTC (permalink / raw)
To: Stéphane KANSCHINE <stephane@hexack.fr>; +Cc: pgsql-admin
Thanks Stephane.
This is very helpful. I will give it a try as recommended and keep you
posted on how it goes.
Appreciate your thoughts on this
Thank You,
Sajan Gone
Database Administrator
L Brands
Mobile #: 517-990-5282
Office #: 614-577-7622
On 2/23/17, 4:04 AM, "Stéphane KANSCHINE" <stephane@hexack.fr> wrote:
>Le mer. 22 févr., vers 19:45, Gone, Sajan exprimait :
>
>> Hi All,
>
>Hey !
>
>> Recently we have created coupIe of postgres instances in our
>> enterprise and I am pretty new to postgres DB administration.
>> All of these postgres instances are running on Solaris Smart OS
>> systems. We want to set up LDAP user access to our
>> team(Database) members and I am pretty new to LDAP and not
>> exactly sure how to set it LDAP on a posters server. Please let
>> me know the proper way to accomplish this.
>
>You just have to edit your pg_hba.conf like this (first result for ldap
>auth postgresql on duckduckgo) :
>https://urldefense.proofpoint.com/v2/url?u=https-3A__wiki.postgresql.org_w
>iki_LDAP-5FAuthentication-5Fagainst-5FAD&d=DwIDaQ&c=spYp1tZ3AQD6dfuI6rqaeg
>&r=7n1bLwXDzepgjKSNziw-ng&m=CSvWKT0KgiyWfvQcs6TQv69dAW6JUMt_K9jf6FADuPE&s=
>2O7ZLxYB6XZMWDiKVCQge19GGONOBHLF0N92c9iTh_I&e=
>
>Regards,
>--
>Stéphane KANSCHINE -
>https://urldefense.proofpoint.com/v2/url?u=http-3A__www.hexack.fr._&d=DwID
>aQ&c=spYp1tZ3AQD6dfuI6rqaeg&r=7n1bLwXDzepgjKSNziw-ng&m=CSvWKT0KgiyWfvQcs6T
>Qv69dAW6JUMt_K9jf6FADuPE&s=M9-WqHwYsqcmMw4JxsjR94pW4rkbb0tOuagO3nD26KU&e=
> -
>https://urldefense.proofpoint.com/v2/url?u=http-3A__www.nuajik.com._&d=DwI
>DaQ&c=spYp1tZ3AQD6dfuI6rqaeg&r=7n1bLwXDzepgjKSNziw-ng&m=CSvWKT0KgiyWfvQcs6
>TQv69dAW6JUMt_K9jf6FADuPE&s=16lAoVuYvrCr2c2KwjG8q4dwn4bBnOywprC5alOoxEI&e=
>
>＠ stephane@hexack.fr
> +33 6 64 31 72 52
________________________________
Notice: This communication may contain privileged and/or confidential information. If you are not the intended recipient, please notify the sender by email, and immediately delete the message and any attachments without copying or disclosing them. LB may, for any reason, intercept, access, use, and disclose any information that is communicated by or through, or which is stored on, its networks, applications, services, and devices.
--
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] 3+ messages in thread
end of thread, other threads:[~2017-02-23 18:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-02-22 19:45 postgresql admin Gone, Sajan <SGone@lb.com>
2017-02-23 09:04 ` Stéphane KANSCHINE <stephane@hexack.fr>
2017-02-23 18:15 ` Gone, Sajan <SGone@lb.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