Thread: PostgreSQL in Windows2000 PRO
Hi, I am trying to install PostGres in my machine with OS windows 2000 PRO as instructions in the site http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN, but I am not having success. I follow the instructions but when I am not able to init the db ( please see below ) . What´s wrong ? What may I do ? Thank you very much for the help, Victor Brazil/Rio de Janeiro/RJ c053102@CR7260ET292 ~ $ /usr/sbin/cygserver & [1] 1676 c053102@CR7260ET292 ~ $ cygserver: Initialization complete. Waiting for requests. initdb -D /usr/local/pgsql/data -W -E LATIN1 The files belonging to this database system will be owned by user "c053102". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pgsql/data/global... ok creating directory /usr/local/pgsql/data/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok selecting default max_connections... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 10 selecting default shared_buffers... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 initdb: failed initdb: removing data directory "/usr/local/pgsql/data" c053102@CR7260ET292 ~ $
Hi, The webpage you are using for the install are out of date. Cygserver is now used instead of ipc-daemon2. See the readme included now located in /usr/share/doc/Cygwin Mike On Wed, 2004-08-04 at 11:18, victor.filho@caixa.gov.br wrote: > Hi, > I am trying to install PostGres in my machine with OS windows 2000 PRO as instructions in the site http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN, but I am not having success. > > I follow the instructions but when I am not able to init the db ( please see below ) . > What´s wrong ? What may I do ? > > Thank you very much for the help, > > Victor > Brazil/Rio de Janeiro/RJ > > > c053102@CR7260ET292 ~ > $ /usr/sbin/cygserver & > [1] 1676 > > c053102@CR7260ET292 ~ > $ cygserver: Initialization complete. Waiting for requests. > initdb -D /usr/local/pgsql/data -W -E LATIN1 > The files belonging to this database system will be owned by user "c053102". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > creating directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 > > initdb: failed > initdb: removing data directory "/usr/local/pgsql/data" > > c053102@CR7260ET292 ~ > $ > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
Hi, Please double check that cygserver is actually running. It might fail to run. That could be due to various permission errors. Also, please double-check that you CYGWIN environment variable has been set to include the word "server", and that it's exportif you do this in bash. Mike G, the instructions on the website are no longer out of date! I just verified. They're updated as of 20-07-2004. --Tim -----Original Message----- From: pgsql-cygwin-owner@postgresql.org [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of victor.filho@caixa.gov.br Sent: woensdag 4 augustus 2004 18:19 To: pgsql-cygwin@postgresql.org Subject: [CYGWIN] PostgreSQL in Windows2000 PRO Hi, I am trying to install PostGres in my machine with OS windows 2000 PRO as instructions in the site http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN, but I am not having success. I follow the instructions but when I am not able to init the db ( please see below ) . What´s wrong ? What may I do ? Thank you very much for the help, Victor Brazil/Rio de Janeiro/RJ c053102@CR7260ET292 ~ $ /usr/sbin/cygserver & [1] 1676 c053102@CR7260ET292 ~ $ cygserver: Initialization complete. Waiting for requests. initdb -D /usr/local/pgsql/data -W -E LATIN1 The files belonging to this database system will be owned by user "c053102". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pgsql/data/global... ok creating directory /usr/local/pgsql/data/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok selecting default max_connections... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 10 selecting default shared_buffers... Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 Signal 12 50 creating configuration files... ok creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 initdb: failed initdb: removing data directory "/usr/local/pgsql/data" c053102@CR7260ET292 ~ $ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
Thanks for the heads up on the update to that webpage. Mike On Fri, 2004-08-06 at 05:18, Leeuw van der, Tim wrote: > Hi, > > Please double check that cygserver is actually running. It might fail to run. > That could be due to various permission errors. > > Also, please double-check that you CYGWIN environment variable has been set to include the word "server", and that it'sexport if you do this in bash. > > Mike G, the instructions on the website are no longer out of date! I just verified. They're updated as of 20-07-2004. > > --Tim > > -----Original Message----- > From: pgsql-cygwin-owner@postgresql.org > [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of > victor.filho@caixa.gov.br > Sent: woensdag 4 augustus 2004 18:19 > To: pgsql-cygwin@postgresql.org > Subject: [CYGWIN] PostgreSQL in Windows2000 PRO > > > Hi, > I am trying to install PostGres in my machine with OS windows 2000 PRO as instructions in the site http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN, but I am not having success. > > I follow the instructions but when I am not able to init the db ( please see below ) . > What´s wrong ? What may I do ? > > Thank you very much for the help, > > Victor > Brazil/Rio de Janeiro/RJ > > > c053102@CR7260ET292 ~ > $ /usr/sbin/cygserver & > [1] 1676 > > c053102@CR7260ET292 ~ > $ cygserver: Initialization complete. Waiting for requests. > initdb -D /usr/local/pgsql/data -W -E LATIN1 > The files belonging to this database system will be owned by user "c053102". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > creating directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > selecting default max_connections... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 10 > selecting default shared_buffers... Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > Signal 12 > 50 > creating configuration files... ok > creating template1 database in /usr/local/pgsql/data/base/1... Signal 12 > > initdb: failed > initdb: removing data directory "/usr/local/pgsql/data" > > c053102@CR7260ET292 ~ > $ > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html