Hi all,
While playing a bit with background workers (commit 527ea66), I found that
setting bgw_main for a dynamic bgworker, as well as bgw_library_name and
bgw_library_name, crashes to server if the library defining the function
defined in bgw_main is not loaded. In order to reproduce that, for ex
On Tue, Aug 6, 2013 at 12:51 AM, Tom Lane wrote:
> David Gudeman writes:
> > For those who don't want to go to the link to see what I'm talking
> > about with query rewrites, I thought I'd give a brief description.
> > Foreign data wrappers currently do all of their work in the planning
> > phas
On Sun, Aug 11, 2013 at 9:25 PM, Josh Berkus wrote:
> No, it's been a chronic issue since we got SMP support, pretty much
> forever. Why do you think we have pg_terminate_backend()?
>
> The problem, as explored downthread, is that there's no clear way to fix
> this. It's a problem which goes pre
On 08/10/2013 04:26 AM, Greg Stark wrote:
> On Sat, Aug 10, 2013 at 5:30 AM, Tom Lane wrote:
>> Any other client would behave the same
>> if it were killed while waiting for some backend query. So the right
>> fix would involve figuring out a way for the backend to kill itself
>> if the client co
On Thu, Aug 8, 2013 at 1:52 PM, Vik Fearing wrote:
> Someone on IRC a while ago was complaining that there was no way to
> specify an interval for pg_sleep, so I made one. Patch against today's
> HEAD attached.
>
> Usage: SELECT pg_sleep(interval '2 minutes');
>
> I would add this to the next com
now you can only enable WAL archive on the Master server,it will not take
effect on replication server.
I can't find the doc which explicit prohibit WAL archive on the replication
server,and there are WAL generated in the slave pg_xlog dir with
archive_status subdir,so I think this may be a bug.
