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@symcor.com 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@symcor.com. Vous continuerez de recevoir les messages d’affaires courants de Symcor.