Alas I didn't bother making a backup since It is a research database. Still it is large enough that I'd rather not do a dump/restore now of the tables that I'd want to dump/restore. Is there some other neat alternative that I can do to just terminate postgresql's attempt to clean up after I messed it up? BTW I don't know the name of the table that it was trying to create since my stored procedure had generated a name starting with "tmp" and having a time stamp and other info after that. Originally I was using a temporary table, but had made it permanent to help debug...
On Fri, Feb 26, 2021 at 7:46 AM Juan José Santamaría Flecha <juanjo.santamaria@xxxxxxxxx> wrote:
On Fri, Feb 26, 2021 at 9:15 AM Celia McInnis <celia.mcinnis@xxxxxxxxx> wrote:Help! Is there some way to have the system come up without trying to restore the state that it was in when I crashed the system? The tables that were being formed are not of any use to me.What you are trying to achieve sounds like restoring a backup, do you have any available?Regards,Juan José Santamaría Flecha