Posted on 2007-03-27
I've replicated a database using the following commands:
pg_dump my_orig_database > outfile
psql -d my_new_database < outfile
These should now be two completely separate databases, correct? My problem is that after I did this and then made changes to my_orig_database through a web client, all of the new changes were also replicated to my_new_database. The web client explicitly connects to my_orig_database so I don't see how this is possible. Do I have to do anything different when creating/importing to the new database to ensure they are separate?