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

Re: PITR Base Backup on an idle 8.1 server

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PITR Base Backup on an idle 8.1 server
Date: 2007-06-01 09:34:06
Message-ID: 1180690447.26297.80.camel@silverbirch.site (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-general by date

Next:From: Tom AllisonDate: 2007-06-01 09:39:48
Subject: Re: left outer join and values()
Previous:From: Dmitry KoterovDate: 2007-06-01 09:32:35
Subject: Does slonik EXECUTE SCRIPT call waits for comands termination?

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