Thread: PostgreSQL Problem on Windows XP
Hello, I attempted to install PostgreSQL on Windows XP according to the procedure in http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN There seems to be a problem with the ipc daemon, as the following happens: ========================= Owner@Trick ~ $ ipc-daemon2 & [2] 5152 [1] Exit 1 ipc-daemon2 Owner@Trick ~ $ initdb --pgdata=/usr/local/pgdata -W -E LATIN1 -d Running in debug mode. initdb: internal variables: PGDATA=/usr/local/pgdata datadir=/usr/share/postgresql PGPATH=/usr/bin ENCODING=LATIN1 ENCODINGID=8 POSTGRES_SUPERUSERNAME=Owner POSTGRES_BKI=/usr/share/postgresql/postgres.bki POSTGRES_DESCR=/usr/share/postgresql/postgres.description POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample The files belonging to this database system will be owned by user "Owner". This user must also own the server process. The database cluster will be initialized with locale C. creating directory /usr/local/pgdata... ok creating directory /usr/local/pgdata/base... ok creating directory /usr/local/pgdata/global... ok creating directory /usr/local/pgdata/pg_xlog... ok creating directory /usr/local/pgdata/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/pgdata/base/1... DEBUG: invoking IpcM emoryCreate(size=1081344) Signal 12 initdb: failed initdb: removing data directory "/usr/local/pgdata" Owner@Trick ~ ========================= Any suggestions? I have a gigabyte of memory and only 465 MB is being used, so there shouldn't be a problem with memory allocation. Thank you, Richard Kellner
Hello, Those instructions are out of date. ipc-daemon is no longer used. See the readme included with the installation particularly the cygserver info. Mike On Wed, 2004-07-14 at 12:31, Richard Kellner wrote: > Hello, > I attempted to install PostgreSQL on Windows XP according to the > procedure in http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN > > There seems to be a problem with the ipc daemon, as the following happens: > ========================= > > Owner@Trick ~ > $ ipc-daemon2 & > [2] 5152 > [1] Exit 1 ipc-daemon2 > > Owner@Trick ~ > $ initdb --pgdata=/usr/local/pgdata -W -E LATIN1 -d > Running in debug mode. > > initdb: internal variables: > PGDATA=/usr/local/pgdata > datadir=/usr/share/postgresql > PGPATH=/usr/bin > ENCODING=LATIN1 > ENCODINGID=8 > POSTGRES_SUPERUSERNAME=Owner > POSTGRES_BKI=/usr/share/postgresql/postgres.bki > POSTGRES_DESCR=/usr/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgresql.conf.sample > PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by user "Owner". > This user must also own the server process. > > The database cluster will be initialized with locale C. > > creating directory /usr/local/pgdata... ok > creating directory /usr/local/pgdata/base... ok > creating directory /usr/local/pgdata/global... ok > creating directory /usr/local/pgdata/pg_xlog... ok > creating directory /usr/local/pgdata/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/pgdata/base/1... DEBUG: > invoking IpcM > emoryCreate(size=1081344) > Signal 12 > > initdb: failed > initdb: removing data directory "/usr/local/pgdata" > > Owner@Trick ~ > > ========================= > Any suggestions? I have a gigabyte of memory and only 465 MB is being > used, so there shouldn't be a problem with memory allocation. > Thank you, > Richard Kellner > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend
mike g wrote: > Those instructions are out of date. ipc-daemon is no longer used. > See the readme included with the installation particularly the > cygserver info. Can you submit a patch to bring the instructions up to date? -- Peter Eisentraut http://developer.postgresql.org/~petere/
Sure, I will contact Robert to have the techdocs site updated. Mike On Sat, 2004-07-17 at 03:56, Peter Eisentraut wrote: > mike g wrote: > > Those instructions are out of date. ipc-daemon is no longer used. > > See the readme included with the installation particularly the > > cygserver info. > > Can you submit a patch to bring the instructions up to date?
Seems that the techdoc site redirects to a site Jason maintains. Jason, can you update this page with the current one included with the cygwin distro? http://www.tishler.net/jason/software/postgresql/postgresql-7.4.1.README Mike On Sat, 2004-07-17 at 03:56, Peter Eisentraut wrote: > mike g wrote: > > Those instructions are out of date. ipc-daemon is no longer used. > > See the readme included with the installation particularly the > > cygserver info. > > Can you submit a patch to bring the instructions up to date?
mike g wrote: > I will contact Robert to have the techdocs site updated. I would prefer a patch (or a replacement file) for doc/FAQ_MSWIN in the source tree. That should be the authorative installation instruction file. Part of the reason there is this confusion is that there are so many secondary places that claim different things. > > Mike > > On Sat, 2004-07-17 at 03:56, Peter Eisentraut wrote: > > mike g wrote: > > > Those instructions are out of date. ipc-daemon is no longer > > > used. See the readme included with the installation particularly > > > the cygserver info. > > > > Can you submit a patch to bring the instructions up to date? -- Peter Eisentraut http://developer.postgresql.org/~petere/
On Sat, Jul 17, 2004 at 11:26:32PM -0500, mike g wrote: > Jason, can you update this page with the current one included with the > cygwin distro? OK, I will send a patch to pgsql-patches@. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
On Mon, Jul 19, 2004 at 08:06:52AM -0400, Jason Tishler wrote: > On Sat, Jul 17, 2004 at 11:26:32PM -0500, mike g wrote: > > Jason, can you update this page with the current one included with > > the cygwin distro? > > OK, I will send a patch to pgsql-patches@. Done. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6