Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Message-ID:	<20040617131937.12818.qmail@web11002.mail.yahoo.com>
Date:	Thu, 17 Jun 2004 06:19:37 -0700 (PDT)
From:	Natalie Menk <n_menk AT yahoo DOT com>
Subject:	PostgreSQL: initdb fails with v7.4.2 - postmaster fork error with v7.4.1
To:	cygwin AT cygwin DOT com
MIME-Version:	1.0

The installed  cygwin is version 1.5.10-3 and I use cygipc 2.03-2.
MS Win XP 
--------------------------------

n AT n ~
$ psql --version
psql (PostgreSQL) 7.4.2
contains support for command-line editing

n AT n ~
$ ipc-daemon2 &
[1] 2840

n AT n ~
$ initdb -D edge_inline
The files belonging to this database system will be owned by user "n".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory edge_inline... ok
creating directory edge_inline/base... ok
creating directory edge_inline/global... ok
creating directory edge_inline/pg_xlog... ok
creating directory edge_inline/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 edge_inline/base/1... Signal 12

initdb: failed
initdb: removing data directory "edge_inline"



-----------------------------------------------------

n AT n ~
$ psql --version
psql (PostgreSQL) 7.4.1
contains support for command-line editing

n AT n ~
$ ipc-daemon2 &
[1] 3068

n AT n ~
$ initdb -D edge
The files belonging to this database system will be owned by user "n".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory edge... ok
creating directory edge/base... ok
creating directory edge/global... ok
creating directory edge/pg_xlog... ok
creating directory edge/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in edge/base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

    /usr/bin/postmaster -D edge
or
    /usr/bin/pg_ctl -D edge -l logfile start


n AT n ~
$ postmaster -D edge -h localhost -i
C:\cygwin\bin\postgres.exe (3460): *** fork: can't reserve memory for
stack 0x30
000 - 0x230000, Win32 error 487
      3 [main] postmaster 3408 sync_with_child: child 3460(0x294) died
before in
itialization with status code 0x1
    303 [main] postmaster 3408 sync_with_child: *** child state waiting
for long
jmp
LOG:  could not fork statistics buffer: Resource temporarily
unavailable
C:\cygwin\bin\postgres.exe (3716): *** fork: can't reserve memory for
stack 0x30
000 - 0x230000, Win32 error 487
  25796 [main] postmaster 3408 sync_with_child: child 3716(0x280) died
before in
itialization with status code 0x1
  26118 [main] postmaster 3408 sync_with_child: *** child state waiting
for long
jmp
LOG:  could not fork startup process: Resource temporarily unavailable



		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -