|
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 |
CONFIDENTIALITY WARNING
This communication, including any attachments, is for the exclusive use of
addressee and may contain proprietary and/or confidential information. If you
are not the intended recipient, any use, copying, disclosure, dissemination or
distribution is strictly prohibited. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
communication and destroy all copies.
Symcor 1 Robert Speck Parkway, Suite 400, Mississauga, Ontario, Canada
L4Z 4E7 www.symcor.com
To unsubscribe from receiving promotional messages from Symcor, email
“unsubscribe” to privacy@xxxxxxxxxx
You will continue to receive regular business communications from Symcor.
AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage
exclusif de la personne à laquelle il s’adresse et peut contenir de
l’information personnelle ou confidentielle. Si le lecteur de ce message n’en
est pas le destinataire, nous l’avisons par la présente que toute diffusion,
distribution, reproduction ou utilisation de son contenu est strictement
interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier
électronique et supprimez ce message ainsi que toutes les pièces jointes.
Symcor, 1 Robert Speck Parkway, bureau 400, Mississauga, Ontario, Canada L4Z
4E7 www.symcor.com
– Pour cesser de recevoir les messages promotionnels de Symcor, veuillez
envoyer un courriel portant la mention « Désinscription » à privacy@xxxxxxxxxx.
Vous continuerez de recevoir les messages d’affaires courants de Symcor.
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
