Skip site navigation (1) Skip section navigation (2)

Re: trigger run of archive_command?

From: "Sebastian Reitenbach" <sebastia(at)l00-bugdead-prods(dot)de>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: trigger run of archive_command?
Date: 2008-01-14 16:39:34
Message-ID: 20080114163934.EB8D83A6F7@smtp.l00-bugdead-prods.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

Thomas Karcher <thkarcher(at)gmx(dot)de> wrote: 
> Hi,
> 
> > this one is still open when I run pg_stop_backup(), so I want to trigger 
the 
> > archive_command to be sure that I don't miss anything. 
> 
> I guess what you want is pg_switch_xlog() (see
> http://www.postgresql.org/docs/8.2/static/functions-admin.html)
this is exactly what I am looking for
> which became available with PG 8.2 ...
unfortunately right now I am stuck to PG 8.1.4.
I hope I can manage to upgrade without too much hassle, it seems meanwhile I 
have to use my workaround.

thanks a lot
Sebastian


Responses

pgsql-admin by date

Next:From: Bhella Paramjeet-PFCW67Date: 2008-01-15 00:43:16
Subject: Pg_statio_user_tables view does not get populated
Previous:From: Tom LaneDate: 2008-01-14 16:37:07
Subject: Re: monitoring free space map usage without VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group