Hello
I have tried a number of things now and they all seem to lead to the same point.
I can start the ipc-deamon2 either locally or as a service and the same for the postmaster. I can initialise a database however, when I try to carry out any postgres functions it causes an access violation.
The details so far:
System details:-
Windows 2000 service pack 4
Cygwin 1.5.5-1
Postgresql 7.3.4-2
I have checked and confirmed that the postmaster is running using
$cygrunsrv -Q postmaster
Service postmaster exists
Type : Own Process
Current State : Running
Controls Accepted : Accept Stop, Accept Shutdown
I initialised the database with:-
$initdb -D /usr/local/pgsql/data
The directories and template databases were created.
I then tried to connect to the template database :-
$psql -U quintk template1
psql: server closed the connection unexpectidly
This probably means the server terminated abnormally
before or while processing the request
The logfile looks like:-
LOG: database system was interrupted at 2003-09-28 10:37:38 GMTDT
LOG: checkpoint record is at 0/83B3F8
LOG: redo record is at 0/83B3F8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system was not properly shut down; automatic recovery in progress
LOG: ReadRecord: record with zero length at 0/83B438
LOG: redo is not required
LOG: database system is ready
LOG: server process (pid 3176) was terminated by signal 11
LOG: terminating any other active server processes
The postgres.exe.stackdump file looks like:
Exception: STATUS_ACCESS_VIOLATION at eip=0087316D
eax=00000000 ebx=0022F7D4 ecx=00000000 edx=00000000 esi=00000138 edi=00000000
ebp=0022F74C esp=0022F5D0 program=f:\cygwin\bin\postgres.exe
cs=001B ds=0023 es=0023 fs=0038 gs=0000 ss=0023
Stack trace:
Frame Function Args
0022F74C 0087316D (00000138, 0022F818, 00000001, 0022F814)
0022F794 008750A8 (00000138, 0022F818, 00000001, 0022F814)
0022F7D8 7503C11F (00000138, 0022F818, 00000001, 0022F814)
0022F868 6102D128 (61601FDC, 0022F920, 00000018, 00000000)
0022F8C8 61043F3D (00000007, 0022F920, 00000018, 00000000)
0022F8E8 610465F6 (00000007, 0022F920, 00000018, 00000000)
0022F908 00510B80 (0022F920, 00000018, 0022F948, 6103EB65)
0022F948 0050FFBA (00000C68, 0050E160, 00000C68, 0000008B)
0022F978 0050E2EE (00000C68, 0000008B, 00000001, 00000378)
0022F9A8 0050DEDF (00000014, 00000000, 00000004, FFFFFFFF)
0022F9D8 610122B3 (00000004, 0022FA18, 0022FA10, 0022F8A4)
0022FA58 0050CCE9 (00000002, 00000001, 00000000, 100267B0)
0022FEB8 0050C1D4 (00000001, 10020448, 00000000, 00000001)
0022FEF0 004DC688 (00000001, 61602C34, 10020330, 0022FF78)
0022FF40 61005018 (610CFEE0, FFFFFFFE, 000003CC, 610CFE04)
0022FF90 610052ED (00000000, 00000000, 8043138F, 00000000)
End of stack trace (more stack frames may be present)
Not sure what else to try. I get similar results with
$psql -l
Regards
Keith Quint
