Re: [part 2] How to backup a postgreSQL of 80 GByte ?

Поиск
Список
Период
Сортировка
От Justin Clift
Тема Re: [part 2] How to backup a postgreSQL of 80 GByte ?
Дата
Msg-id 3E2EC4E1.2080701@postgresql.org
обсуждение исходный текст
Ответ на [part 2] How to backup a postgreSQL of 80 GByte ?  (Michelle Konzack <linux.mailinglists@freenet.de>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: optimizing query
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: PostgreSQL 7.3 and SuSE 8.1 problem