Re: initdb: failed

estoy usando Win2k y ipc-daemon2.exe y me da los sgtes.errores:
tb tengo el Pg8.0 que funcina bien pero el cygwin NO.
alguna sugerencia???

Your group is currently "mkpasswd". This indicates that
the /etc/passwd (and possibly /etc/group) files should be rebuilt.
See the man pages for mkpasswd and mkgroup then, for example, run
mkpasswd -l [-d] > /etc/passwd
mkgroup -l [-d] > /etc/group
Note that the -d switch is necessary for domain users.

sandrigo(at)desenv10 ~
$ ipc-daemon2.exe &
[1] 748

sandrigo(at)desenv10 ~
$ ps aux
PID PPID PGID WINPID TTY UID STIME COMMAND
1352 1 1352 1352 con 400 08:17:05 /usr/bin/bash
748 1352 748 1388 con 400 08:17:29 /usr/bin/ipc-daemon2
928 1352 928 1416 con 400 08:17:43 /usr/bin/ps

sandrigo(at)desenv10 ~
$ initdb -D /var/lib/pgsql/data -U postgres
The files belonging to this database system will be owned by user
"sandrigo".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /var/lib/pgsql/data... ok
creating directory /var/lib/pgsql/data/base... ok
creating directory /var/lib/pgsql/data/global... ok
creating directory /var/lib/pgsql/data/pg_xlog... ok
creating directory /var/lib/pgsql/data/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 /var/lib/pgsql/data/base/1... Signal 12

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

sandrigo(at)desenv10 ~
$

--
___________________________________
sandrigo(dot)lezcano(at)gmail(dot)com
RUA INDEPENDENCIA 135 - BOA VISTA
CEP 06411-050 - Barueri/SP/Brazil
FONE 11 4198-1095
Vip-Systems Informatica
http://www.vip-systems.com.br

Postgres 8.0 funciona de forma nativa en Windows, no usa cygwin.

On Wed, 23 Feb 2005 08:28:48 -0300, sandrigo(dot)lezcano(at)gmail(dot)com
<sandrigo(dot)lezcano(at)gmail(dot)com> wrote:
> estoy usando Win2k y ipc-daemon2.exe y me da los sgtes.errores:
> tb tengo el Pg8.0 que funcina bien pero el cygwin NO.
> alguna sugerencia???
>
> Your group is currently "mkpasswd". This indicates that
> the /etc/passwd (and possibly /etc/group) files should be rebuilt.
> See the man pages for mkpasswd and mkgroup then, for example, run
> mkpasswd -l [-d] > /etc/passwd
> mkgroup -l [-d] > /etc/group
> Note that the -d switch is necessary for domain users.
>
> sandrigo(at)desenv10 ~
> $ ipc-daemon2.exe &
> [1] 748
>
> sandrigo(at)desenv10 ~
> $ ps aux
> PID PPID PGID WINPID TTY UID STIME COMMAND
> 1352 1 1352 1352 con 400 08:17:05 /usr/bin/bash
> 748 1352 748 1388 con 400 08:17:29 /usr/bin/ipc-daemon2
> 928 1352 928 1416 con 400 08:17:43 /usr/bin/ps
>
> sandrigo(at)desenv10 ~
> $ initdb -D /var/lib/pgsql/data -U postgres
> The files belonging to this database system will be owned by user
> "sandrigo".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory /var/lib/pgsql/data... ok
> creating directory /var/lib/pgsql/data/base... ok
> creating directory /var/lib/pgsql/data/global... ok
> creating directory /var/lib/pgsql/data/pg_xlog... ok
> creating directory /var/lib/pgsql/data/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 /var/lib/pgsql/data/base/1... Signal 12
>
> initdb: failed
> initdb: removing data directory "/var/lib/pgsql/data"
>
> sandrigo(at)desenv10 ~
> $
>
> --
> ___________________________________
> sandrigo(dot)lezcano(at)gmail(dot)com
> RUA INDEPENDENCIA 135 - BOA VISTA
> CEP 06411-050 - Barueri/SP/Brazil
> FONE 11 4198-1095
> Vip-Systems Informatica
> http://www.vip-systems.com.br
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 1: para suscribirte y desuscribirte, escribe a majordomo(at)postgresql(dot)org
>

--
Juanky Moral
"Tendré que moverme más rápido: el horizonte brilla eléctrico."
(Horizonte Eléctrico - www.losdeltonos.com )

perdon!!! me exprese MAL.. lo q quise decir es que la version nativa
win Pg8.0
funciona bien!! sin problemas
pero lo del cygwin1.4 q creo viene con el Pg7.4.5 no estoy
consiguiendo inicializar la BD..

Juanky Moral escreveu:

>Postgres 8.0 funciona de forma nativa en Windows, no usa cygwin.
>
>
>On Wed, 23 Feb 2005 08:28:48 -0300, sandrigo(dot)lezcano(at)gmail(dot)com
><sandrigo(dot)lezcano(at)gmail(dot)com> wrote:
>
>
>>estoy usando Win2k y ipc-daemon2.exe y me da los sgtes.errores:
>>tb tengo el Pg8.0 que funcina bien pero el cygwin NO.
>>alguna sugerencia???
>>
>>Your group is currently "mkpasswd". This indicates that
>>the /etc/passwd (and possibly /etc/group) files should be rebuilt.
>>See the man pages for mkpasswd and mkgroup then, for example, run
>>mkpasswd -l [-d] > /etc/passwd
>>mkgroup -l [-d] > /etc/group
>>Note that the -d switch is necessary for domain users.
>>
>>sandrigo(at)desenv10 ~
>>$ ipc-daemon2.exe &
>>[1] 748
>>
>>sandrigo(at)desenv10 ~
>>$ ps aux
>> PID PPID PGID WINPID TTY UID STIME COMMAND
>> 1352 1 1352 1352 con 400 08:17:05 /usr/bin/bash
>> 748 1352 748 1388 con 400 08:17:29 /usr/bin/ipc-daemon2
>> 928 1352 928 1416 con 400 08:17:43 /usr/bin/ps
>>
>>sandrigo(at)desenv10 ~
>>$ initdb -D /var/lib/pgsql/data -U postgres
>>The files belonging to this database system will be owned by user
>>"sandrigo".
>>This user must also own the server process.
>>
>>The database cluster will be initialized with locale C.
>>
>>creating directory /var/lib/pgsql/data... ok
>>creating directory /var/lib/pgsql/data/base... ok
>>creating directory /var/lib/pgsql/data/global... ok
>>creating directory /var/lib/pgsql/data/pg_xlog... ok
>>creating directory /var/lib/pgsql/data/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 /var/lib/pgsql/data/base/1... Signal 12
>>
>>initdb: failed
>>initdb: removing data directory "/var/lib/pgsql/data"
>>
>>sandrigo(at)desenv10 ~
>>$
>>
>>--
>>___________________________________
>>sandrigo(dot)lezcano(at)gmail(dot)com
>>RUA INDEPENDENCIA 135 - BOA VISTA
>>CEP 06411-050 - Barueri/SP/Brazil
>>FONE 11 4198-1095
>>Vip-Systems Informatica
>>http://www.vip-systems.com.br
>>
>>---------------------------(fin del mensaje)---------------------------
>>TIP 1: para suscribirte y desuscribirte, escribe a majordomo(at)postgresql(dot)org
>>
>>
>>
>
>
>
>

--
___________________________________
sandrigo(dot)lezcano(at)gmail(dot)com
RUA INDEPENDENCIA 135 - BOA VISTA
CEP 06411-050 - Barueri/SP/Brazil
FONE 11 4198-1095
Vip-Systems Informatica
http://www.vip-systems.com.br

intenta primero hacer lo que te dice:
mkpasswd -l /etc/passwd
mkgroup -l /etc/group

despues intenta con estos scripts, yo lo he solucionado con cygwin y con
estos scriptts de la siguente forma:

Primero - dejo estos tres scripts en c:\cygwin\
1 pgini
2 db-start
3 db-stop

Segundo - La vesion 7.4.5 de postgres sobre cygwin no me ha trabajado
con el ipc-daemon2.exe sino con el cygserver
para esto utilizo el primer script (pgini) el cual te pregunta si deseas
sobreescribir la configuracion del cygserver
a esto yo le digo "yes" despues te pregunta si quieres dejarlo como un
servicio y a esto digo que "no" arranca el cygserver
y ejecuta initdb sobre "/usr/local/pgsql/data" .

Tercero - Para ejecutar el servidor de postgres ahora solo es necesario
ejecutar el segundo script(db-start)
y para pararlo el tercero.

*No me doy el credito por esto pero no recuerdo de donde obtuve esta
informacion y los scripts pero
fue de gran ayuda ademas creo que los scripts son muy claros.

*******pgini******
___________________________________
#!/bin/sh
mportant set-variable
CYGWIN=server
export CYGWIN
# the second very important set-variable - to unset it worked for me
(then language-setting is C).
unset LANG
echo
# the third very important set-variable
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
#echo "IPC-Daemon starten..."
echo
echo "cygserver-config starting..."
cygserver-config
echo "sygserver starten..."
cygserver &
ps -f
echo
echo "initdb starting..."
initdb -E latin1 -D /usr/local/pgsql/data
ps -f
___________________________________

*****db-start*****
___________________________________
#!/bin/sh
CYGWIN=server
export CYGWIN
PATH=/usr/bin:/usr/sbin:$PATH
export PATH
echo
echo "sygserver starting..."
cygserver &
ps -f
echo
echo "PostgreSQL starting..."
postmaster -D /usr/local/pgsql/data &
ps -f
___________________________________

*****db-stop*****
___________________________________
#!/bin/sh
echo
echo "PostgreSQL finishing..."
pg_ctl stop -w -D /usr/local/pgsql/data -s -m smart
ps -f
echo
echo "cygserver finishing..."
kill $(ps -f | grep cygserver | awk '{print $2}')
ps -f
___________________________________

sandrigo(dot)lezcano(at)gmail(dot)com escribió:

> estoy usando Win2k y ipc-daemon2.exe y me da los sgtes.errores:
> tb tengo el Pg8.0 que funcina bien pero el cygwin NO.
> alguna sugerencia???
>
> Your group is currently "mkpasswd". This indicates that
> the /etc/passwd (and possibly /etc/group) files should be rebuilt.
> See the man pages for mkpasswd and mkgroup then, for example, run
> mkpasswd -l [-d] > /etc/passwd
> mkgroup -l [-d] > /etc/group
> Note that the -d switch is necessary for domain users.
> sandrigo(at)desenv10 ~
> $
>