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

Hallo again,

After addin a new table with two colums (and one row for each table)
to my Database I have changed my php-scripts to know, when a new table
is added or changed.

OK, now I have tried a full backup with pg-dump, which had killed my
Internt-Connection for days...

OK second try. I use the new index-table to determine which table has
changed...

Full-Backup whit extracting each table seperatly with:

pg_dump -F c -d -t _table_ _db_ > _table_.dmp.gz

Now I have around 830.000 tables *.dmp.gz on my backup-media.

If something is changed on my SQP-Server a cron-job run a script which
check the index-table and backup each new or changed table. - OK.

Now the big problem with:

pg_restore -d _new_db_ -F c _table_.dmp.gz

Hmmm, first I need to create a table and then I can insert the table ???

Does not work...

Help !!! - I am lost...

Creating a database and its use was easy, but backup is another problem
because it must be done from a ISDN-Link or something like this (same
speed = 128 kBit). Even if I use an E1, I can not use the 2 MBit because
I will have Client-Servers, Mail-Server, the Wave-Lan for my Clients and
other stuff running.

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)

2. What is the traffic for changements ?

Thanks for your help
Michelle