Thread: initdb failing !

initdb failing !

From

S R

Date:

26 July 2004, 01:51:37

I am trying to (for the first time) setup PostgreSQL
(version 7.4.3) on my windows 2000 box. I have cygwin
(version 1.5.10) installed and running. However, when
I give "initdb -D /usr/local/pgsql/data" command in a
cygwin window, I get an error "initdb failed".
Following is the dump on the screen (when the command
is run with -d option):

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

initdb: internal variables:
  PGDATA=/usr/local/pgsql/data
  datadir=/usr/share/postgresql
  PGPATH=/usr/bin
  ENCODING=
  ENCODINGID=0
  POSTGRES_SUPERUSERNAME=Jaguar
  POSTGRES_BKI=/usr/share/postgresql/postgres.bki

POSTGRES_DESCR=/usr/share/postgresql/postgres.descrip

POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgres

PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sampl

PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.s
The files belonging to this database system will be
own
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
Signal 12
2
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/ba
IpcMemoryCreate(size=950272)
Signal 12

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

--------------------------------------------
Any pointers ? It will be great help.

Thanks,
SR



__________________________________
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.
http://messenger.yahoo.com

Re: initdb failing !

From

mike g

Date:

26 July 2004, 02:36:21

Hello,

Signal 12 indicates that cygserver is either not running or not in your
path.

The readme included with the postgresql install has the instructions for
setting up cygserver.

Mike
On Sun, 2004-07-25 at 20:51, S R wrote:
> I am trying to (for the first time) setup PostgreSQL
> (version 7.4.3) on my windows 2000 box. I have cygwin
> (version 1.5.10) installed and running. However, when
> I give "initdb -D /usr/local/pgsql/data" command in a
> cygwin window, I get an error "initdb failed".
> Following is the dump on the screen (when the command
> is run with -d option):
>
> -------------------------------------------------
> $ initdb -D /usr/local/pgsql/data -d
> Running in debug mode.
>
> initdb: internal variables:
>   PGDATA=/usr/local/pgsql/data
>   datadir=/usr/share/postgresql
>   PGPATH=/usr/bin
>   ENCODING=
>   ENCODINGID=0
>   POSTGRES_SUPERUSERNAME=Jaguar
>   POSTGRES_BKI=/usr/share/postgresql/postgres.bki
>
> POSTGRES_DESCR=/usr/share/postgresql/postgres.descrip
>
> POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgres
>
> PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sampl
>
> PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.s
> The files belonging to this database system will be
> own
> 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
> Signal 12
> 2
> 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/ba
> IpcMemoryCreate(size=950272)
> Signal 12
>
> initdb: failed
> initdb: removing data directory
> "/usr/local/pgsql/data"
>
> --------------------------------------------
> Any pointers ? It will be great help.
>
> Thanks,
> SR
>
>
>
> __________________________________
> Do you Yahoo!?
> Y! Messenger - Communicate in real time. Download now.
> http://messenger.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Re: initdb failing !

From

S R

Date:

28 July 2004, 02:31:36

Thanks Daniel. That did it. I was missing this
important step. I do not think I saw it in any of the
documents.

Regards,
SR

--- Daniel Secomb <dan@ds-d.com> wrote:
> Run the following in your shell before running
> cygserver:
>
> export CYGWIN=server
>
> That should do it.
>
>
> Kind Regards,
>
> Daniel Secomb
> Creative Director
> DS Design
> ABN 33 721 455 978
> PO Box 4540,
> Lake Haven NSW 2263
> Australia
> [p] +61 2 4393 6305
> [f] +61 2 4393 6306
> [m] +61414 571 500
> mailto:dan@ds-d.com
> http://www.ds-d.com/
>
> Take a look at our latest web development project:
> http://www.specialfx.com.au/
>
> From the US, UK or Europe? Why not take advantage of
> the weaker Australian
> dollar? Click the following link
> http://www.xe.com/ucc/ for a currency
> conversion and find out how much you'll save!!
>
>
_________________________________________________________________
>
> The material contained in this email may be
> confidential, and may also be
> the subject of copyright and/or privileged
> information. If you are not the
> intended recipient, any use, disclosure or copying
> of this document is
> prohibited. If you have received this document in
> error, please advise the
> sender and delete the document.
>
> This email communication does not create or vary any
> contractual
> relationship between DS Design and you. Internet
> communications are not
> secure and accordingly DS Design does not accept any
> legal liability for the
> contents of this message.
>
> Please note that neither DS Design nor the sender
> accepts any responsibility
> for viruses and it is your responsibility to scan
> the email and any
> attachments.
>
>
>
> -----Original Message-----
> From: pgsql-cygwin-owner@postgresql.org
> [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf
> Of S R
> Sent: Monday, July 26, 2004 11:51 AM
> To: pgsql-cygwin@postgresql.org
> Cc: irq7service@yahoo.com
> Subject: [CYGWIN] initdb failing !
>
>
> I am trying to (for the first time) setup PostgreSQL
> (version 7.4.3) on my windows 2000 box. I have
> cygwin
> (version 1.5.10) installed and running. However,
> when
> I give "initdb -D /usr/local/pgsql/data" command in
> a
> cygwin window, I get an error "initdb failed".
> Following is the dump on the screen (when the
> command
> is run with -d option):
>
> -------------------------------------------------
> $ initdb -D /usr/local/pgsql/data -d
> Running in debug mode.
>
> initdb: internal variables:
>   PGDATA=/usr/local/pgsql/data
>   datadir=/usr/share/postgresql
>   PGPATH=/usr/bin
>   ENCODING=
>   ENCODINGID=0
>   POSTGRES_SUPERUSERNAME=Jaguar
>   POSTGRES_BKI=/usr/share/postgresql/postgres.bki
>
>
POSTGRES_DESCR=/usr/share/postgresql/postgres.descrip
>
>
POSTGRESQL_CONF_SAMPLE=/usr/share/postgresql/postgres
>
>
PG_HBA_SAMPLE=/usr/share/postgresql/pg_hba.conf.sampl
>
>
PG_IDENT_SAMPLE=/usr/share/postgresql/pg_ident.conf.s
> The files belonging to this database system will be
> own
> 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
> Signal 12
> 2
> 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/ba
> IpcMemoryCreate(size=950272)
> Signal 12
>
> initdb: failed
> initdb: removing data directory
> "/usr/local/pgsql/data"
>
> --------------------------------------------
> Any pointers ? It will be great help.
>
> Thanks,
> SR
>
>
>
> __________________________________
> Do you Yahoo!?
> Y! Messenger - Communicate in real time. Download
> now.
> http://messenger.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
> settings
>
>
>





__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail