Re: PostgreSQL Synchronization?

joe@jwebmedia.com wrote: > > Anyone have any ideas on how to do this without waiting for eRServer? > > Thanks, > > Joe > > Joe Conway wrote: > > > Subject: [PHP] PostgreSQL Synchronization? > > > > > Sorry if this question has been answered before - I couldn't find it in > > > the archives. What would be the best method for synchronizing data > > > between a local postgres database and one on the web server? I really > > > don't know where to start. Thanks, > > > > > > > I don't know too much detail about it, but there is a project by PostgreSQL, > > Inc. to produce a replication server for PostgreSQL. I think I read > > somewhere that it might make it into the 7.1 release. Here's more info: > > http://www.erserver.com/ > > > > Hope this helps, > > > > Joe <Idea only> This is ajust a thought out of left field.... Could you add a fields for when a record in each table was modified which is timestamped unpon each and every modification. When you wish to sync. the databases, perform a select of the sort below select * from table where modification_date < now(); >> table_dump Then on the web server psql < tabledump just a thought never tried this... <idea only> Othewise you may have to port the databse over to mysql as it is supported out of the box.... > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- george@laopdr.com Network Administrator Planet Online Vientiane, Lao PDR