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?
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/