Thread: Re: /usr/bin/postmaster -D /usr/local/pgsql/data RESULTS IN A CORE DUMP

This topic on the pgsql-cygwin maillist helped me a lot to solve my problem:
http://archives.free.net.ph/message/20050807.152333.9a9e2d10.en.html

I got one of the latest snapshots of the cygwin1.dll and now postmaster works.

Best Regards,
Vladimir

2005/10/11, Vladimir Tsvetkov <npacemo@gmail.com>:
> > I've had just to change the following option for cygserver:
> > /etc/cygserver.conf
> >
> > # kern.ipc.semmns: Maximum no. of semaphores hold concurrently.
> > # Default: 60, Min: 1, Max: 1024
> > #kern.ipc..semmns 60
> > kern.ipc..semmns 512
> >
> > And after this the initdb procedure worked without failure.
>
> OK. initdb works:
>
> [SAMUIL@vlado_1 /home/SAMUIL]> initdb -D /usr/local/pgsql/data -W -E LATIN1
> The files belonging to this database system will be owned by user "SAMUIL".
> 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... 100
> selecting default shared_buffers... 1000
> creating configuration files... ok
> creating template1 database in /usr/local/pgsql/data/base/1... ok
> initializing pg_shadow... ok
> Enter new superuser password:
> Enter it again:
> setting password... ok
> enabling unlimited row size for system tables... ok
> initializing pg_depend... ok
> creating system views... ok
> loading pg_description... ok
> creating conversions... ok
> setting privileges on built-in objects... ok
> creating information schema... ok
> vacuuming database template1... ok
> copying template1 to template0... ok
>
> Success. You can now start the database server using:
>
>     /usr/bin/postmaster -D /usr/local/pgsql/data
> or
>     /usr/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
>
> But when I try to start up the postmaster I get a nasty core dump:
>
> [SAMUIL@vlado_1 /home/SAMUIL]> /usr/bin/postmaster -D /usr/local/pgsql/data
> Segmentation fault (core dumped)
>
> [SAMUIL@vlado_1 /home/SAMUIL]> cat postgres.exe.stackdump
> Exception: STATUS_ACCESS_VIOLATION at eip=610028AA
> eax=00000000 ebx=61258E78 ecx=0000000A edx=000001A8 esi=000001A8 edi=61259000
> ebp=0022E948 esp=0022E910 program=C:\cygwin\bin\postgres.exe, pid 884, thread ma
> in
> cs=001B ds=0023 es=0023 fs=0038 gs=0000 ss=0023
> Stack trace:
> Frame     Function  Args
> 0022E948  610028AA  (00000000, 61258C78, 0022E978, 6101F5E8)
> 0022E978  6101171C  (611572C0, 61258C78, 0022E9C8, 61010F4E)
> 0022E9A8  61011CED  (61154A78, 61157280, 611D85C8, 61154A78)
> 0022E9E8  61011E38  (61154A78, 00000000, 000007B5, 00002000)
> 0022EA28  6108E3FD  (00000000, 00002000, 0022EA68, 10010158)
> 0022EA58  610844FF  (0022EA78, 0022EA7C, 0022EA88, 0053F2C3)
> 0022EA88  0055945A  (00001538, 00000000, 00001538, 10016610)
> 0022EEE8  0053D258  (00000003, 100101B8, 00000764, 61087959)
> 0022EF18  00506FFD  (00000003, 611574B0, 10010090, 77F79005)
> 0022EFD8  61004DD2  (0022EFF0, 00000000, 0022F221, 31373838)
> 0022FF88  6100594F  (00000000, 00000000, 00000000, 00000000)
> End of stack trace
>
> Is there any way to fix this error?
>
> Best Regards,
> Vladimir Tsvetkov
>