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
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: