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

On Wed, Jan 22, 2003 at 05:22:40AM +0200, Michelle Konzack wrote:
> 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)

We use PostgreSQL, Inc's eRServer for this. You just set things up
such that your ph_hba.conf doesn't allow other connections (that is,
no-one conencts except from the master). It still doesn't give you a
backup in the sense of "I want to go back to the database I had a day
ago, before that rogue got in and deleted everything."

You could probably _use_ the slave that way, however, by making the
slave tables actually views on something else, and using rules (and
probably triggers) to update another table. I have some ideas on how
to do some nifty stuff this way, but it hasn't been tested.

> 2. What is the traffic for changements ?

Just the SQL you need to send for each change. It's pretty light.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110