Using Postgres 9.1
(1)
Simulate a "power failure" by hitting "Restart" on my VMware Workstation.
(2)
Turn on the VM (without any script removing lock or socket file).
(3)
Try to start postgres.
$ pgsql/bin/pg_ctl start -D pgdata
server starting
2013-01-14 FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
2013-01-14 HINT: Is another postmaster (PID 2770) using socket file "/tmp/.s.PGSQL.5432"?
So to be able to start Postgres . . .
In our "vm startup script", should we remove only the [.s.PGSQL.5432.lock] file ?
Or should we also remove the [.s.PGSQL.5432] file ?
Thanks,
-dvs-