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.
On 23/10/2017, 00:51, "rob stone" <floriparob@gmail.com> wrote:
On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote: > 2017-10-22 14:08:28 UTC [2479-1] LOG: 00000:
databasesystem > shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC There is something missing
here.Last shutdown at 2017-10-22 14:07:20 UTC on which server? Then attempting to start it at 2017-10-22 14:08:28
UTC?One minute and eight seconds later. It might also help if you explained exactly how you moved the database
fromGoogle Compute to this VM machine. Cheers, robert
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general