Re: [part 2] How to backup a postgreSQL of 80 GByte ? - Mailing list pgsql-general

From Justin Clift
Subject Re: [part 2] How to backup a postgreSQL of 80 GByte ?
Date
Msg-id 3E2EC4E1.2080701@postgresql.org
Whole thread Raw
In response to [part 2] How to backup a postgreSQL of 80 GByte ?  (Michelle Konzack <linux.mailinglists@freenet.de>)
List pgsql-general
Michelle Konzack wrote:
<snip>
> The other thing ist, what is, if I have the Master-SQL in Paris and a
> Slave-SQL in Strasbourg ??? The Slave is automaticaly updatet if the
> Master is changed...
>
> OK, I need a identical system, maybe a little bit smaller CPU and less
> memory for the Slave but...
>
> 1.  How can I do a Master-Slave System ?
>     The Slave must be write only from outside (Paris)

Hi Michelle,

This sounds a lot like simple replication.

There are a few PostgreSQL replication solutions in existence, with a
summary of them available here:

http://gborg.postgresql.org/genpage?replication_research


> 2.  What is the traffic for changements ?

What do you mean?

If you're wondering how much traffic will happen, it depends on which
replication solution you use, and how many changes happen to your master
database in Paris.

Does this help?

:-)

Regards and best wishes,

Justin Clift


> Thanks for your help
> Michelle
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: optimizing query
Next
From: Stephan Szabo
Date:
Subject: Re: PostgreSQL 7.3 and SuSE 8.1 problem