Thread: Problems when initdb on WinXP with SP2.
Hi, I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems. run the windows cmd by: runas /user:postgres cmd and run the initdb program like: initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data then it says: creating directory ../data/ ... ok creating directory ../data/global ... ok creating directory ../data/pg_xlog ... ok creating directory ../data/pg_xlog/archive_status ... ok creating directory ../data/pg_clog ... ok creating directory ../data/pg_subtrans ... ok creating directory ../data/base ... ok creating directory ../data/base/1 ... ok creating directory ../data/pg_tblspc ... ok selecting default max_connections .... and the command window stayed there! I'm newbie at postgresql, anyone can give me some help, thanks a lot.
"Johnson Zhao" <tianqi1981@gmail.com> wrote > > run the windows cmd by: > > runas /user:postgres cmd > > and run the initdb program like: > > initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data > > then it says: > > creating directory ../data/ ... ok > creating directory ../data/global ... ok > creating directory ../data/pg_xlog ... ok > creating directory ../data/pg_xlog/archive_status ... ok > creating directory ../data/pg_clog ... ok > creating directory ../data/pg_subtrans ... ok > creating directory ../data/base ... ok > creating directory ../data/base/1 ... ok > creating directory ../data/pg_tblspc ... ok > selecting default max_connections .... > > and the command window stayed there! > I can't reproduce your problem. Did you set some odd permission to user "postgres"? Let's simplify it first, is there any problem if you login to windows as "postgres" first, then do your initdb? Regards, Qingqing
Johnson Zhao wrote: > Hi, > > I use Postgresql 8.03/ 8.04 on windows xp with sp2, all have same problems. > > run the windows cmd by: > > runas /user:postgres cmd > > and run the initdb program like: > > initdb --locale=C --username=postgres -W -A md5 -E UNICODE -D ../data > > then it says: > > creating directory ../data/ ... ok > creating directory ../data/global ... ok > creating directory ../data/pg_xlog ... ok > creating directory ../data/pg_xlog/archive_status ... ok > creating directory ../data/pg_clog ... ok > creating directory ../data/pg_subtrans ... ok > creating directory ../data/base ... ok > creating directory ../data/base/1 ... ok > creating directory ../data/pg_tblspc ... ok > selecting default max_connections .... > > and the command window stayed there! I have no idea whether this matters or not, but I got bit during an 8.1 install by permissions issues. The postgres user requires read/write permissions for the data folder and below, but it also requires read permissions all the way back to the root of the drive (including the root directory). The specific situation for us was that we were trying to install to D:\PostgreSQL\Data, but the postgres user didn't have read permissions on the root of D:\ (or D:\PostgreSQL).
Hi, I 'm Johnson Zhao, thank you all. I tried to reinstall the postgresql server without initing the database, after installed then "initdb", all run. So the problem was solved. Is PostgreSQL can't init the database more than one time? I think this will not be a good peculiarity.