Stop service (if exists), kill process 'postgres' (usually it exists). Run this in console:

pg_resetxlog.exe -D ../Data -f

This ussue appears because xLog directory have a data, that not be written before service shutted down. And then at service startup he try to fix that data. Sometimes it freeze startup and never ends.. Command at the up clean this unfixed data, that apply service to start with fixed data only. Maybe some parts of unfixed data will be lost, but database server will runs normally and can be accessed by apps.

I got this in logs:

MSK FATAL:  the database system is starting up

To fix infinite start of server do this: Stop service (if exists), kill process 'postgres' (usually it exists). Run this in console:

pg_resetxlog.exe -D ../Data -f

This ussue appears because xLog directory have a data, that not be written before service shutted down. And then at service startup he try to fix that data. Sometimes it freeze startup and never ends.. Command at the up clean this unfixed data, that apply service to start with fixed data only. Maybe some parts of unfixed data will be lost, but database server will runs normally and can be accessed by apps.

Тормозим службу (если есть), срубаем процесс postgres (скорее всего есть). Выполняем [code] pg_resetxlog.exe -D ../Data -f [/code] Суть в том, что в xLog у него остались данные, которые он считает незафикшенными. И усиленно пытается их зафиксить. Иногда на это требуются годы.. Комада выше отсекает эти повисшие данные, что позволяет стартонуть сервер с имеющимися в БД данными. Может потерять часть незафикшенных данных, но БД заработает.

Stop service (if exists), kill process 'postgres' (usually it exists). Run this in console:

pg_resetxlog.exe -D ../Data -f

This ussue appears because xLog directory have a data, that not be written before service shutted down. And then at service startup he try to fix that data. Sometimes it freeze startup and never ends.. Command at the up clean this unfixed data, that apply service to start with fixed data only. Maybe some parts of unfixed data will be lost, but database server will runs normally and can be accessed by apps.