pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Regarding a backup scenario
2+ messages / 2 participants
[nested] [flat]

* Regarding a backup scenario
@ 2005-07-11 06:58 nandan bsd <bsdnandan@gmail.com>
  2005-07-12 05:24 ` Re: Regarding a backup scenario Thomas F. O'Connell <tfo@sitening.com>
  0 siblings, 1 reply; 2+ messages in thread

From: nandan bsd @ 2005-07-11 06:58 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Regarding a backup scenario
  2005-07-11 06:58 Regarding a backup scenario nandan bsd <bsdnandan@gmail.com>
@ 2005-07-12 05:24 ` Thomas F. O'Connell <tfo@sitening.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Thomas F. O'Connell @ 2005-07-12 05:24 UTC (permalink / raw)
  To: nandan bsd <bsdnandan@gmail.com>; +Cc: pgsql-admin

Could you use Slony-I's recently added log shipping feature?

http://slony.info/

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Jul 11, 2005, at 1:58 AM, nandan bsd wrote:

> 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
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-07-12 05:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-11 06:58 Regarding a backup scenario nandan bsd <bsdnandan@gmail.com>
2005-07-12 05:24 ` Thomas F. O'Connell <tfo@sitening.com>

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