OK, cheers. How can I remove the db so I can restore it properly? From: Scott Mead <scottm@xxxxxxxxxxx>
Date: Monday, 23 October 2017 at 16:35
To: Martin Moore <martin.moore@xxxxxxxxxxx>
Cc: Michael Nolan <htfoot@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Postgres 9.6 fails to start on VMWare On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore <martin.moore@xxxxxxxxxxx> wrote: It was running – not sure how dd handles this. Maybe badly… ☺
it doesn't handle it at all. This would be the cause of your issue. On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore <martin.moore@xxxxxxxxxxx> wrote: Same server. I tried a few times.
I didn’t move the db separately, but did a ‘dd’ to copy the disk to an imagefile which was converted and loaded into VMWare.
I ‘believed’ that this should keep the low level disk structure the same, but if this has corrupted the files I can drop, dump and restore, in which case how do I ‘drop’ the DB without postgres running?
Ta,
Martin.
Was the server you were backing up shut down or in backup mode when you did the 'dd' copy?
-- |
