On 1/14/2013 10:28 PM, Reini Urban wrote:
On Mon, Jan 14, 2013 at 12:40 AM, marco atzeri wrote:
wget -r -np -nH --cut-dirs=1 \
http://matzeri.altervista.org/cygwin-1.7/postgresql/index.html
/etc/rc.d/init.d/postgresql needs an +x,
added
and the .exe in DAEMON is wrong
ls -al /usr/sbin/postmaster
/usr/sbin/postmaster -> postgres.exe
What you mean, that postmaster need an exe as extention ?
It seems a fault of cygport post install that strip the .exe
from the postmaster.exe link.
/usr/sbin/initdb -D /usr/share/postgresql/data
required a rebaseall
rebase is already part of setup post installation
standard.
However I noticed that during rebaseall there is a segfault in rebase
/usr/lib/postgresql/dict_xsyn.dll: fixing bad relocations
/usr/lib/postgresql/dict_xsyn.dll: new base = 52090000, new size = 10000
/usr/lib/postgresql/dict_snowball.dll: fixing bad relocations
Segmentation fault (core dumped)
And dict_snowball.dll (like dict_xsyn.dll on others)
is one of the dll with link to the demon
$ objdump -x /usr/lib/postgresql/dict_snowball.dll |grep "DLL Name:"
DLL Name: postgres.exe
DLL Name: cygwin1.dll
DLL Name: KERNEL32.dll
It seems similar on 8.x version
$ psql
Segmentation fault (core dumped)
$ psql
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
re-uploading just in case I uploaded the wrong build.
89 1446 [main] psql 960 fhandler_pipe::create: name
\\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait, size 164, mode
PIPE_TYPE_MESSAGE
102 1548 [main] psql 960 fhandler_pipe::create: pipe read handle 0x788
450 1998 [main] psql 960 fhandler_pipe::create: CreateFile: name
\\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait
71 2069 [main] psql 960 fhandler_pipe::create: pipe write handle 0x784
65 2134 [main] psql 960 dll_crt0_0: finished dll_crt0_0 initialization
3267 5401 [sig] psql 960 wait_sig: entering ReadFile loop,
my_readsig 0x788, my_sendsig 0x784
775 6176 [main] psql 960 mount_info::conv_to_posix_path:
conv_to_posix_path (C:\cygwin\home\rurban, no-keep-rel, no-add-slash)
343 6519 [main] psql 960 normalize_win32_path:
C:\cygwin\home\rurban = normalize_win32_path (C:\cygwin\home\rurban)
75 6594 [main] psql 960 mount_info::conv_to_posix_path:
/home/rurban = conv_to_posix_path (C:\cygwin\home\rurban)
--- Process 960, exception C0000005 at F8D30000
152 6746 [main] psql 960 exception::handle: In
cygwin_except_handler exception 0xC0000005 at 0xF8D30000 sp 0x22AC7C
52 6798 [main] psql 960 exception::handle: In
cygwin_except_handler signal 11 at 0xF8D30000
384 7182 [main] psql 960 exception::handle: In
cygwin_except_handler calling 0x0
7237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION
55 7237 [main] psql 960 exception::handle: Exception:
STATUS_ACCESS_VIOLATION
163 7400 [main] psql 960 try_to_debug: debugger_command ''
8116 [main] psql 960 open_stackdumpfile: Dumping stack trace to
psql.exe.stackdump
$ gdb psql
Program received signal SIGSEGV, Segmentation fault.
0xf8d30000 in ?? ()
(gdb) bt
#0 0xf8d30000 in ?? ()
#1 0x610fc95c in pthread::init_mainthread () at
/usr/src/cygwin/src/winsup/cygwin/thread.cc:336
#2 0x61006cf5 in dll_crt0_1 () at
/usr/src/cygwin/src/winsup/cygwin/dcrt0.cc:832
#3 0x6100533d in _cygtls::call2 (this=<optimized out>,
func=0x61006c50 <dll_crt0_1(void*)>, arg=0x0,
buf=0x610054cb <_cygtls::call(unsigned long (*)(void*, void*), void*)+91>)
at /usr/src/cygwin/src/winsup/cygwin/cygtls.cc:99
#4 0x0022ff78 in ?? ()
#5 0x004330c2 in ?? ()
#6 0x00401015 in ?? ()
#7 0x7c81776f in RegisterWaitForInputIdle () from
/cygdrive/c/windows/system32/kernel32.dll
#8 0x00000000 in ?? ()
Can we have a gold star please.
wait until it is working
