Re: pgsql with cygwin 1.3.6.6

hello i have this problem which is reported as a known bug at cygwin version
1.1.8 but i have it too at version 1.3.6.6:

i run the command:
/usr/bin/postmaster -i -D /database

and get the result:
$ 0 [main] postmaster 404 fixup_mmaps_after_fork: base address fails
to match requested address 0x3B0000
E:\installed\psql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed
/usr/bin/postmaster: Startup proc 404 exited with status 256 - abort

[4]- Exit 1 /usr/bin/postmaster -i -D /database

can any one help?

thanks ahead,

Shay

Shay,

On Thu, Jan 31, 2002 at 11:20:23PM +0200, Shay wrote:
> hello i have this problem which is reported as a known bug at cygwin version
> 1.1.8 but i have it too at version 1.3.6.6:
>
> i run the command:
> /usr/bin/postmaster -i -D /database
>
> and get the result:
> $ 0 [main] postmaster 404 fixup_mmaps_after_fork: base address fails
> to match requested address 0x3B0000
> E:\installed\psql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed
> /usr/bin/postmaster: Startup proc 404 exited with status 256 - abort
>
> [4]- Exit 1 /usr/bin/postmaster -i -D /database
>
> can any one help?

Try Cygwin 1.3.9-1.

Jason

hello again,

thanks for the swift answer,
i have downloaded through setup only the 1.3.9 CygWin component and
installed only it and still the problem remains,

i would like to point out i am using Windows XP maybe that is my problem -
is XP not supported?

if any one has another idea it would be much help,

thanks ahead,

Shay.

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Friday, February 01, 2002 3:53 AM
To: Shay
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] pgsql with cygwin 1.3.6.6

Shay,

On Thu, Jan 31, 2002 at 11:20:23PM +0200, Shay wrote:
> hello i have this problem which is reported as a known bug at cygwin
version
> 1.1.8 but i have it too at version 1.3.6.6:
>
> i run the command:
> /usr/bin/postmaster -i -D /database
>
> and get the result:
> $ 0 [main] postmaster 404 fixup_mmaps_after_fork: base address fails
> to match requested address 0x3B0000
> E:\installed\psql\bin\postgres.exe: *** recreate_mmaps_after_fork_failed
> /usr/bin/postmaster: Startup proc 404 exited with status 256 - abort
>
> [4]- Exit 1 /usr/bin/postmaster -i -D /database
>
> can any one help?

Try Cygwin 1.3.9-1.

Jason

Shay wrote:
>
> hello again,
>
> thanks for the swift answer,
> i have downloaded through setup only the 1.3.9 CygWin component and
> installed only it and still the problem remains,

How does 'uname -a' show ?

regards,
Hiroshi Inoue

hi,

uname -a shows:

C:\PROGRA~1\ACCESS~1>uname -a
CYGWIN_NT-5.1 SHAYB-HOME 1.3.9(0.51/3/2) 2002-01-21 12:48 i686 unknown

-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Friday, February 01, 2002 10:14 AM
To: shayb52(at)bezeqint(dot)net
Cc: pgsql-cygwin(at)postgresql(dot)org; 'Jason Tishler'
Subject: Re: [CYGWIN] pgsql with cygwin 1.3.6.6

Shay wrote:
>
> hello again,
>
> thanks for the swift answer,
> i have downloaded through setup only the 1.3.9 CygWin component and
> installed only it and still the problem remains,

How does 'uname -a' show ?

regards,
Hiroshi Inoue

Shay,

On Fri, Feb 01, 2002 at 09:38:30AM +0200, Shay wrote:
> thanks for the swift answer,

You are welcome.

> i have downloaded through setup only the 1.3.9 CygWin component and

Good.

> installed only it and still the problem remains,

Bummers!

> i would like to point out i am using Windows XP maybe that is my problem -
> is XP not supported?

XP is supported because Cygwin supports XP. Sorry, but I don't have
access to XP, so I can't help to debug this problem. However, note that
others have reported success with XP.

> if any one has another idea it would be much help,

Try to use strace to debug. Note that you will have to temporarily
replace the postmaster symlink with a copy of postgres.exe:

$ rm /usr/bin/postmaster
$ cp /usr/bin/postgres.exe /usr/bin/postmaster.exe

This is because strace is *not* a Cygwin app, it's a Mingw app, and does
not understand symlinks.

Run strace as follows:

$ strace -o postmaster.log postmaster -i -D /database

You can also try posting your problem to the cygwin(at)cygwin(dot)com list.

BTW, did you really initdb into /database?

Jason

hi Jason and all,

I have succeeded in launching the postgresql, I have removed all installed
components, removed all registry entries and rebooted.

next I have downloaded all the components to my hard drive, I have chosen
the newest available versions and then installed it all from my hard drive.

I know that not all is required but I wanted to make sure it will go
smoothly as it probably went to the developers and testers that supplied
this installation package.

next I have created a file called: .bashrc in my home directory containing:

set PATH $PATH:/usr/local/pgsql/bin:/usr/local/bin
set PGDATA /usr/local/pgsql/data
set PGLIB /usr/local/pgsql/lib
set LD_LIBRARY_PATH /usr/local/pgsql/lib:/usr/local/lib
export LD_LIBRARY_PATH PATH PGDATA PGLIB

next I have executed the next lines (this lines actually creates a new
database default called: template1):

source .bashrc
ipc-daemon &
initdb /database

and last I have called these lines in order to launch the database:

/usr/bin/pg_ctl -D /database -l logfile.txt -o -i start &

the last step was to download the PgExplorer from:
http://www.davecentral.com/projects/pgexplorer1/

and connected to the database and created tables etc.

all worked fine, I have also connected through JDBC its perfect.

if any one have problems with this explanation or need to ask questions you
are more then welcome.

Jason - again thanks for the help and replies.

Shay.

-----Original Message-----
From: Jason Tishler [mailto:jason(at)tishler(dot)net]
Sent: Friday, February 01, 2002 4:25 PM
To: Shay
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] pgsql with cygwin 1.3.6.6

Shay,

On Fri, Feb 01, 2002 at 09:38:30AM +0200, Shay wrote:
> thanks for the swift answer,

You are welcome.

> i have downloaded through setup only the 1.3.9 CygWin component and

Good.

> installed only it and still the problem remains,

Bummers!

> i would like to point out i am using Windows XP maybe that is my problem -
> is XP not supported?

XP is supported because Cygwin supports XP. Sorry, but I don't have
access to XP, so I can't help to debug this problem. However, note that
others have reported success with XP.

> if any one has another idea it would be much help,

Try to use strace to debug. Note that you will have to temporarily
replace the postmaster symlink with a copy of postgres.exe:

$ rm /usr/bin/postmaster
$ cp /usr/bin/postgres.exe /usr/bin/postmaster.exe

This is because strace is *not* a Cygwin app, it's a Mingw app, and does
not understand symlinks.

Run strace as follows:

$ strace -o postmaster.log postmaster -i -D /database

You can also try posting your problem to the cygwin(at)cygwin(dot)com list.

BTW, did you really initdb into /database?

Jason