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

From: Jean-Philippe Chenel <jp(dot)chenel(at)LIVE(dot)CA>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: 9.6.9 Default configuration for a default installation but different with-krb-srvnam
Date: 2019-04-26 13:18:51
Message-ID: BYAPR03MB44855415DF162E9E68CD2B68FD3E0@BYAPR03MB4485.namprd03.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 configured the GSSAPI authentication with MS Active Directory and it works very well.

The problem is that we have a dev and prod environment and each server must be configured with gssapi again the domain controller. The default user is "postgres" and it cannot be bound to both postgresql server at the same time to the same userPrincipalName on the Windows domain controller.

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 name? So one server will have the postgres user and the other one will have postgres_dev user.

2. I'm planning to shut down the postgresql service and then replace files generated by the make install command. After restarting the service, all will work as expected with the same database objects that were running before?

3. Maybe can we configure things differently, if something else can be done to make this work, I'm open to suggestions.

Currently these packages are installed from apt-get install, nothing special except gssapi authentication.

postgresql-9.6/now 9.6.9-2.pgdg16.04+1 amd64
postgresql-9.6-postgis-2.4/now 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-9.6-postgis-2.4-scripts/now 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-client-9.6/now 9.6.9-2.pgdg16.04+1 amd64
postgresql-client-common/now 191.pgdg16.04+1 all
postgresql-common/now 191.pgdg16.04+1 all
postgresql-contrib-9.6/now 9.6.9-2.pgdg16.04+1 amd64

With best regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2019-04-26 13:29:40 Re: 9.6.9 Default configuration for a default installation but different with-krb-srvnam
Previous Message Joe Wildish 2019-04-26 12:25:54 Re: Inexplicable UPDATE...RETURNING behaviour