Re: Help with data transfer please
От | tony |
---|---|
Тема | Re: Help with data transfer please |
Дата | |
Msg-id | 1023734437.2979.231.camel@vaio обсуждение исходный текст |
Ответ на | Re: Help with data transfer please (Andrew Sullivan <andrew@libertyrms.info>) |
Ответы |
Re: Help with data transfer please
Re: Help with data transfer please |
Список | pgsql-general |
On Mon, 2002-06-10 at 17:42, Andrew Sullivan wrote: > I I understand his need correctly, what is needed is a two-way sync: > changes in office 1 need to be in office 2 for when he goes to office > 2, and then changes made at office 2 need to get sent back to office > 1. If I'm right, rserv won't work. Recent discussions of > replication did not, IIRC, turn up any multi-master replication > systems other than Postgres-R. (Maybe I don't RC, though.) > > One answer might be to buy a laptop. Carry the database in the > laptop. It's another expense, of course, but it might work. Good idea > Alternatively, since the database can (presumably) be shut down every > night, why not shut down the postmaster at each end and use rsync to > synchronise the data directories? (I haven't tested that, and don't > know if it'll work, but I think it should.) SSH is your friend! Set up a cron job that dumps the database. SCP the dump from one machine to the other. Drop the database and recreate it. Import the dump file. This is the system I will be putting into place for a client in september. For another with non sensitive data the dump is e-mailed daily as a backup. Just got to love aDSL!! Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
В списке pgsql-general по дате отправления: