Re: Postgres 9.6 fails to start on VMWare

OK, cheers.

How can I remove the db so I can restore it properly?

From: Scott Mead <scottm(at)openscg(dot)com>
Date: Monday, 23 October 2017 at 16:35
To: Martin Moore <martin(dot)moore(at)avbrief(dot)com>
Cc: Michael Nolan <htfoot(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore <martin(dot)moore(at)avbrief(dot)com> 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.

--Scott

From: Michael Nolan <htfoot(at)gmail(dot)com>
Date: Monday, 23 October 2017 at 15:52
To: Martin Moore <martin(dot)moore(at)avbrief(dot)com>
Cc: rob stone <floriparob(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore <martin(dot)moore(at)avbrief(dot)com> 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?

--

Mike Nolan

--

--
Scott Mead
Sr. Architect
OpenSCG

http://openscg.com