Re: PITR / what directories/files can be ignored?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Glen Parker <glenebob(at)nwlink(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PITR / what directories/files can be ignored?
Date: 2006-12-14 22:57:31
Message-ID: 29020.1166137051@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Glen Parker <glenebob(at)nwlink(dot)com> writes:
> I am continuing to refine my PITR backup script, and there are some
> directories I do not know what to do with. First off, here are the
> directories/files I am currently ignoring...

> pg_xlog (ours is a symlink, so I ignore it altogether)
> pg_log/*
> base/*/pgsql_tmp/*
> postmaster.opts
> postmaster.pid

All OK.

> Can I also ignore any of these? ...

> pg_clog/*
> pg_multixact/*
> pg_subtrans/*
> pg_twophase/*

No!

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-14 22:59:07 Re: could not write to log -> PANIC -> System down
Previous Message Vlad 2006-12-14 22:51:54 Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)