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
Dear Stephen,
You're absolutely right, the mapping work very well.
I've created 2 "service user" on Active Directory (postgres and postgres_dev),
and generated the keytab like this:
ktpass -out postgres_pg1.keytab -princ postgres/pgdomt1.ad@ad.com -mapUser
AD\postgres -pass 'UserPass1'
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:
Dear Stephen,
If I understand, the mapping can be done in the pg_ident.conf file ?
Thank you very much for your workaround,
Jean-Philippe
De : Stephen Frost
Envoyé : 29 avril 2019 10:22
À : Jean-Philippe Chenel
Cc : pgsql-general@lists.postgresql.org
Objet :
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
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
>
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
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