Thread: pgsql with cygwin 1.3.6.6

pgsql with cygwin 1.3.6.6

From
"Shay"
Date:
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


Re: pgsql with cygwin 1.3.6.6

From
Jason Tishler
Date:
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

Re: pgsql with cygwin 1.3.6.6

From
"Shay"
Date:
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@tishler.net]
Sent: Friday, February 01, 2002 3:53 AM
To: Shay
Cc: pgsql-cygwin@postgresql.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


Re: pgsql with cygwin 1.3.6.6

From
Hiroshi Inoue
Date:
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

Re: pgsql with cygwin 1.3.6.6

From
"Shay"
Date:
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@tpf.co.jp]
Sent: Friday, February 01, 2002 10:14 AM
To: shayb52@bezeqint.net
Cc: pgsql-cygwin@postgresql.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

Re: pgsql with cygwin 1.3.6.6

From
Jason Tishler
Date:
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@cygwin.com list.

BTW, did you really initdb into /database?

Jason

Re: pgsql with cygwin 1.3.6.6

From
"Shay"
Date:
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@tishler.net]
Sent: Friday, February 01, 2002 4:25 PM
To: Shay
Cc: pgsql-cygwin@postgresql.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@cygwin.com list.

BTW, did you really initdb into /database?

Jason