Skip site navigation (1) Skip section navigation (2)

Re: initdb failing

From: "Hussein Badakhchani" <hussein(at)xensia(dot)com>
To: <pgsql-cygwin-owner(at)postgresql(dot)org>
Subject: Re: initdb failing
Date: 2004-08-06 09:11:24
Message-ID: 12234.195.171.114.12.1091783484.squirrel@www.xplatform.org (view raw or flat)
Thread:
Lists: pgsql-cygwin
Thanks Dan,

Also I had to increase the SEMMNS and SEMMSL numbers in /etc/cygserver.conf.
The values that worked for me are:

kern.ipc.semmns 100
kern.ipc.semmsl 600

Thanks,
Hoos



> Hey Hussein,
>
> Before you type in "$ initdb -d -D /usr/local/pgsql/data", make sure you
> type in:
>
> export CYGWIN=server
>
> That should do it.
>
> Dan
>
> -----Original Message-----
> From: pgsql-cygwin-owner(at)postgresql(dot)org
> [mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of Hussein
> Badakhchani
> Sent: Thursday, August 05, 2004 10:54 PM
> To: pgsql-cygwin(at)postgresql(dot)org
> Subject: [CYGWIN] initdb failing
>
>
> Hello
>
> My platform is:
>
> Windows 2000 sp4
> Cygwin 1.5.10-3
> Postgresql 7.4.3.1
>
> As per the instructions I start cygserver in the background and then run
> initdb:
>
> v&p(dot)test(at)DOW2K00028396 ~
> $ initdb -d -D /usr/local/pgsql/data
> Running in debug mode.
>
> initdb: internal variables:
>   PGDATA=/usr/local/pgsql/data
>   datadir=/usr/share/postgresql
>   PGPATH=/usr/bin
>   ENCODING=
>   ENCODINGID=0
>   POSTGRES_SUPERUSERNAME=v&p.test
>   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
> "v&p.test".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory /usr/local/pgsql/data... ok
> creating directory /usr/local/pgsql/data/base... ok
> creating directory /usr/local/pgsql/data/global... ok
> creating directory /usr/local/pgsql/data/pg_xlog... ok
> creating directory /usr/local/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 /usr/local/pgsql/data/base/1... DEBUG:
> invoking
> IpcMemoryCreate(size=1081344)
> Signal 12
>
> initdb: failed
> initdb: removing data directory "/usr/local/pgsql/data"
>
> Cygcheck:
>
> Cygwin Package Information
> Package              Version            Status
> _update-info-dir     00227-1            OK
> ash                  20040127-1         OK
> base-files           2.6-1              OK
> base-passwd          1.1-1              OK
> bash                 2.05b-16           OK
> bzip2                1.0.2-5            OK
> crypt                1.1-1              OK
> cygipc               2.03-2             OK
> cygrunsrv            1.0-1              OK
> cygutils             1.2.5-1            OK
> cygwin               1.5.10-3           OK
> cygwin-doc           1.3-7              OK
> diffutils            2.8.7-1            OK
> editrights           1.01-1             OK
> fileutils            4.1-2              OK
> findutils            4.1.7-4            OK
> gawk                 3.1.4-3            OK
> gdbm                 1.8.3-7            OK
> grep                 2.5-1              OK
> groff                1.18.1-2           OK
> gzip                 1.3.5-1            OK
> less                 381-1              OK
> libbz2_1             1.0.2-5            OK
> libgdbm              1.8.0-5            OK
> libgdbm-devel        1.8.3-7            OK
> libgdbm3             1.8.3-3            OK
> libgdbm4             1.8.3-7            OK
> libgettextpo0        0.14.1-1           OK
> libiconv2            1.9.2-1            OK
> libintl1             0.10.40-1          OK
> libintl2             0.12.1-3           OK
> libintl3             0.14.1-1           OK
> libncurses5          5.2-1              OK
> libncurses6          5.2-8              OK
> libncurses7          5.3-4              OK
> libpcre              4.1-1              OK
> libpcre0             4.5-1              OK
> libpopt0             1.6.4-4            OK
> libreadline4         4.1-2              OK
> libreadline5         4.3-5              OK
> login                1.9-7              OK
> man                  1.5k-3             OK
> mktemp               1.5-3              OK
> ncurses              5.3-4              OK
> openssl              0.9.7d-1           OK
> postgresql           7.4.3-1            OK
> readline             4.3-5              OK
> sed                  4.0.9-2            OK
> sh-utils             2.0.15-4           OK
> tar                  1.13.25-5          OK
> termcap              20021106-2         OK
> terminfo             5.3_20030726-1     OK
> texinfo              4.2-4              OK
> textutils            2.0.21-1           OK
> vim                  6.3-1              OK
> which                1.5-2              OK
> zlib                 1.2.1-1            OK
>
> I have installed postgresql on cygwin in the past no problem, this is
> the first time have come across this error. When I installed cygwin I
> had some jip regarding users and had to update my /etc/passwd file:
>
> SYSTEM:*:18:544:,S-1-5-18::
> Administrators:*:544:544:,S-1-5-32-544::
> bacs_admin:unused_by_nt/2000/xp:500:513:U-DOW2K00028396\bacs_admin,S-1-5-21-
> 2016
> 221598-611480373-1244091144-500:/home/bacs_admin:/bin/bash
> bacs_guest:unused_by_nt/2000/xp:501:513:U-DOW2K00028396\bacs_guest,S-1-5-21-
> 2016
> 221598-611480373-1244091144-501:/home/bacs_guest:/bin/bash
> v&p.test:*:502:545:/home/v&p.test:/bin/bash
>
> Thaks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




In response to

pgsql-cygwin by date

Next:From: Leeuw van der, TimDate: 2004-08-06 10:12:43
Subject: Re: Help with initdb
Previous:From: mike gDate: 2004-08-06 04:57:52
Subject: Re: WARNING: dup(0) failed after 3195 successes: Bad file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group