[postgis-users] gpc lost database connection - how to debug?

Paul Ramsey pramsey at refractions.net
Wed May 22 16:37:07 PDT 2002


Firstly, run postmaster from the commandline, so you can see the stderr
log. 
Secondly, attach gdb to the actual postgres process which your psql
connection has caused to the spawned (attaching to the postmaster will
tell you nothing).
P.

"Robert W. Burgholzer" wrote:
> 
> OK,
> Now I've got some polygons (thanks to Paul Ramsey),. but when I execute
> any of teh gpc functions I lose my connection to the database. i am
> doing these from the command line, using commands such as the folowing:
> 
> gistest=# select intersection((select the_geom from microhup where gid
> =1),(select the_geom from microsoil where gid = 5) );
> server closed the connection unexpectedly
>  This probably means the server terminated abnormally
>  before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> 
> I realize this is experimental code, but I am having a hard time getting
> debug info, since I managed to compile without the --enable-syslog or
> any other debuggin functions. Are there any other ways of determining
> what is happening during these episodes?
> 
> Thanks again,
> rob
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_




More information about the postgis-users mailing list