Re: [ITA] postgresql-9.2.2-1
> following Reini's request: > http://cygwin.com/ml/cygwin/2013-01/msg00134.html Gold star awarded: http://cygwin.com/goldstars/#MA
Re: [ITA] postgresql-9.2.2-1
On 1/15/2013 11:28 AM, Corinna Vinschen wrote: On Jan 15 00:24, marco atzeri wrote: 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. If that's unclear, symlinks should *not* use the .exe extension. than is wrong in the current postgresql-8.2.11-1 packages ;-) Wed Jan 7 16:50:24 20093051520 usr/sbin/postgres.exe Wed Jan 7 16:48:15 2009 0 usr/sbin/postmaster.exe -> postgres.exe but correct on 9.2.2-1 $ cygcheck -l postgresql |grep sbin [cut] /usr/sbin/postgres.exe /usr/sbin/postmaster due to cygport post install cleaning Corinna Regards Marco
Re: [ITA] postgresql-9.2.2-1
On Jan 15 00:24, marco atzeri wrote: > 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. If that's unclear, symlinks should *not* use the .exe extension. Corinna -- Corinna Vinschen Please, send mails regarding Cygwin to Cygwin Project Co-Leader cygwin AT cygwin DOT com Red Hat
Re: [ITA] postgresql-9.2.2-1
On 1/15/2013 12:24 AM, marco atzeri wrote: On 1/14/2013 10:28 PM, Reini Urban wrote: On Mon, Jan 14, 2013 at 12:40 AM, marco atzeri wrote: /usr/lib/postgresql/dict_snowball.dll: fixing bad relocations Segmentation fault (core dumped) it seems that is not a contrib dll but a core function when we solve the rebase issue I will move to right package Not installing postgresql-contrib and skipping the dictionaries with $ mv /usr/share/postgresql/snowball_create.sql /usr/share/postgresql/snowball_create.sql_bk $ touch /usr/share/postgresql/snowball_create.sql $ 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. I am correctly able to initdb, createdb, run postgres , and connect with psql $ psql psql (9.2.2) Type "help" for help. marco=# quit marco-# ^C marco=# \q Regards Marco
Re: [ITA] postgresql-9.2.2-1
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 = 5209, new size = 1 /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. 891446 [main] psql 960 fhandler_pipe::create: name \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait, size 164, mode PIPE_TYPE_MESSAGE 1021548 [main] psql 960 fhandler_pipe::create: pipe read handle 0x788 4501998 [main] psql 960 fhandler_pipe::create: CreateFile: name \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait 712069 [main] psql 960 fhandler_pipe::create: pipe write handle 0x784 652134 [main] psql 960 dll_crt0_0: finished dll_crt0_0 initialization 32675401 [sig] psql 960 wait_sig: entering ReadFile loop, my_readsig 0x788, my_sendsig 0x784 7756176 [main] psql 960 mount_info::conv_to_posix_path: conv_to_posix_path (C:\cygwin\home\rurban, no-keep-rel, no-add-slash) 3436519 [main] psql 960 normalize_win32_path: C:\cygwin\home\rurban = normalize_win32_path (C:\cygwin\home\rurban) 756594 [main] psql 960 mount_info::conv_to_posix_path: /home/rurban = conv_to_posix_path (C:\cygwin\home\rurban) --- Process 960, exception C005 at F8D3 1526746 [main] psql 960 exception::handle: In cygwin_except_handler exception 0xC005 at 0xF8D3 sp 0x22AC7C 526798 [main] psql 960 exception::handle: In cygwin_except_handler signal 11 at 0xF8D3 3847182 [main] psql 960 exception::handle: In cygwin_except_handler calling 0x0 7237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION 557237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION 1637400 [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. 0xf8d3 in ?? () (gdb) bt #0 0xf8d3 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=, func=0x61006c50 , 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 0x in ?? () Can we have a gold star please. wait until it is working
Re: [ITA] postgresql-9.2.2-1
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, and the .exe in DAEMON is wrong ls -al /usr/sbin/postmaster /usr/sbin/postmaster -> postgres.exe /usr/sbin/initdb -D /usr/share/postgresql/data required a rebaseall $ psql Segmentation fault (core dumped) 891446 [main] psql 960 fhandler_pipe::create: name \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait, size 164, mode PIPE_TYPE_MESSAGE 1021548 [main] psql 960 fhandler_pipe::create: pipe read handle 0x788 4501998 [main] psql 960 fhandler_pipe::create: CreateFile: name \\.\pipe\cygwin-c5e39b7a9d22bafb-960-sigwait 712069 [main] psql 960 fhandler_pipe::create: pipe write handle 0x784 652134 [main] psql 960 dll_crt0_0: finished dll_crt0_0 initialization 32675401 [sig] psql 960 wait_sig: entering ReadFile loop, my_readsig 0x788, my_sendsig 0x784 7756176 [main] psql 960 mount_info::conv_to_posix_path: conv_to_posix_path (C:\cygwin\home\rurban, no-keep-rel, no-add-slash) 3436519 [main] psql 960 normalize_win32_path: C:\cygwin\home\rurban = normalize_win32_path (C:\cygwin\home\rurban) 756594 [main] psql 960 mount_info::conv_to_posix_path: /home/rurban = conv_to_posix_path (C:\cygwin\home\rurban) --- Process 960, exception C005 at F8D3 1526746 [main] psql 960 exception::handle: In cygwin_except_handler exception 0xC005 at 0xF8D3 sp 0x22AC7C 526798 [main] psql 960 exception::handle: In cygwin_except_handler signal 11 at 0xF8D3 3847182 [main] psql 960 exception::handle: In cygwin_except_handler calling 0x0 7237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION 557237 [main] psql 960 exception::handle: Exception: STATUS_ACCESS_VIOLATION 1637400 [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. 0xf8d3 in ?? () (gdb) bt #0 0xf8d3 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=, func=0x61006c50 , 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 0x in ?? () Can we have a gold star please. BTW: We have a nice GNU extension find postgresql -name index.html -o -name md5.sum -delete I checked the md5 sums. -- Reini Urban http://cpanel.net/ http://www.perl-compiler.org/