It was running – not sure how dd handles this. Maybe badly… ☺
From: Michael Nolan <htfoot@gmail.com> Date: Monday, 23 October 2017 at 15:52 To: Martin Moore <martin.moore@avbrief.com> Cc: rob stone <floriparob@gmail.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare
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?