dbTalk Databases Forums  

[BUGS] BUG #1446: MSI installion fails if the postgres database password contains an apostrophe

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1446: MSI installion fails if the postgres database password contains an apostrophe in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Anson
 
Posts: n/a

Default [BUGS] BUG #1446: MSI installion fails if the postgres database password contains an apostrophe - 01-29-2005 , 01:48 PM







The following bug has been logged online:

Bug reference: 1446
Logged by: John Anson
Email address: postgres (AT) jomich (DOT) com
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 majordomo (AT) postgresql (DOT) org

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.