From: nandan bsd <bsdnandan@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Regarding a backup scenario
Date: Mon, 11 Jul 2005 12:28:31 +0530
Message-ID: <5a33a33a050710235811a5d401@mail.gmail.com> (raw)
Hi all,
I want some information regarding backups.
The scenario is
I have got a master server which has Linux as OS and postgres as Database
Other than this server i have got 5 client servers(same configuration as
All the transactions are done at different client locations and the
data is inserted into respective client servers. I would like to
maintain a backup of all client servers at 1 place ie at master
location.
My Idea:
I am thinking to take incremental backup for every 30 min and send the
.bak file to master server place so that the file is inserted into
database like the same i want to do the same at every client place for
30 min send the backup to master server.
but, as from the documentation there are no incremental backups at
database level.
I cant go for replication because the distance between each client and
master server is in order of around 60 Kilometer and there is problem
with network connectivity.
Please give me some idea so that this setting can be done
Thanks in Advance
Nandan
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: bsdnandan@gmail.com
Subject: Re: Regarding a backup scenario
In-Reply-To: <5a33a33a050710235811a5d401@mail.gmail.com>
References: <5a33a33a050710235811a5d401@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