The following bug has been logged online: Bug reference: 1446 Logged by: John Anson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0.5017 Operating system: Windows XP SP2 Description: MSI installion fails if the postgres database password contains an apostrophe Details:
The Windows installer fails if the postgres database password contains an apostrophe. When I used the password "post'gres" or "post'gres'", the installation failed with: PostgreSQL 8.0 -- Failed to run initdb: 1! (I've included the text from initdb.log below). When I used the password "''''", the installation failed with: - PostgreSQL 8.0 -- Failed to connect to the database. Procedural languages files are installed, but are not activated in any databases. - PostgreSQL 8.0 -- missing "=" after "''''" in connection info string D:\Program Files\PostgreSQL\8.0\tmp\initdb.log: The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory D:/Program Files/PostgreSQL/8.0/data ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/global ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/pg_xlog ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/pg_xlog/archive_status ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/pg_clog ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/pg_subtrans ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/base ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/base/1 ... ok creating directory D:/Program Files/PostgreSQL/8.0/data/pg_tblspc ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 1000 creating configuration files ... ok creating template1 database in D:/Program Files/PostgreSQL/8.0/data/base/1 ... ok initializing pg_shadow ... ok setting password ... FATAL: syntax error at or near "gres" at character 43 child process was terminated by signal 1 initdb: removing contents of data directory "D:/Program Files/PostgreSQL/8.0/data" ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
