Thread: Aprender PostGreSQL
<div class="Section1"><p class="MsoNormal">Hola a todos muy buenas tardes a todos, de antemano mil gracias por estar leyendoeste mail.<p class="MsoNormal">Me remito a ustedes para solicitarles material de apoyo para empezar a aprender estabase de datos PostGreSQL, bueno les comento algo de mi historia, era usuario de dbf con foxpro para DOS, después me cambiéa vfp y actualmente estoy con vfp9 + mysql, he notado que MySQL es muy rápido en relación a consultar datos, tengola versión 5.0 y en casa tengo ahora la 5.1.42 x64bits, pero he notado que cuando cuando tengo bastante peticiones delectura y escritura como que se queda el servidor y responde a los 30 – 40 segundos, es mucho tiempo o de paso esperar1 – 2 minutos, me han comentado que PostGreSQL hay mejor respuesta, bueno eso y otras cosas buenas que me hablan deustedes, en fin también quisiera saber si tienen material para diseñar correctamente las bases de datos justamente parasucursales, es decir tengo una base de datos digamos llamada “miempresa” en donde es db es para todas y las sucursalesacceden remotamente por el internet pero en ocasiones se torna lento por la baja de señal, mi idea es montar servidoreslocales con copias iguales al principal y hacer como replicas es decir que se estén actualizando los servidoresen viceversa, maestro y esclavos (matriz y sucursales), es decir que para los usuarios del sistema en los puntosremotos no tengan que acceden al principal si no que lo hacen al local por la lan, si existiese una forma mejor y quede mejores resultados pueden ayudarme para ya empezar a aprender PostGreSQL y diseñar correctamente las bases de datosque soporten mis <p class="MsoNormal"> <p class="MsoNormal"> <div align="center" class="MsoNormal" style="text-align:center"><spanlang="ES-TRAD" style="color:#1F497D"><hr align="center" size="2" width="100%" /></span></div><pclass="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"; color:red">GLSystem S.A.</span></b><p class="MsoNormal"><b><i><span lang="ES-AR" style="font-size:10.0pt;font-family: "Arial","sans-serif";color:#1F497D">Jairo Cedeño Adrián.</span></i></b><span lang="ES-AR" style="font-family:"Arial","sans-serif";color:#1F497D"> <br/></span><span lang="ES-AR" style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Desarrollo y Asesoramiento Informático</span><span lang="ES-TRAD" style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:#010158"></span><p class="MsoNormal"><span lang="ES-AR"style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Soluciones Integradas Open Networks</span><p class="MsoNormal"><b><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Programación en Vfp9 + VfpStyleMenuFrameWorks</span></b><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"; color:#F79646">Rapid Application Development</span><span lang="EN-US" style="font-size:12.0pt;font-family:"Times New Roman","serif";color:#010158"></span><pclass="MsoNormal"><b><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Mob</span></b><span lang="EN-US" style="font-size:8.0pt; font-family:"Arial","sans-serif";color:#1F497D">.:(+593) 94 707 138 / 84 958 499</span><p class="MsoNormal"><b><span lang="EN-US"style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Msn</span></b><span lang="EN-US" style="font-size:8.0pt; font-family:"Arial","sans-serif";color:#1F497D">: </span><a href="mailto:jairo_cedeno_adrian@hotmail.com" title="blocked::mailto:jairo_cedeno_adrian@hotmail.com"><spanlang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif"">jairo_cedeno_adrian@hotmail.com</span></a><spanlang="EN-US" style="font-size:12.0pt;font-family:"TimesNew Roman","serif"; color:#010158"></span><p class="MsoNormal"><b><span lang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif"; color:#1F497D">Mail</span></b><span lang="EN-US" style="font-size:8.0pt; font-family:"Arial","sans-serif";color:#1F497D">: </span><a href="mailto:jairo.cedeno@pacedel.com" title="blocked::mailto:jairo.cedeno@pacedel.com"><spanlang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif"">jairo.cedeno.adrian@gmail.com</span></a><spanlang="EN-US" style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#1F497D"></span><divalign="center" class="MsoNormal" style="text-align:center"><spanlang="ES-TRAD" style="color:#1F497D"><hr align="center" size="2" width="100%" /></span></div><pclass="MsoNormal"> </div>
Hola desde Panamá, Jairo. Puede que encuentre mejores respuestas entre los User Groups del propio PostgreSQL (así se lo escribe correctamente) donde hay grupos activos en Argentina, Perú, Colombia y Venezuela. Vea todo en esta dirección:
http://pugs.postgresql.org/node/56?destination=node%2F56
También prueba sus comentarios en las listas de correo del propio PostgreSQL:
http://www.postgresql.org/community/lists/
Soy diseñador de esquemas y si es que quiere estudiar lo mejor de la disciplina le recomiendo el libro Information Modeling and Relational Databases por Terry Halpin porque a él nadie le gana. Y si es que buscas alguien para asesoriar el diseño de sus sucusales pues estoy disponible.
En general creo que estarás bastante satisfecho, de no decir maravillado, con PostgreSQL en comparasión con mysql.
Saludos y buena suerte.
Barry Schatz
http://pugs.postgresql.org/node/56?destination=node%2F56
También prueba sus comentarios en las listas de correo del propio PostgreSQL:
http://www.postgresql.org/community/lists/
Soy diseñador de esquemas y si es que quiere estudiar lo mejor de la disciplina le recomiendo el libro Information Modeling and Relational Databases por Terry Halpin porque a él nadie le gana. Y si es que buscas alguien para asesoriar el diseño de sus sucusales pues estoy disponible.
En general creo que estarás bastante satisfecho, de no decir maravillado, con PostgreSQL en comparasión con mysql.
Saludos y buena suerte.
Barry Schatz
2010/9/20 Jairo Cedeño <jairo.cedeno.adrian@gmail.com>
Hola a todos muy buenas tardes a todos, de antemano mil gracias por estar leyendo este mail.
Me remito a ustedes para solicitarles material de apoyo para empezar a aprender esta base de datos PostGreSQL, bueno les comento algo de mi historia, era usuario de dbf con foxpro para DOS, después me cambié a vfp y actualmente estoy con vfp9 + mysql, he notado que MySQL es muy rápido en relación a consultar datos, tengo la versión 5.0 y en casa tengo ahora la 5.1.42 x64bits, pero he notado que cuando cuando tengo bastante peticiones de lectura y escritura como que se queda el servidor y responde a los 30 – 40 segundos, es mucho tiempo o de paso esperar 1 – 2 minutos, me han comentado que PostGreSQL hay mejor respuesta, bueno eso y otras cosas buenas que me hablan de ustedes, en fin también quisiera saber si tienen material para diseñar correctamente las bases de datos justamente para sucursales, es decir tengo una base de datos digamos llamada “miempresa” en donde es db es para todas y las sucursales acceden remotamente por el internet pero en ocasiones se torna lento por la baja de señal, mi idea es montar servidores locales con copias iguales al principal y hacer como replicas es decir que se estén actualizando los servidores en viceversa, maestro y esclavos (matriz y sucursales), es decir que para los usuarios del sistema en los puntos remotos no tengan que acceden al principal si no que lo hacen al local por la lan, si existiese una forma mejor y que de mejores resultados pueden ayudarme para ya empezar a aprender PostGreSQL y diseñar correctamente las bases de datos que soporten mis
GLSystem S.A.
Jairo Cedeño Adrián.
Desarrollo y Asesoramiento InformáticoSoluciones Integradas Open Networks
Programación en Vfp9 + VfpStyleMenuFrameWorks
Rapid Application Development
Mob.:(+593) 94 707 138 / 84 958 499
Msn: jairo_cedeno_adrian@hotmail.com
Mail: jairo.cedeno.adrian@gmail.com
Hi,
When issuing an "alt+f4" on the query window, pgadmin crash.
Closing the query hith "ctrl+w" work fine (and also with "file"->"close").
I'm using the last git version under Debian testing (2.6.32-5-686).
Last strace messages :
poll([{fd=5, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=5, revents=POLLOUT}])
writev(5,
[{"\24\0\6\0\242\t\340\2r\2\0\0\0\0\0\0\0\0\0\0\377\377\377\37", 24},
{NULL, 0}, {"", 0}], 3) = 24
poll([{fd=5, events=POLLIN}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
read(5, "\1
E~\t\0\0\0\4\0\0\0\0\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 68
read(5, 0xa62c168, 4096) = -1 EAGAIN (Resource
temporarily unavailable)
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++
regards
Philippe
Hi Philippe,
Le 21/09/2010 12:33, Philippe Rimbault a écrit :
> [...]
> When issuing an "alt+f4" on the query window, pgadmin crash.
> Closing the query hith "ctrl+w" work fine (and also with "file"->"close").
> I'm using the last git version under Debian testing (2.6.32-5-686).
>
> Last strace messages :
> poll([{fd=5, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=5,
> revents=POLLOUT}])
> writev(5,
> [{"\24\0\6\0\242\t\340\2r\2\0\0\0\0\0\0\0\0\0\0\377\377\377\37", 24},
> {NULL, 0}, {"", 0}], 3) = 24
> poll([{fd=5, events=POLLIN}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
> read(5, "\1
> E~\t\0\0\0\4\0\0\0\0\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 68
> read(5, 0xa62c168, 4096) = -1 EAGAIN (Resource
> temporarily unavailable)
> --- SIGSEGV (Segmentation fault) @ 0 (0) ---
> +++ killed by SIGSEGV +++
>
I don't have the issue here. I tried on 1.12 and 1.13, everything worked
fine. Did you do something on the query window?
--
Guillaumehttp://www.postgresql.frhttp://dalibo.com
On 21/09/2010 13:12, Guillaume Lelarge wrote:
> Hi Philippe,
>
> Le 21/09/2010 12:33, Philippe Rimbault a écrit :
>
>> [...]
>> When issuing an "alt+f4" on the query window, pgadmin crash.
>> Closing the query hith "ctrl+w" work fine (and also with "file"->"close").
>> I'm using the last git version under Debian testing (2.6.32-5-686).
>>
>> Last strace messages :
>> poll([{fd=5, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=5,
>> revents=POLLOUT}])
>> writev(5,
>> [{"\24\0\6\0\242\t\340\2r\2\0\0\0\0\0\0\0\0\0\0\377\377\377\37", 24},
>> {NULL, 0}, {"", 0}], 3) = 24
>> poll([{fd=5, events=POLLIN}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
>> read(5, "\1
>> E~\t\0\0\0\4\0\0\0\0\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 68
>> read(5, 0xa62c168, 4096) = -1 EAGAIN (Resource
>> temporarily unavailable)
>> --- SIGSEGV (Segmentation fault) @ 0 (0) ---
>> +++ killed by SIGSEGV +++
>>
>>
> I don't have the issue here. I tried on 1.12 and 1.13, everything worked
> fine. Did you do something on the query window?
>
>
>
No, i just open the query window and close it by "alt+f4".
I will try to compil pgadmin in debug mode today and post the result in
this list !
Le 21/09/2010 13:27, Vladimir Koković a écrit :
> On Tue, 21 Sep 2010 13:12:11 +0200, Guillaume Lelarge
> <guillaume@lelarge.info> wrote:
>
>> Hi Philippe,
>>
>> Le 21/09/2010 12:33, Philippe Rimbault a écrit :
>>> [...]
>>> When issuing an "alt+f4" on the query window, pgadmin crash.
>>> Closing the query hith "ctrl+w" work fine (and also with
>>> "file"->"close").
>>> I'm using the last git version under Debian testing (2.6.32-5-686).
>>>
>>> Last strace messages :
>>> poll([{fd=5, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=5,
>>> revents=POLLOUT}])
>>> writev(5,
>>> [{"\24\0\6\0\242\t\340\2r\2\0\0\0\0\0\0\0\0\0\0\377\377\377\37", 24},
>>> {NULL, 0}, {"", 0}], 3) = 24
>>> poll([{fd=5, events=POLLIN}], 1, -1) = 1 ([{fd=5, revents=POLLIN}])
>>> read(5, "\1
>>> E~\t\0\0\0\4\0\0\0\0\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096)
>>> = 68
>>> read(5, 0xa62c168, 4096) = -1 EAGAIN (Resource
>>> temporarily unavailable)
>>> --- SIGSEGV (Segmentation fault) @ 0 (0) ---
>>> +++ killed by SIGSEGV +++
>>>
>>
>> I don't have the issue here. I tried on 1.12 and 1.13, everything worked
>> fine. Did you do something on the query window?
>>
>
> When issuing an "alt+f4" on the query window, pgadmin crash !!!
Well, yeah, I already know that. It just doesn't happen on my laptop. I
recompile all pgAdmin 1.12 and still don't have any crash.
> ------------------------------------------------------------------------------
>
> root@vlada-desktop:/tmp# gdb /usr/local/pgadmin3-debug/bin/pgadmin3
> GNU gdb (GDB) 7.1-ubuntu
> Copyright (C) 2010 Free Software Foundation, Inc.
> License GPLv3+: GNU GPL version 3 or later
> <http://gnu.org/licenses/gpl.html>
> This is free software: you are free to change and redistribute it.
> There is NO WARRANTY, to the extent permitted by law. Type "show copying"
> and "show warranty" for details.
> This GDB was configured as "i486-linux-gnu".
> For bug reporting instructions, please see:
> <http://www.gnu.org/software/gdb/bugs/>...
> Reading symbols from /usr/local/pgadmin3-debug/bin/pgadmin3...done.
> (gdb) run
> Starting program: /usr/local/pgadmin3-debug/bin/pgadmin3
> [Thread debugging using libthread_db enabled]
>
> Program received signal SIGSEGV, Segmentation fault.
> 0x00000000 in ?? ()
> (gdb) bt
> #0 0x00000000 in ?? ()
> #1 0xb7e40e1f in wxStyledTextCtrl::SendMsg (this=0x90c2ef8, msg=2006,
> wp=0, lp=0) at ../../../../contrib/src/stc/stc.cpp:199
> #2 0xb7e40fc5 in wxStyledTextCtrl::GetLength (this=0x90c2ef8) at
> ../../../../contrib/src/stc/stc.cpp:257
> #3 0x0822f38c in frmQuery::updateMenu (this=0x906d800, obj=0x90c2ef8)
> at ../../pgadmin3/pgadmin/frm/frmQuery.cpp:1368
The line it refers too is only 18 months old. Anyway, it seems more an
issue with your wxWidgets release. Which release do you use? I'm using
the last one, 2.8.11.
--
Guillaumehttp://www.postgresql.frhttp://dalibo.com
I'have just compiled pgadmin with debug option.<br /> Version of wxwidgets is 2.8.10.<br /><br /> Here you will find everthingi've done ton compile and exectue (/home/pri/bin/pgadmin3 is a link to /opt/pgadmin/bin/pgadmin3).<br /> If youneed other "traces", i'm OK.<br /> (Thank for your work on pgadmin and the french translation of the postgresql doc)<br/><br /><br /><blockquote>pri@rimbault:~/pgadmin3$ git pull<br /> Already up-to-date.<br /> pri@rimbault:~/pgadmin3$./configure --prefix=/opt/pgadmin --enable-debug<br /> [...]<br /> PostgreSQL directory: /usr/local/pgsql<br /> PostgreSQL pg_config binary: /usr/local/pgsql/bin/pg_config<br/> PostgreSQL version: PostgreSQL 9.0.0<br /><br /> PostgreSQL PQconninfoParsesupport: Present<br /> PostgreSQL SSL support: Missing<br /><br /> wxWidgets directory: /usr<br /> wxWidgets wx-config binary: /usr/bin/wx-config<br /> wxWidgets version: wxWidgets 2.8.10<br /><br /> libxml2 directory: /usr<br /> libxml2 xml2-configbinary: /usr/bin/xml2-config<br /> libxml2 version: libxml2 2.7.7<br /><br/> libxslt directory: /usr<br /> libxslt xslt-config binary: /usr/bin/xslt-config<br/> libxslt version: libxslt 1.1.26<br /><br /> Building a debug version ofpgAdmin: Yes<br /> Statically linking pgAdmin: No<br /> Building a Mac OS X appbundle: No<br /><br/> pgAdmin configuration is now complete. You can now compile and<br /> install pgAdmin using 'make; make install'.<br/><br /> pri@rimbault:~/pgadmin3$ make && sudo make install<br /><br /> pri@rimbault:~/pgadmin3$ gdbpgadmin3<br /> GNU gdb (GDB) 7.0.1-debian<br /> Copyright (C) 2009 Free Software Foundation, Inc.<br /> License GPLv3+:GNU GPL version 3 or later <a class="moz-txt-link-rfc2396E" href="http://gnu.org/licenses/gpl.html"><http://gnu.org/licenses/gpl.html></a><br/> This is free software: you arefree to change and redistribute it.<br /> There is NO WARRANTY, to the extent permitted by law. Type "show copying"<br/> and "show warranty" for details.<br /> This GDB was configured as "i486-linux-gnu".<br /> For bug reportinginstructions, please see:<br /><a class="moz-txt-link-rfc2396E" href="http://www.gnu.org/software/gdb/bugs/"><http://www.gnu.org/software/gdb/bugs/></a>...<br/> Reading symbols from/home/pri/bin/pgadmin3...(no debugging symbols found)...done.<br /> (gdb) run<br /> Starting program: /home/pri/bin/pgadmin3<br/> [Thread debugging using libthread_db enabled]<br /><br /> Program received signal SIGSEGV, Segmentationfault.<br /> 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) ()<br /> (gdb)<br /></blockquote><br/><br /> The end :)<br /><br /> Philippe<br /><br /> On 21/09/2010 13:43, Guillaume Lelarge wrote: <blockquotecite="mid:4C989A58.6070102@lelarge.info" type="cite"><pre wrap="">Le 21/09/2010 13:27, Vladimir Koković a écrit: </pre><blockquote type="cite"><pre wrap="">On Tue, 21 Sep 2010 13:12:11 +0200, Guillaume Lelarge <a class="moz-txt-link-rfc2396E" href="mailto:guillaume@lelarge.info"><guillaume@lelarge.info></a> wrote: </pre><blockquote type="cite"><pre wrap="">Hi Philippe, Le 21/09/2010 12:33, Philippe Rimbault a écrit : </pre><blockquote type="cite"><pre wrap="">[...] When issuing an "alt+f4" on the query window, pgadmin crash. Closing the query hith "ctrl+w" work fine (and also with "file"->"close"). I'm using the last git version under Debian testing (2.6.32-5-686). Last strace messages : poll([{fd=5, events=POLLIN|POLLOUT}], 1, -1) = 1 ([{fd=5, revents=POLLOUT}]) writev(5, [{"\24\0\6\0\242\t\340\2r\2\0\0\0\0\0\0\0\0\0\0\377\377\377\37", 24}, {NULL, 0}, {"", 0}], 3) = 24 poll([{fd=5, events=POLLIN}], 1, -1) = 1 ([{fd=5, revents=POLLIN}]) read(5, "\1 E~\t\0\0\0\4\0\0\0\0\0\0\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 68 read(5, 0xa62c168, 4096) = -1 EAGAIN (Resource temporarily unavailable) --- SIGSEGV (Segmentation fault) @ 0 (0) --- +++ killed by SIGSEGV +++ </pre></blockquote><pre wrap=""> I don't have the issue here. I tried on 1.12 and 1.13, everything worked fine. Did you do something on the query window? </pre></blockquote><pre wrap=""> When issuing an "alt+f4" on the query window, pgadmin crash !!! </pre></blockquote><pre wrap=""> Well, yeah, I already know that. It just doesn't happen on my laptop. I recompile all pgAdmin 1.12 and still don't have any crash. </pre><blockquote type="cite"><pre wrap="">------------------------------------------------------------------------------ root@vlada-desktop:/tmp# gdb /usr/local/pgadmin3-debug/bin/pgadmin3 GNU gdb (GDB) 7.1-ubuntu Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <a class="moz-txt-link-rfc2396E" href="http://gnu.org/licenses/gpl.html"><http://gnu.org/licenses/gpl.html></a> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i486-linux-gnu". For bug reporting instructions, please see: <a class="moz-txt-link-rfc2396E" href="http://www.gnu.org/software/gdb/bugs/"><http://www.gnu.org/software/gdb/bugs/></a>... Reading symbols from /usr/local/pgadmin3-debug/bin/pgadmin3...done. (gdb) run Starting program: /usr/local/pgadmin3-debug/bin/pgadmin3 [Thread debugging using libthread_db enabled] Program received signal SIGSEGV, Segmentation fault. 0x00000000 in ?? () (gdb) bt #0 0x00000000 in ?? () #1 0xb7e40e1f in wxStyledTextCtrl::SendMsg (this=0x90c2ef8, msg=2006, wp=0, lp=0) at ../../../../contrib/src/stc/stc.cpp:199 #2 0xb7e40fc5 in wxStyledTextCtrl::GetLength (this=0x90c2ef8) at ../../../../contrib/src/stc/stc.cpp:257 #3 0x0822f38c in frmQuery::updateMenu (this=0x906d800, obj=0x90c2ef8) at ../../pgadmin3/pgadmin/frm/frmQuery.cpp:1368 </pre></blockquote><pre wrap=""> The line it refers too is only 18 months old. Anyway, it seems more an issue with your wxWidgets release. Which release do you use? I'm using the last one, 2.8.11. </pre></blockquote><br />
Le 21/09/2010 13:53, Philippe Rimbault a écrit : > I'have just compiled pgadmin with debug option. > Version of wxwidgets is 2.8.10. > I installed Ubuntu's wxWidgets packages. Still don't get a crash. > Here you will find everthing i've done ton compile and exectue > (/home/pri/bin/pgadmin3 is a link to /opt/pgadmin/bin/pgadmin3). > If you need other "traces", i'm OK. > (Thank for your work on pgadmin and the french translation of the > postgresql doc) > > > pri@rimbault:~/pgadmin3$ git pull > Already up-to-date. > pri@rimbault:~/pgadmin3$ ./configure --prefix=/opt/pgadmin > --enable-debug > [...] > PostgreSQL directory: /usr/local/pgsql > PostgreSQL pg_config binary: /usr/local/pgsql/bin/pg_config > PostgreSQL version: PostgreSQL 9.0.0 > > PostgreSQL PQconninfoParse support: Present > PostgreSQL SSL support: Missing > > wxWidgets directory: /usr > wxWidgets wx-config binary: /usr/bin/wx-config > wxWidgets version: wxWidgets 2.8.10 > > libxml2 directory: /usr > libxml2 xml2-config binary: /usr/bin/xml2-config > libxml2 version: libxml2 2.7.7 > > libxslt directory: /usr > libxslt xslt-config binary: /usr/bin/xslt-config > libxslt version: libxslt 1.1.26 > > Building a debug version of pgAdmin: Yes > Statically linking pgAdmin: No > Building a Mac OS X appbundle: No > > pgAdmin configuration is now complete. You can now compile and > install pgAdmin using 'make; make install'. > I don't have exactly the same thing but I don't think it really matters. I built against 9.1devel, with SSL support, and use libxml2 2.7.6. wxWidgets 2.8.11 could be the reason why I don't get a crash, but if I use 2.8.10, pgAdmin still doesn't crash. > pri@rimbault:~/pgadmin3$ make && sudo make install > > pri@rimbault:~/pgadmin3$ gdb pgadmin3 > GNU gdb (GDB) 7.0.1-debian > Copyright (C) 2009 Free Software Foundation, Inc. > License GPLv3+: GNU GPL version 3 or later > <http://gnu.org/licenses/gpl.html> > This is free software: you are free to change and redistribute it. > There is NO WARRANTY, to the extent permitted by law. Type "show > copying" > and "show warranty" for details. > This GDB was configured as "i486-linux-gnu". > For bug reporting instructions, please see: > <http://www.gnu.org/software/gdb/bugs/>... > Reading symbols from /home/pri/bin/pgadmin3...(no debugging symbols > found)...done. > (gdb) run > Starting program: /home/pri/bin/pgadmin3 > [Thread debugging using libthread_db enabled] > > Program received signal SIGSEGV, Segmentation fault. > 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) () > (gdb) > You have a different crash than Vladimir. Can you do a "bt" on the gdb console just after the crash and send the result here? could give us more infos. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Here the output of "bt" just after the crash : (gdb) bt #0 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) () #1 0x08465b02 in gqbView::canSaveAsImage() () #2 0x0825a90f in frmQuery::updateMenu(wxObject*) () #3 0x0825d52f in frmQuery::OnFocus(wxFocusEvent&) () #4 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () #5 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () #6 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () #7 0xb759cf2f in wxAppConsole::HandleEvent(wxEvtHandler*, void (wxEvtHandler::*)(wxEvent&), wxEvent&) const () from /usr/lib/libwx_baseu-2.8.so.0 #8 0xb763af39 in wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) () from /usr/lib/libwx_baseu-2.8.so.0 #9 0xb763b0c8 in wxEvtHandler::SearchDynamicEventTable(wxEvent&) () from /usr/lib/libwx_baseu-2.8.so.0 #10 0xb763c0d5 in wxEvtHandler::ProcessEvent(wxEvent&) () from /usr/lib/libwx_baseu-2.8.so.0 #11 0xb7834f88 in ?? () from /usr/lib/libwx_gtk2u_core-2.8.so.0 #12 0xb6cfce24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #13 0xb6914142 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 #14 0xb692a62d in ?? () from /usr/lib/libgobject-2.0.so.0 #15 0xb692ba83 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0 #16 0xb692c086 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0 #17 0xb6e290f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #18 0xb6e36fe1 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #19 0xb6e39713 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #20 0xb6e397f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #21 0xb6cfce24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #22 0xb69127a9 in ?? () from /usr/lib/libgobject-2.0.so.0 #23 0xb6914142 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 #24 0xb692a276 in ?? () from /usr/lib/libgobject-2.0.so.0 #25 0xb692ba83 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0 #26 0xb692c086 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0 #27 0xb6e290f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #28 0xb6cf693c in gtk_main_do_event () from /usr/lib/libgtk-x11-2.0.so.0 #29 0xb6b7edca in ?? () from /usr/lib/libgdk-x11-2.0.so.0 #30 0xb68682f5 in g_main_context_dispatch () from /lib/libglib-2.0.so.0 #31 0xb686bfd8 in ?? () from /lib/libglib-2.0.so.0 #32 0xb686c517 in g_main_loop_run () from /lib/libglib-2.0.so.0 #33 0xb6cf6dc9 in gtk_main () from /usr/lib/libgtk-x11-2.0.so.0 #34 0xb781dd18 in wxEventLoop::Run() () from /usr/lib/libwx_gtk2u_core-2.8.so.0 #35 0xb78b0ace in wxAppBase::MainLoop() () from /usr/lib/libwx_gtk2u_core-2.8.so.0 #36 0xb78b06c1 in wxAppBase::OnRun() () from /usr/lib/libwx_gtk2u_core-2.8.so.0 #37 0xb75d6aca in wxEntry(int&, wchar_t**) () from /usr/lib/libwx_baseu-2.8.so.0 #38 0xb75d6ca7 in wxEntry(int&, char**) () from /usr/lib/libwx_baseu-2.8.so.0 #39 0x0807d2cb in main () On 21/09/2010 14:27, Guillaume Lelarge wrote: > Le 21/09/2010 13:53, Philippe Rimbault a écrit : > >> I'have just compiled pgadmin with debug option. >> Version of wxwidgets is 2.8.10. >> >> > I installed Ubuntu's wxWidgets packages. Still don't get a crash. > > >> Here you will find everthing i've done ton compile and exectue >> (/home/pri/bin/pgadmin3 is a link to /opt/pgadmin/bin/pgadmin3). >> If you need other "traces", i'm OK. >> (Thank for your work on pgadmin and the french translation of the >> postgresql doc) >> >> >> pri@rimbault:~/pgadmin3$ git pull >> Already up-to-date. >> pri@rimbault:~/pgadmin3$ ./configure --prefix=/opt/pgadmin >> --enable-debug >> [...] >> PostgreSQL directory: /usr/local/pgsql >> PostgreSQL pg_config binary: /usr/local/pgsql/bin/pg_config >> PostgreSQL version: PostgreSQL 9.0.0 >> >> PostgreSQL PQconninfoParse support: Present >> PostgreSQL SSL support: Missing >> >> wxWidgets directory: /usr >> wxWidgets wx-config binary: /usr/bin/wx-config >> wxWidgets version: wxWidgets 2.8.10 >> >> libxml2 directory: /usr >> libxml2 xml2-config binary: /usr/bin/xml2-config >> libxml2 version: libxml2 2.7.7 >> >> libxslt directory: /usr >> libxslt xslt-config binary: /usr/bin/xslt-config >> libxslt version: libxslt 1.1.26 >> >> Building a debug version of pgAdmin: Yes >> Statically linking pgAdmin: No >> Building a Mac OS X appbundle: No >> >> pgAdmin configuration is now complete. You can now compile and >> install pgAdmin using 'make; make install'. >> >> > I don't have exactly the same thing but I don't think it really matters. > I built against 9.1devel, with SSL support, and use libxml2 2.7.6. > wxWidgets 2.8.11 could be the reason why I don't get a crash, but if I > use 2.8.10, pgAdmin still doesn't crash. > > >> pri@rimbault:~/pgadmin3$ make&& sudo make install >> >> pri@rimbault:~/pgadmin3$ gdb pgadmin3 >> GNU gdb (GDB) 7.0.1-debian >> Copyright (C) 2009 Free Software Foundation, Inc. >> License GPLv3+: GNU GPL version 3 or later >> <http://gnu.org/licenses/gpl.html> >> This is free software: you are free to change and redistribute it. >> There is NO WARRANTY, to the extent permitted by law. Type "show >> copying" >> and "show warranty" for details. >> This GDB was configured as "i486-linux-gnu". >> For bug reporting instructions, please see: >> <http://www.gnu.org/software/gdb/bugs/>... >> Reading symbols from /home/pri/bin/pgadmin3...(no debugging symbols >> found)...done. >> (gdb) run >> Starting program: /home/pri/bin/pgadmin3 >> [Thread debugging using libthread_db enabled] >> >> Program received signal SIGSEGV, Segmentation fault. >> 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) () >> (gdb) >> >> > You have a different crash than Vladimir. Can you do a "bt" on the gdb > console just after the crash and send the result here? could give us > more infos. > > >
Sorry to re-open this thread, i'v just seen that my gdb output was wrong (no symbols loaded because of a bad --prefix at compilation). Here is the good output of gdb (on the last Git version of Pgadmin) : Program received signal SIGSEGV, Segmentation fault. 0x083df5f0 in gqbView::updateModelSize (this=0x0, obj=0x0, updateAnyWay=true) at ./gqb/gqbView.cpp:711 711 if(!iterator) (gdb) bt #0 0x083df5f0 in gqbView::updateModelSize (this=0x0, obj=0x0, updateAnyWay=true) at ./gqb/gqbView.cpp:711 #1 0x083dfa31 in gqbView::canSaveAsImage (this=0x0) at ./gqb/gqbView.cpp:795 #2 0x08233084 in frmQuery::updateMenu (this=0x9083600, obj=0x91d9470) at ./frm/frmQuery.cpp:1386 #3 0x0823284c in frmQuery::OnFocus (this=0x9083600, ev=...) at ./frm/frmQuery.cpp:1201 #4 0x08232874 in frmQuery::OnFocus (this=0x91d6280, ev=...) at ./frm/frmQuery.cpp:1207 #5 0x08232874 in frmQuery::OnFocus (this=0x90b0000, ev=...) at ./frm/frmQuery.cpp:1207 #6 0x08232874 in frmQuery::OnFocus (this=0x91d9470, ev=...) at ./frm/frmQuery.cpp:1207 #7 0xb74d5ebf in wxAppConsole::HandleEvent (this=0x88305f8, handler=0x91d9470, func=NULL, event=...) at ../src/common/appbase.cpp:322 #8 0xb7591529 in wxEvtHandler::ProcessEventIfMatches (entry=..., handler=0x91d9470, event=...) at ../src/common/event.cpp:1231 #9 0xb7591888 in wxEvtHandler::SearchDynamicEventTable (this=0x91d9470, event=...) at ../src/common/event.cpp:1413 #10 0xb7592bf5 in wxEvtHandler::ProcessEvent (this=0x91d9470, event=...) at ../src/common/event.cpp:1289 #11 0xb77b0f7e in DoSendFocusEvents (widget=0x9082ec0, win=0x91d9470) at ../src/gtk/window.cpp:1487 #12 gtk_window_focus_in_callback (widget=0x9082ec0, win=0x91d9470) at ../src/gtk/window.cpp:1891 #13 0xb6c34e24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #14 0xb684c13a in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 #15 0xb686261d in ?? () from /usr/lib/libgobject-2.0.so.0 #16 0xb6863a7b in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0 #17 0xb6864076 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0 #18 0xb6d610f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #19 0xb6d6efe1 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #20 0xb6d71713 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #21 0xb6d717f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #22 0xb6c34e24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 #23 0xb684a7a9 in ?? () from /usr/lib/libgobject-2.0.so.0 #24 0xb684c13a in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 #25 0xb6862266 in ?? () from /usr/lib/libgobject-2.0.so. Regards Philippe On 21/09/2010 14:58, Philippe Rimbault wrote: > Here the output of "bt" just after the crash : > > (gdb) bt > #0 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) () > #1 0x08465b02 in gqbView::canSaveAsImage() () > #2 0x0825a90f in frmQuery::updateMenu(wxObject*) () > #3 0x0825d52f in frmQuery::OnFocus(wxFocusEvent&) () > #4 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () > #5 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () > #6 0x0825d50e in frmQuery::OnFocus(wxFocusEvent&) () > #7 0xb759cf2f in wxAppConsole::HandleEvent(wxEvtHandler*, void > (wxEvtHandler::*)(wxEvent&), wxEvent&) const () from > /usr/lib/libwx_baseu-2.8.so.0 > #8 0xb763af39 in > wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, > wxEvtHandler*, wxEvent&) () from /usr/lib/libwx_baseu-2.8.so.0 > #9 0xb763b0c8 in wxEvtHandler::SearchDynamicEventTable(wxEvent&) () > from /usr/lib/libwx_baseu-2.8.so.0 > #10 0xb763c0d5 in wxEvtHandler::ProcessEvent(wxEvent&) () from > /usr/lib/libwx_baseu-2.8.so.0 > #11 0xb7834f88 in ?? () from /usr/lib/libwx_gtk2u_core-2.8.so.0 > #12 0xb6cfce24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #13 0xb6914142 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 > #14 0xb692a62d in ?? () from /usr/lib/libgobject-2.0.so.0 > #15 0xb692ba83 in g_signal_emit_valist () from > /usr/lib/libgobject-2.0.so.0 > #16 0xb692c086 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0 > #17 0xb6e290f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #18 0xb6e36fe1 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #19 0xb6e39713 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #20 0xb6e397f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #21 0xb6cfce24 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #22 0xb69127a9 in ?? () from /usr/lib/libgobject-2.0.so.0 > #23 0xb6914142 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0 > #24 0xb692a276 in ?? () from /usr/lib/libgobject-2.0.so.0 > #25 0xb692ba83 in g_signal_emit_valist () from > /usr/lib/libgobject-2.0.so.0 > #26 0xb692c086 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0 > #27 0xb6e290f6 in ?? () from /usr/lib/libgtk-x11-2.0.so.0 > #28 0xb6cf693c in gtk_main_do_event () from /usr/lib/libgtk-x11-2.0.so.0 > #29 0xb6b7edca in ?? () from /usr/lib/libgdk-x11-2.0.so.0 > #30 0xb68682f5 in g_main_context_dispatch () from /lib/libglib-2.0.so.0 > #31 0xb686bfd8 in ?? () from /lib/libglib-2.0.so.0 > #32 0xb686c517 in g_main_loop_run () from /lib/libglib-2.0.so.0 > #33 0xb6cf6dc9 in gtk_main () from /usr/lib/libgtk-x11-2.0.so.0 > #34 0xb781dd18 in wxEventLoop::Run() () from > /usr/lib/libwx_gtk2u_core-2.8.so.0 > #35 0xb78b0ace in wxAppBase::MainLoop() () from > /usr/lib/libwx_gtk2u_core-2.8.so.0 > #36 0xb78b06c1 in wxAppBase::OnRun() () from > /usr/lib/libwx_gtk2u_core-2.8.so.0 > #37 0xb75d6aca in wxEntry(int&, wchar_t**) () from > /usr/lib/libwx_baseu-2.8.so.0 > #38 0xb75d6ca7 in wxEntry(int&, char**) () from > /usr/lib/libwx_baseu-2.8.so.0 > #39 0x0807d2cb in main () > > > On 21/09/2010 14:27, Guillaume Lelarge wrote: >> Le 21/09/2010 13:53, Philippe Rimbault a écrit : >>> I'have just compiled pgadmin with debug option. >>> Version of wxwidgets is 2.8.10. >>> >> I installed Ubuntu's wxWidgets packages. Still don't get a crash. >> >>> Here you will find everthing i've done ton compile and exectue >>> (/home/pri/bin/pgadmin3 is a link to /opt/pgadmin/bin/pgadmin3). >>> If you need other "traces", i'm OK. >>> (Thank for your work on pgadmin and the french translation of the >>> postgresql doc) >>> >>> >>> pri@rimbault:~/pgadmin3$ git pull >>> Already up-to-date. >>> pri@rimbault:~/pgadmin3$ ./configure --prefix=/opt/pgadmin >>> --enable-debug >>> [...] >>> PostgreSQL directory: /usr/local/pgsql >>> PostgreSQL pg_config binary: >>> /usr/local/pgsql/bin/pg_config >>> PostgreSQL version: PostgreSQL 9.0.0 >>> >>> PostgreSQL PQconninfoParse support: Present >>> PostgreSQL SSL support: Missing >>> >>> wxWidgets directory: /usr >>> wxWidgets wx-config binary: /usr/bin/wx-config >>> wxWidgets version: wxWidgets 2.8.10 >>> >>> libxml2 directory: /usr >>> libxml2 xml2-config binary: /usr/bin/xml2-config >>> libxml2 version: libxml2 2.7.7 >>> >>> libxslt directory: /usr >>> libxslt xslt-config binary: /usr/bin/xslt-config >>> libxslt version: libxslt 1.1.26 >>> >>> Building a debug version of pgAdmin: Yes >>> Statically linking pgAdmin: No >>> Building a Mac OS X appbundle: No >>> >>> pgAdmin configuration is now complete. You can now compile and >>> install pgAdmin using 'make; make install'. >>> >> I don't have exactly the same thing but I don't think it really matters. >> I built against 9.1devel, with SSL support, and use libxml2 2.7.6. >> wxWidgets 2.8.11 could be the reason why I don't get a crash, but if I >> use 2.8.10, pgAdmin still doesn't crash. >> >>> pri@rimbault:~/pgadmin3$ make&& sudo make install >>> >>> pri@rimbault:~/pgadmin3$ gdb pgadmin3 >>> GNU gdb (GDB) 7.0.1-debian >>> Copyright (C) 2009 Free Software Foundation, Inc. >>> License GPLv3+: GNU GPL version 3 or later >>> <http://gnu.org/licenses/gpl.html> >>> This is free software: you are free to change and redistribute it. >>> There is NO WARRANTY, to the extent permitted by law. Type "show >>> copying" >>> and "show warranty" for details. >>> This GDB was configured as "i486-linux-gnu". >>> For bug reporting instructions, please see: >>> <http://www.gnu.org/software/gdb/bugs/>... >>> Reading symbols from /home/pri/bin/pgadmin3...(no debugging symbols >>> found)...done. >>> (gdb) run >>> Starting program: /home/pri/bin/pgadmin3 >>> [Thread debugging using libthread_db enabled] >>> >>> Program received signal SIGSEGV, Segmentation fault. >>> 0x08465a10 in gqbView::updateModelSize(gqbQueryObject*, bool) () >>> (gdb) >>> >> You have a different crash than Vladimir. Can you do a "bt" on the gdb >> console just after the crash and send the result here? could give us >> more infos. >> >> > >