Regarding a backup scenario

From: nandan bsd <bsdnandan(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Regarding a backup scenario
Date: 2005-07-11 06:58:31
Message-ID: 5a33a33a050710235811a5d401@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Düster Horst 2005-07-11 10:28:42 Re: where with NULL values are not selected
Previous Message prav maha 2005-07-11 01:16:57 ERROR: Bogus amopstrategy number 2439 for opclass 1989