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

Vladimir Tsvetkov <[email protected]> Tue, 11 Oct 2005 13:39:28 +0300
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <[email protected]>
> 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=3D610028AA
eax=3D00000000 ebx=3D61258E78 ecx=3D0000000A edx=3D000001A8 esi=3D000001A8 =
edi=3D61259000
ebp=3D0022E948 esp=3D0022E910 program=3DC:\cygwin\bin\postgres.exe, pid 884=
, thread ma
in
cs=3D001B ds=3D0023 es=3D0023 fs=3D0038 gs=3D0000 ss=3D0023
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [email protected] so that your
       message can get through to the mailing list cleanly