Copy Postgres to another computer
Posted on 2009-05-15
I just installed Postgres on a test server and I need some guidance on how to copy a Postgres database and all relevant information from a Windows server to my test Windows server
I know that I would need to do a dump from the source computer and restore it on the target computer, but I'm not sure of the exact commands or any other relevant information that I should also copy over such as the schema.
Just as an FYI, I have the user name/password for the database root account and for the backup and restore.