From: | Yogi Barot <YBarot(at)symcor(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Postgresql 9.6 restriction |
Date: | 2016-10-24 12:32:41 |
Message-ID: | baad2ddcbe0c42049b27f162993291f3@MX002.symprod.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I want to upgrade my database from postgresql 9.2.15 to 9.6, we have username start with pg_abc_c as sysadmin user, all our installation owned by pg_ users. Now issue is with postgresql 9.6 onwards, you can't create role/user with pg_* when initialize system.
* Treat role names beginning with pg_ as reserved (Stephen Frost)
* User creation of such role names is now disallowed. This prevents conflicts with built-in roles created by initdb.
What are options for me? We use pam authentication. I tried using pg_ident.conf to map users, but it does not work with our authentication method.
authentication option "map" is only valid for authentication methods ident, peer, gssapi, sspi, and cert
Please help.
Thanks,
Yogi
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Kristensen | 2016-10-24 13:14:07 | Re: PostgresSQL 9.5 and systemd autorestart but without replication. |
Previous Message | Poul Kristensen | 2016-10-24 12:26:28 | Re: PostgresSQL 9.5 and systemd autorestart but without replication. |