Re: [ADMIN] how do I do dump and restore without bugging with constraint?

2010-02-22 Thread Net Tree Inc.
Ok, I am just trying to find the proper way to back and restore database that contain restriction. The other way to ask. If I have two 99% schema similar databases. The old one might contain few columns that does not exist in the new one and contain constrains that the new DB does not have. In tha

Re: [ADMIN] how do I do dump and restore without bugging with constraint?

2010-02-22 Thread Kevin Grittner
"Net Tree Inc." wrote: > When I do restore it shown alot errors related with constraints. > How can I dump and to restore from old to new without dealing with > constraint and just forces data dump to where it suppose to belong? What version are you dumping from and to? Exactly what errors ar

[ADMIN] how do I do dump and restore without bugging with constraint?

2010-02-22 Thread Net Tree Inc.
Hi all, I am dumping both schema and data from old database to new one. The new database schema is somehow contain slightly different schema then the old one. When I do restore it shown alot errors related with constraints. How can I dump and to restore from old to new without dealing with constra

Re: [ADMIN] Using Postgresql Replication

2010-02-22 Thread Iñigo Martinez Lasala
PGcluster doesn’t work. One year ago we where trying to deploy a cluster using pgcluster and we were unable to get it work without problems. We finally selected slony. It works quite well and it’s quite easy to deploy by following tutorials. We worked with slony-I. However, slony only replica