Re: Postgres 9.6 fails to start on VMWare

From: Scott Mead <scottm(at)openscg(dot)com>
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: Postgres 9.6 fails to start on VMWare
Date: 2017-10-23 15:35:56
Message-ID: CAKq0gv+f+_mjqevTkPLADGsjL0S+1pC5J6noScCBHpnOwCKx9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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>*
http://openscg.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Moore 2017-10-23 15:37:10 Re: Postgres 9.6 fails to start on VMWare
Previous Message Peter Geoghegan 2017-10-23 15:35:06 Re: table corruption