Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Stephen Frost
Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: > You're absolutely right, the mapping work very well. Great, glad to hear it. > I've created 2 "service user" on Active Directory (postgres and > postgres_dev), and generated the keytab like this: > > ktpass -out postgres_pg1.keytab

RE: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Jean-Philippe Chenel
_ De : Stephen Frost Envoyé : 29 avril 2019 13:35 À : Jean-Philippe Chenel Cc : pgsql-general@lists.postgresql.org Objet : Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: &g

Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Stephen Frost
Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: > If I understand, the mapping can be done in the pg_ident.conf file ? No, you do the mapping in AD. Look at the '/princ' and '/mapuser' options used in the ktpass command here: https://info.crunchydata.com/blog/windows-active-directo

RE: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Jean-Philippe Chenel
: Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: > I've configured the GSSAPI authentication with MS Active Directory and it > works very well. Glad to hear that. > The problem i

Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-29 Thread Stephen Frost
Greetings, * Jean-Philippe Chenel (jp.che...@live.ca) wrote: > I've configured the GSSAPI authentication with MS Active Directory and it > works very well. Glad to hear that. > The problem is that we have a dev and prod environment and each server must > be configured with gssapi again the dom

Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-26 Thread Laurenz Albe
On Fri, 2019-04-26 at 20:25 +, Jean-Philippe Chenel wrote: > > > 1. So my question is, how can I compile this version of postgresql > > > (9.6.9) and have the same real things > > > of the default previously installed version, but with the > > > --with-krb-srvnam=POSTGRES_DEV to change the >

Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-26 Thread Laurenz Albe
On Fri, 2019-04-26 at 13:18 +, Jean-Philippe Chenel wrote: > 1. So my question is, how can I compile this version of postgresql (9.6.9) > and have the same real things > of the default previously installed version, but with the > --with-krb-srvnam=POSTGRES_DEV to change the > default user nam

9.6.9 Default configuration for a default installation but different with-krb-srvnam

2019-04-26 Thread Jean-Philippe Chenel
Hi, Currently, when I make select version(), this version is installed. PostgreSQL 9.6.9 on x86_64-pc-linux-gnu (Ubuntu 9.6.9-2.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609, 64-bit The database is running on the installation of Ubuntu 16.04 x64 I've configure