Re: PITR Base Backup on an idle 8.1 server - Mailing list pgsql-general

From Simon Riggs
Subject Re: PITR Base Backup on an idle 8.1 server
Date
Msg-id 1180690447.26297.80.camel@silverbirch.site
Whole thread Raw
In response to PITR Base Backup on an idle 8.1 server  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
On Wed, 2007-05-30 at 22:41 -0400, Greg Smith wrote:

> -Find something harmless I can execute in a loop that will generate WAL
> activity, run that until the segment gets archived.  Haven't really
> thought of something good to use for that purpose yet.

create table xlog_switch as
select '0123456789ABCDE' from generate_series(1,1000000);
drop table xlog_switch;

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-general by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Does slonik EXECUTE SCRIPT call waits for comands termination?
Next
From: Tom Allison
Date:
Subject: Re: left outer join and values()