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,

Reply via email to