From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: pgsql-admin@postgresql.org
Cc: mallah@trade-india.com
Subject: Setting up of PITR system.
Date: Tue, 28 Mar 2006 19:11:07 +0530
Message-ID: <a97c77030603280541k33b80fe6t1dcbb8b53cea7e58@mail.gmail.com> (raw)
Hi,
We are trying to setup PITR system based on documentation
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
We have 3 questions regarding
1. Selection of archived WAL records that can be safely removed.
2. Knowing the relevant WAL record just after pg_stop_backup()
3. Recommended tool for taking file system level backup.
Elaboration:
we want to remove archived WAL log files which are no longer needed
so that the size of wal_archive folder is under control.
The DOCs say that filenames numerically less than the WAL record that
pg_stop_backup()
suggests can be removed. Will an alphabetical sorting be different from
numerically sorted
filename ? Sorting numerically is not easy as the filenames look like HEX
numbers
ut they are are so huge that they cant be stored in normal integers
(32bits).
Q2. We are attempting to automate the process of taking base backup and
removal
of the unneeded WAL files. Is there any reliable way of knowing the WAL
file X from
inside the shell script , such that files prior to X can be removed ?
from a shell script we issue pg_stop_backup() by psql -c , it returns
something
which does not looks like a WAL file.
Regds
Rajesh Kumar Mallah.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mallah.rajesh@gmail.com, mallah@trade-india.com
Subject: Re: Setting up of PITR system.
In-Reply-To: <a97c77030603280541k33b80fe6t1dcbb8b53cea7e58@mail.gmail.com>
References: <a97c77030603280541k33b80fe6t1dcbb8b53cea7e58@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox