Please help! I'm new to sys admin and I've really messed up. On our server we have a development instance and a production instance of Galaxy. Both run under the same user (galaxy) and each has its own postgresql table (galaxydb_dev and galaxydb_prod). I was testing the ability to backup and restore with the development instance but made the following huge mistake: - ran "pg_dump galaxydb_dev 25_09_2012.sql" - connected to the production instance database by accident - ran "galaxydb_prod=# \i 25_09_2012.sql" Is there any way that I can at least get the important relations and tuples out and in to a new production instance? I have the dump file and the output from running the \i command... Has anyone recovered from a similar situation?