In response to "Bobby Gontarski" <Gontarski@xxxxxxxxx>: > Basically I need to copy db1 to db2 which I create manually. How do I > do that, I tried pg_dump pg_restore but I get some errors with foreign > key restraint... You can use create database with db1 as the template. See the docs for details. -- Bill Moran Collaborative Fusion Inc.