Rod Taylor <pg(at)rbt(dot)ca> writes:
> At some point it must have failed in copying the data across, aborted,
> and restarted.
Unless you had an actual backend crash, that's not an adequate
explanation. Transaction abort does clean up created files.
regards, tom lane