Em Friday 30 November 2007 05:02:25 Aarni Ruuhimäki escreveu: > > I followed the recent thread about 'replication in Postgres' but still any > info on experience of similar circumstances and pointers / comments / > recommendations are more than welcome. You problem is not one where replication would help so much. You can design your solution so that you *always* feed a local database and this local database syncs, from time to time, with a central database. What to use for syncs? Some script you can write easily. All entries should have the location as part of their PK, so that there are no clashes and you don't need to rely on sequences and the correct value being used everywhere. It is the same kind of problem that we have on supermarkets and POSs: the POS has to sell even if the connection with the server is down. -- Jorge Godoy <jgodoy@xxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
