Re: [GENERAL] Postgres 9.6 fails to start on VMWare - Mailing list pgsql-general

From Scott Mead
Subject Re: [GENERAL] Postgres 9.6 fails to start on VMWare
Date
Msg-id CAKq0gv+f+_mjqevTkPLADGsjL0S+1pC5J6noScCBHpnOwCKx9w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Postgres 9.6 fails to start on VMWare  (Martin Moore <martin.moore@avbrief.com>)
Responses Re: [GENERAL] Postgres 9.6 fails to start on VMWare  (Martin Moore <martin.moore@avbrief.com>)
List pgsql-general


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

 

 

 

On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore <martin.moore@avbrief.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

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] table corruption
Next
From: Martin Moore
Date:
Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare