If one database is editable and the other read-only, there's a tool called slony:
http://www.slony.info

If both databases may be being edited, then things get far more complicated, and you'll need to write something custom to select records in one db that are missing from the other and add them. God only knows how you'd handle collisions.