Re: [BUGS] BUG #4339: The postgreSQL service stops abnormally
Hi, Bhaskar Sirohi wrote: > ... 2008-07-30 15:05:01 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:05:01 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:13:34 EDT LOG: checkpoints are occurring too frequently (29 seconds apart) 2008-07-30 15:13:34 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:18:50 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:18:50 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:19:21 EDT LOG: received fast shutdown request These log lines look like your database is touching lots of tuples, requiring it to checkpoint frequently. Then it receives a fast shutdown request - from whoever. What causes the workload? Did you check memory usage? (And uh.. does Windows 2003 Server have an OOM Killer or some such?) Regards Markus Wanner -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4339: The postgreSQL service stops abnormally
Hi, Bhaskar Sirohi wrote: Also there is no OOM killer application on the windows 2003 server. I also didn't think so, but who commanded the server to shutdown, then? Can there be any another reason why the service failed ? Well, yes, sure. But if you don't answer the important questions, it's hard to figure out what's wrong. Regards Markus Wanner -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf
Hello Francois, On 11/29/2012 06:32 AM, francois.bon...@gmail.com wrote: > The dumper tool pgsql2shp should set this header, as PostreSQL knowns what > encoding it is writing to. I think that belongs to the separate PostGIS project. Please find their issue tracker here: http://trac.osgeo.org/postgis/ Regards Markus Wanner -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
