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