Обсуждение: [BUGS] BUG #14794: Installation failure if user specify French password
[BUGS] BUG #14794: Installation failure if user specify French password
От
vinod.t.v@outlook.com
Дата:
The following bug has been logged on the website: Bug reference: 14794 Logged by: vinod tv Email address: vinod.t.v@outlook.com PostgreSQL version: 9.6.2 Operating system: French Windows OS Description: I have specified Télécharger as the password during postgres installation in french OS. installation failed. Logs:- [15:10:43] Write the version number to the ini file... Initialisation du cluster de bases de données (cela peut prendre un certain temps)... Executing cscript //NoLogo "C:\Program Files\PostgreSQL\9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Program Files\PostgreSQL\9.6" "C:\Program Files\PostgreSQL\9.6\data" 5432 "DEFAULT" 0 Script exit code: 1 Script output:WScript.Shell Initialized... Scripting.FileSystemObject initialized... Called CreateDirectory(C:\Program Files\PostgreSQL\9.6\data)... Called CreateDirectory(C:\Program Files\PostgreSQL\9.6)... WScript.Network initialized... strParentOfDataDirC:\Program Files\PostgreSQL\9.6 logged in userFrench-win7\Admin Called AclCheck(C:\Program Files\PostgreSQL\9.6\data) Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:6.1 MajorVersion:6 Executing icacls to ensure the French-win7\Admin account can read the path C:\Program Files\PostgreSQL\9.6\data Executing batch file 'rad2B5A2.bat'... fichier trait'˜: C:\Program Files\PostgreSQL\9.6\data 1 fichiers correctement trait's˜; 'chec du traitement de 0 fichiers Called IsVistaOrNewer()... 'winmgmts' object initialized... Version:6.1 MajorVersion:6 Ensuring we can write to the data directory (using icacls) to French-win7\Admin: Executing batch file 'rad2B5A2.bat'... fichier trait'˜: C:\Program Files\PostgreSQL\9.6\data 1 fichiers correctement trait's˜; 'chec du traitement de 0 fichiers Executing batch file 'rad2B5A2.bat'... Les fichiers de ce cluster appartiendront … l'utilisateur ® Admin ¯. Le processus serveur doit ‚galement lui appartenir. L'instance sera initialis‚e avec la locale ® French_France.1252 ¯. La configuration de la recherche plein texte a ‚t‚ initialis‚e … ® french ¯. Les sommes de contr“les des pages de donn‚es sont d‚sactiv‚es. correction des droits sur le r‚pertoire existant C:/Program Files/PostgreSQL/9.6/data... ok cr‚ation des sous-r‚pertoires... ok s‚lection de la valeur par d‚faut de max_connections... 100 s‚lection de la valeur par d‚faut pour shared_buffers... 128MB s‚lection de l'impl‚mentation de la m‚moire partag‚e dynamique...windows cr‚ation des fichiers de configuration... ok lancement du script bootstrap...ok ex‚cution de l'initialisation aprŠs bootstrap...FATAL: sǸquence d'octets invalide pour l'encodage ¶® UTF8 ¶¯ : 0xe0 0x74 0x27 le processus fils a quitt‚ avec le code de sortie 1 initdb : suppression du contenu du r‚pertoire des donn‚es ® C:/Program Files/PostgreSQL/9.6/data ¯ Called Die(Failed to initialise the database cluster with initdb)... Failed to initialise the database cluster with initdb Script stderr:Program ended with an error exit code Erreur dans l'exécution de cscript //NoLogo "C:\Program Files\PostgreSQL\9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\Program Files\PostgreSQL\9.6" "C:\Program Files\PostgreSQL\9.6\data" 5432 "DEFAULT" 0 : Program ended with an error exit code Un problème est survenu lors de l'exécution de l'étape de post-installation. L'installation peut avoir échouéL'initialisation du cluster de bases de données a échoué. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
On Fri, Sep 01, 2017 at 10:15:37AM +0000, vinod.t.v@outlook.com wrote: > I have specified > Télécharger as the password during postgres installation in french OS. > installation failed. > ex‚cution de l'initialisation aprŠs bootstrap...FATAL: sǸquence d'octets > invalide pour l'encodage ¶® UTF8 ¶¯ : 0xe0 0x74 0x27 This is a character encoding mismatch. Within an established database session, PostgreSQL has robust encoding conversion. During initdb and connection establishment, encoding treatment is much more primitive. This has been on https://wiki.postgresql.org/wiki/Todo for years, and fixing it is low priority. I recommend using only ASCII in user names, passwords, and database names. If you still want this, set an ASCII password during installation, and then change it with ALTER USER. This will work well only if all your client software sends the password in the same encoding as the database where you issue ALTER USER (probably UTF8). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs