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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

In response to

Browse pgsql-general by date

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