Please help!<br><br>I&#39;m new to sys admin and I&#39;ve really messed up.<br><br>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).<br>
<br>I was testing the ability to backup and restore with the development instance but made the following huge mistake:<br><ul><li>ran &quot;pg_dump galaxydb_dev 25_09_2012.sql&quot;<br></li><li>connected to the production instance database by accident<br>
</li><li>ran &quot;galaxydb_prod=# \i  25_09_2012.sql&quot;</li></ul><p>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?<br>
</p>