Re: 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(at)Trick ~
$ ipc-daemon2 &
[2] 5152
[1] Exit 1 ipc-daemon2

Owner(at)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(at)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(at)Trick ~
> $ ipc-daemon2 &
> [2] 5152
> [1] Exit 1 ipc-daemon2
>
> Owner(at)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(at)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(at)(dot)

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(at)(dot)

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