pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problems when initdb on WinXP with SP2.
5+ messages / 3 participants
[nested] [flat]

* Problems when initdb on WinXP with SP2.
@ 2005-11-24 10:02 Johnson Zhao <tianqi1981@gmail.com>
  2005-11-24 10:09 ` Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
  2005-11-26 19:07 ` Re: Problems when initdb on WinXP with SP2. Qingqing Zhou <zhouqq@cs.toronto.edu>
  2005-11-27 04:42 ` Re: Problems when initdb on WinXP with SP2. Thomas Harold <tgh@tgharold.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Johnson Zhao @ 2005-11-24 10:02 UTC (permalink / raw)
  To: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Problems when initdb on WinXP with SP2.
  2005-11-24 10:02 Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
@ 2005-11-24 10:09 ` Johnson Zhao <tianqi1981@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Johnson Zhao @ 2005-11-24 10:09 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Problems when initdb on WinXP with SP2.
  2005-11-24 10:02 Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
@ 2005-11-26 19:07 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
  2 siblings, 0 replies; 5+ messages in thread

From: Qingqing Zhou @ 2005-11-26 19:07 UTC (permalink / raw)
  To: pgsql-admin


"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 





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Problems when initdb on WinXP with SP2.
  2005-11-24 10:02 Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
@ 2005-11-27 04:42 ` Thomas Harold <tgh@tgharold.com>
  2005-11-28 02:03   ` Re: Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Thomas Harold @ 2005-11-27 04:42 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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).



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Problems when initdb on WinXP with SP2.
  2005-11-24 10:02 Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
  2005-11-27 04:42 ` Re: Problems when initdb on WinXP with SP2. Thomas Harold <tgh@tgharold.com>
@ 2005-11-28 02:03   ` Johnson Zhao <tianqi1981@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Johnson Zhao @ 2005-11-28 02:03 UTC (permalink / raw)
  To: Thomas Harold <tgh@tgharold.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2005-11-28 02:03 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-24 10:02 Problems when initdb on WinXP with SP2. Johnson Zhao <tianqi1981@gmail.com>
2005-11-24 10:09 ` Johnson Zhao <tianqi1981@gmail.com>
2005-11-26 19:07 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
2005-11-27 04:42 ` Thomas Harold <tgh@tgharold.com>
2005-11-28 02:03   ` Johnson Zhao <tianqi1981@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox