Thread: PostgreSQL Problem on Windows XP

PostgreSQL Problem on Windows XP

From
Richard Kellner
Date:
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



Re: PostgreSQL Problem on Windows XP

From
mike g
Date:
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

Re: PostgreSQL Problem on Windows XP

From
Peter Eisentraut
Date:
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/


Re: PostgreSQL Problem on Windows XP

From
mike g
Date:
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?

Re: PostgreSQL Problem on Windows XP

From
mike g
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?

Re: PostgreSQL Problem on Windows XP

From
Peter Eisentraut
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/


Re: PostgreSQL Problem on Windows XP

From
Jason Tishler
Date:
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

Re: PostgreSQL Problem on Windows XP

From
Jason Tishler
Date:
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