[galaxy-dev] major database corruption

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?