Обсуждение: 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@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
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@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
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
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