Re: make error during PostgreSQL installation on windows

Hi all

Get the following error after installing cygwin and during running
installation steps for PostgreSQL 7.2.1 on windows.

./configure passed successfully.

make gives the following error:

[quote]

$ make
make -C doc all
make[1]: Entering directory `/cygdrive/c/postgresql/postgresql-7.2.1/doc'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/cygdrive/c/postgresql/postgresql-7.2.1/doc'
make -C src all
make[1]: Entering directory `/cygdrive/c/postgresql/postgresql-7.2.1/src'
make -C backend all
make[2]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
'
make -C access all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access'
make -C common SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/common'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/common'
make -C gist SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/gist'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/gist'
make -C hash SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/hash'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/hash'
make -C heap SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/heap'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/heap'
make -C index SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/index'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/index'
make -C nbtree SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/nbtree'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/nbtree'
make -C rtree SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/rtree'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/rtree'
make -C transam SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/access/transam'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access/transam'
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
access'
make -C bootstrap all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/bootstrap'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
bootstrap'
make -C catalog all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/catalog'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
catalog'
make -C parser all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/parser'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
parser'
make -C commands all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/commands'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
commands'
make -C executor all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/executor'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
executor'
make -C lib all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/lib'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
lib'
make -C libpq all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/libpq'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
libpq'
make -C main all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/main'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
main'
make -C nodes all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/nodes'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
nodes'
make -C optimizer all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer'
make -C geqo SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer/geqo'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer/geqo'
make -C path SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer/path'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer/path'
make -C plan SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer/plan'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer/plan'
make -C prep SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer/prep'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer/prep'
make -C util SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/optimizer/util'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer/util'
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
optimizer'
make -C port all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/port'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
port'
make -C postmaster all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/postmaster'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
postmaster'
make -C regex all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/regex'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
regex'
make -C rewrite all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/rewrite'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
rewrite'
make -C storage all
make[3]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/storage'
make -C buffer SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/storage/buffer'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
storage/buffer'
make -C file SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/storage/file'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
storage/file'
make -C freespace SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/storage/freespace'
make[4]: `SUBSYS.o' is up to date.
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
storage/freespace'
make -C ipc SUBSYS.o
make[4]: Entering directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend
/storage/ipc'
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
incl
ude -I/usr/local/include -DBUILDING_DLL=1 -c -o ipc.o ipc.c
cc1: warning: changing search order for system directory
"/usr/local/include"
cc1: warning: as it has already been specified as a non-system directory
ipc.c: In function `InternalIpcSemaphoreCreate':
ipc.c:271: warning: implicit declaration of function `semget'
ipc.c:271: `IPC_CREAT' undeclared (first use in this function)
ipc.c:271: (Each undeclared identifier is reported only once
ipc.c:271: for each function it appears in.)
ipc.c:271: `IPC_EXCL' undeclared (first use in this function)
ipc.c:318: warning: implicit declaration of function `semctl'
ipc.c:318: `SETALL' undeclared (first use in this function)
ipc.c: In function `IpcSemaphoreKill':
ipc.c:351: `IPC_RMID' undeclared (first use in this function)
ipc.c: In function `IpcSemaphoreLock':
ipc.c:378: storage size of `sops' isn't known
ipc.c:422: warning: implicit declaration of function `semop'
ipc.c:378: warning: unused variable `sops'
ipc.c: In function `IpcSemaphoreUnlock':
ipc.c:441: storage size of `sops' isn't known
ipc.c:441: warning: unused variable `sops'
ipc.c: In function `IpcSemaphoreTryLock':
ipc.c:475: storage size of `sops' isn't known
ipc.c:478: `IPC_NOWAIT' undeclared (first use in this function)
ipc.c:475: warning: unused variable `sops'
ipc.c: In function `IpcSemaphoreGetValue':
ipc.c:519: `GETVAL' undeclared (first use in this function)
ipc.c: In function `IpcSemaphoreGetLastPID':
ipc.c:530: `GETPID' undeclared (first use in this function)
ipc.c: In function `InternalIpcMemoryCreate':
ipc.c:561: warning: implicit declaration of function `shmget'
ipc.c:561: `IPC_CREAT' undeclared (first use in this function)
ipc.c:561: `IPC_EXCL' undeclared (first use in this function)
ipc.c:638: warning: implicit declaration of function `shmat'
ipc.c:638: warning: assignment makes pointer from integer without a cast
ipc.c: In function `IpcMemoryDetach':
ipc.c:664: warning: implicit declaration of function `shmdt'
ipc.c: In function `IpcMemoryDelete':
ipc.c:681: warning: implicit declaration of function `shmctl'
ipc.c:681: `IPC_RMID' undeclared (first use in this function)
ipc.c: In function `SharedMemoryIsInUse':
ipc.c:697: storage size of `shmStat' isn't known
ipc.c:707: `IPC_STAT' undeclared (first use in this function)
ipc.c:697: warning: unused variable `shmStat'
ipc.c: In function `IpcMemoryCreate':
ipc.c:818: warning: assignment makes pointer from integer without a cast
ipc.c:850: `IPC_RMID' undeclared (first use in this function)
ipc.c: In function `IpcSemaphoreCreate':
ipc.c:940: `IPC_RMID' undeclared (first use in this function)
ipc.c:966: `SETVAL' undeclared (first use in this function)
make[4]: *** [ipc.o] Error 1
make[4]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
storage/ipc'
make[3]: *** [ipc-recursive] Error 2
make[3]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/
storage'
make[2]: *** [storage-recursive] Error 2
make[2]: Leaving directory
`/cygdrive/c/postgresql/postgresql-7.2.1/src/backend'

make[1]: *** [all] Error 2
make[1]: Leaving directory `/cygdrive/c/postgresql/postgresql-7.2.1/src'
make: *** [all] Error 2

[/quote]

Thanks for your valuable input.

Best Regards.

Godson R

Godson,

On Mon, Nov 18, 2002 at 06:07:30PM +0530, Godson Retna wrote:
> Get the following error after installing cygwin and during running
> installation steps for PostgreSQL 7.2.1 on windows.
>
> ./configure passed successfully.
>
> make gives the following error:
>
> $ make
> [snip]
> make[4]: Entering directory
> `/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/storage/ipc'
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/usr/local/include -DBUILDING_DLL=1 -c -o ipc.o ipc.c
> cc1: warning: changing search order for system directory
> "/usr/local/include"
> cc1: warning: as it has already been specified as a non-system directory
> ipc.c: In function `InternalIpcSemaphoreCreate':
> ipc.c:271: warning: implicit declaration of function `semget'
> ipc.c:271: `IPC_CREAT' undeclared (first use in this function)
> ipc.c:271: (Each undeclared identifier is reported only once
> ipc.c:271: for each function it appears in.)
> [snip]

Did you forget to install cygipc? Or, is this yet another Cygwin gcc
3.x problem?

BTW, can you use the pre-built version that is part of the standard
Cygwin distribution?

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Hi Jason

Thank you for your reply.

Initially, I had problems with ./configure, which was sorted out after
installing cygipc-1.13-2.tar.bz2 (I referred to your early email solution
for a similar problem). So I suppose, cygipc is installed. The setup.exe
version is 2.249.2.5. The cygwin DLL version is 1.3.15.

BTW, can you please point me to links/information about installing the
pre-built version of PostgreSQL that is part of the standard Cygwin
distribution?

Appreciate your valuable assistance.

Best Regards.

Godson R
Chennai, Tamil Nadu, India.

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Monday, November 18, 2002 9:18 PM
To: Godson Retna
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] make error during PostgreSQL installation on
windowsusing cygwin

Godson,

On Mon, Nov 18, 2002 at 06:07:30PM +0530, Godson Retna wrote:
> Get the following error after installing cygwin and during running
> installation steps for PostgreSQL 7.2.1 on windows.
>
> ./configure passed successfully.
>
> make gives the following error:
>
> $ make
> [snip]
> make[4]: Entering directory
> `/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/storage/ipc'
>
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
include -I/usr/local/include -DBUILDING_DLL=1 -c -o ipc.o ipc.c
> cc1: warning: changing search order for system directory
> "/usr/local/include"
> cc1: warning: as it has already been specified as a non-system directory
> ipc.c: In function `InternalIpcSemaphoreCreate':
> ipc.c:271: warning: implicit declaration of function `semget'
> ipc.c:271: `IPC_CREAT' undeclared (first use in this function)
> ipc.c:271: (Each undeclared identifier is reported only once
> ipc.c:271: for each function it appears in.)
> [snip]

Did you forget to install cygipc? Or, is this yet another Cygwin gcc
3.x problem?

BTW, can you use the pre-built version that is part of the standard
Cygwin distribution?

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Godson,

On Tue, Nov 19, 2002 at 09:12:05AM +0530, Godson Retna wrote:
> BTW, can you please point me to links/information about installing the
> pre-built version of PostgreSQL that is part of the standard Cygwin
> distribution?

See the following (after installing Cygwin PostgreSQL):

/usr/doc/Cygwin/postgresql-7.2.3.README

or the following:

http://www.tishler.net/jason/software/postgresql/postgresql-7.2.3.README

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Hi Jason

Thank you for your valuable assistance.

BTW, I did try using the pre-built version part of the Cygwin installation,
but it fails ...

[quote]---------------------------------------------------------------------
------------

$ initdb -D /usr/share/postgresql/data
The files belonging to this database system will be owned by user
"Administrator
".
This user must also own the server process.

creating directory /usr/share/postgresql/data... ok
creating directory /usr/share/postgresql/data/base... ok
creating directory /usr/share/postgresql/data/global... ok
creating directory /usr/share/postgresql/data/pg_xlog... ok
creating directory /usr/share/postgresql/data/pg_clog... ok
creating template1 database in /usr/share/postgresql/data/base/1... Caught
signa
l.

initdb failed.
Removing /usr/share/postgresql/data.

Administrator(at)WEBLOGIC /usr/share/postgresql
$

Administrator(at)WEBLOGIC /usr/share/postgresql
$ logout

D:\apps\cygwin\bin>

[end
quote]----------------------------------------------------------------------
------------

Do give your valuable feedback.

Best Regards.

Godson R.

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Monday, November 18, 2002 9:18 PM
To: Godson Retna
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] make error during PostgreSQL installation on
windowsusing cygwin

Godson,

On Mon, Nov 18, 2002 at 06:07:30PM +0530, Godson Retna wrote:
> Get the following error after installing cygwin and during running
> installation steps for PostgreSQL 7.2.1 on windows.
>
> ./configure passed successfully.
>
> make gives the following error:
>
> $ make
> [snip]
> make[4]: Entering directory
> `/cygdrive/c/postgresql/postgresql-7.2.1/src/backend/storage/ipc'
>
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
include -I/usr/local/include -DBUILDING_DLL=1 -c -o ipc.o ipc.c
> cc1: warning: changing search order for system directory
> "/usr/local/include"
> cc1: warning: as it has already been specified as a non-system directory
> ipc.c: In function `InternalIpcSemaphoreCreate':
> ipc.c:271: warning: implicit declaration of function `semget'
> ipc.c:271: `IPC_CREAT' undeclared (first use in this function)
> ipc.c:271: (Each undeclared identifier is reported only once
> ipc.c:271: for each function it appears in.)
> [snip]

Did you forget to install cygipc? Or, is this yet another Cygwin gcc
3.x problem?

BTW, can you use the pre-built version that is part of the standard
Cygwin distribution?

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

Godson,

On Tue, Nov 26, 2002 at 01:03:00PM +0530, Godson Retna wrote:
> $ initdb -D /usr/share/postgresql/data
> The files belonging to this database system will be owned by user "Administrator".
> This user must also own the server process.
>
> [snip]
> creating template1 database in /usr/share/postgresql/data/base/1... Caught signa l.
>
> initdb failed.
> Removing /usr/share/postgresql/data.

Did you kill the postgres process? If not, then I have never
experienced the above. Sorry, but you will have to debug this
problem yourself.

Jason

Hi Jason

Thanks a million! Installation done.

Compiled from source after downloading PostgreSQL 7.2.3. Used your patch
and your inputs on the issue to complete the installation.

Best Regards.

Godson R.

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Wednesday, November 27, 2002 6:23 PM
To: Godson Retna
Cc: pgsql-cygwin(at)postgresql(dot)org; Cygwin
Subject: Re: [CYGWIN] make error during PostgreSQL installation on
windowsusingcygwin

Godson,

On Tue, Nov 26, 2002 at 01:03:00PM +0530, Godson Retna wrote:
> $ initdb -D /usr/share/postgresql/data
> The files belonging to this database system will be owned by user
"Administrator".
> This user must also own the server process.
>
> [snip]
> creating template1 database in /usr/share/postgresql/data/base/1... Caught
signa l.
>
> initdb failed.
> Removing /usr/share/postgresql/data.

Did you kill the postgres process? If not, then I have never
experienced the above. Sorry, but you will have to debug this
problem yourself.

Jason