Problem with postgres initdb

Problem with postgres initdb

[Frank Streitzig]

Hi,

i have problem to init postgres database with initdb.
What can i do?
Cygserver and IPC Daemon is started.

Many thanks
Frank

$ initdb --debug -D /data/pgsql/data
Running in debug mode.

initdb: internal variables:
   PGDATA=/data/pgsql/data
   datadir=/usr/share/postgresql
   PGPATH=/usr/bin
   ENCODING=
   ENCODINGID=0
   POSTGRES_SUPERUSERNAME=frastr
   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 "frastr".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /data/pgsql/data... ok
creating directory /data/pgsql/data/base... ok
creating directory /data/pgsql/data/global... ok
creating directory /data/pgsql/data/pg_xlog... ok
creating directory /data/pgsql/data/pg_clog... ok
selecting default max_connections... /usr/bin/initdb: line 564:  3820 Bad  
system call         "$PGPATH"/postgres -boot -x0 $TEST_OPT template1  
</dev/null >/dev/null 2>&1
/usr/bin/initdb: line 564:  3792 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 564:  3840 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 564:  3820 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 564:  3864 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 564:  3848 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
10
selecting default shared_buffers... /usr/bin/initdb: line 578:  3628 Bad  
system call         "$PGPATH"/postgres -boot -x0 $TEST_OPT template1  
</dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3840 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3888 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3820 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3792 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3864 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3524 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3840 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3628 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3820 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
/usr/bin/initdb: line 578:  3888 Bad system call          
"$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1
50
creating configuration files... ok
creating template1 database in /data/pgsql/data/base/1... DEBUG:  invoking  
IpcMemoryCreate(size=1081344)
/usr/bin/initdb: line 644:  3812 Bad system call          
"$PGPATH"/postgres -boot -x1 $PGSQL_OPT $BOOTSTRAP_TALK_ARG template1

initdb: failed
initdb: removing data directory "/data/pgsql/data"

--
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/

Re: Problem with postgres initdb

[Igor Pechtchanski]

On Sat, 16 Jul 2005, Frank Streitzig wrote:

> i have problem to init postgres database with initdb.
> What can i do?
> Cygserver and IPC Daemon is started.
> [snip]
> $ initdb --debug -D /data/pgsql/data
> Running in debug mode.
> [snip]
> /usr/bin/initdb: line 564:  3792 Bad system call         "$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null 2>&1

This was reported as recently as 2 days ago.  See
<http://cygwin.com/ml/cygwin/2005-07/msg00679.html>.  In addition to the
"recommended reading" file from that message, see also (obviously)
/usr/share/doc/Cygwin/postgresql-*.README.
	Igor
-- 
				http://cs.nyu.edu/~pechtcha/
      |\      _,,,---,,_		pechtcha@cs.nyu.edu
ZZZzz /,`.-'`'    -.  ;-;;,_		igor@watson.ibm.com
     |,4-  ) )-,_. ,\ (  `'-'		Igor Pechtchanski, Ph.D.
    '---''(_/--'  `-'\_) fL	a.k.a JaguaR-R-R-r-r-r-.-.-.  Meow!

If there's any real truth it's that the entire multidimensional infinity
of the Universe is almost certainly being run by a bunch of maniacs. /DA

--
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/

Re: Problem with postgres initdb

[Frank Streitzig]

Hi Igor,

many thanks. I have forget to set enviroment variable CYGWIN=server.

Frank


Am Sun, 17 Jul 2005 05:42:07 +0200 schrieb Igor Pechtchanski  
<pechtcha@cs.nyu.edu>:

> On Sat, 16 Jul 2005, Frank Streitzig wrote:
>
>> i have problem to init postgres database with initdb.
>> What can i do?
>> Cygserver and IPC Daemon is started.
>> [snip]
>> $ initdb --debug -D /data/pgsql/data
>> Running in debug mode.
>> [snip]
>> /usr/bin/initdb: line 564:  3792 Bad system call          
>> "$PGPATH"/postgres -boot -x0 $TEST_OPT template1 </dev/null >/dev/null  
>> 2>&1
>
> This was reported as recently as 2 days ago.  See
> <http://cygwin.com/ml/cygwin/2005-07/msg00679.html>.  In addition to the
> "recommended reading" file from that message, see also (obviously)
> /usr/share/doc/Cygwin/postgresql-*.README.
> 	Igor



--
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/