PITR / what directories/files can be ignored?

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: PITR / what directories/files can be ignored?
Date: 2006-12-14 22:09:57
Message-ID: 4581CBB5.4090704@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Can I also ignore any of these? ...

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

BTW, PITR is pretty much the best thing since sliced bread :D

TIA,

-Glen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Aiken 2006-12-14 22:13:30 Re: could not write to log -> PANIC -> System down
Previous Message Tom Lane 2006-12-14 21:17:24 Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)