Инцидент: в ситуации, когда сервер был выключен аварийно, через кнопку выключения или при отсутствии электропитания, то после его включения служба PostgreSQL в некоторых случаях не запускается.
Некорретное завершение работы службы
| Информация |
|---|
Для любых версий PostgreSQL:
|
Некорретное завершение работы службы
Как исправить:
1. Запустите сеанс командной строки от Администратора.
...
Сравнительная таблица списка исполняемых файлов в версиях PostgreSQL
| PostgreSQL 9.4 | PostgreSQL 11.7 |
| clusterdb.exe | clusterdb.exe |
| createdb.exe | createdb.exe |
| createlang.exe | createuser.exe |
| createuser.exe | dropdb.exe |
| dropdb.exe | dropuser.exe |
| droplang.exe | ecpg.exe |
| dropuser.exe | icudt53.dll |
| ecpg.exe | icuin53.dll |
| iconv.dll | icuio53.dll |
| initdb.exe | icule53.dll |
| isolationtester.exe | iculx53.dll |
| libeay32.dll | icutest53.dll |
| libintl-8.dll | icutu53.dll |
| libpq.dll | icuuc53.dll |
| libxml2.dll | initdb.exe |
| libxslt.dll | isolationtester.exe |
| oid2name.exe | libcrypto-1_1-x64.dll |
| pg_archivecleanup.exe | libcurl.dll |
| pg_basebackup.exe | libcurl.lib |
| pg_config.exe | libecpg.dll |
| pg_controldata.exe | libecpg_compat.dll |
| pg_ctl.exe | libiconv-2.dll |
| pg_dump.exe | libintl-9.dll |
| pg_dumpall.exe | libpgtypes.dll |
| pg_isolation_regress.exe | libpq.dll |
| pg_isready.exe | libssl-1_1-x64.dll |
| pg_receivexlog.exe | libwinpthread-1.dll |
| pg_recvlogical.exe | libxml2.dll |
| pg_regress.exe | libxslt.dll |
| pg_regress_ecpg.exe | oid2name.exe |
| pg_resetxlog.exe | pg_archivecleanup.exe |
| pg_restore.exe | pg_basebackup.exe |
| pg_standby.exe | pg_config.exe |
| pg_test_fsync.exe | pg_controldata.exe |
| pg_test_timing.exe | pg_ctl.exe |
| pg_upgrade.exe | pg_dump.exe |
| pg_xlogdump.exe | pg_dumpall.exe |
| pgAdmin3.exe | pg_isolation_regress.exe |
| pgbench.exe | pg_isready.exe |
| postgres.exe | pg_receivewal.exe |
| psql.exe | pg_recvlogical.exe |
| reindexdb.exe | pg_regress.exe |
| ssleay32.dll | pg_regress_ecpg.exe |
| stackbuilder.exe | pg_resetwal.exe |
| vacuumdb.exe | pg_restore.exe |
| vacuumlo.exe | pg_rewind.exe |
| wxbase28u_net_vc_custom.dll | pg_standby.exe |
| wxbase28u_vc_custom.dll | pg_test_fsync.exe |
| wxbase28u_xml_vc_custom.dll | pg_test_timing.exe |
| wxmsw28u_adv_vc_custom.dll | pg_upgrade.exe |
| wxmsw28u_aui_vc_custom.dll | pg_verify_checksums.exe |
| wxmsw28u_core_vc_custom.dll | pg_waldump.exe |
| wxmsw28u_html_vc_custom.dll | pgbench.exe |
| wxmsw28u_stc_vc_custom.dll | postgres.exe |
| wxmsw28u_xrc_vc_custom.dll | psql.exe |
| zic.exe | reindexdb.exe |
| zlib1.dll | stackbuilder.exe |
| vacuumdb.exe | |
| vacuumlo.exe | |
| wxbase28u_net_vc_custom.dll | |
| wxbase28u_vc_custom.dll | |
| wxbase28u_xml_vc_custom.dll | |
| wxmsw28u_adv_vc_custom.dll | |
| wxmsw28u_aui_vc_custom.dll | |
| wxmsw28u_core_vc_custom.dll | |
| wxmsw28u_html_vc_custom.dll | |
| wxmsw28u_xrc_vc_custom.dll | |
| zic.exe | |
| zlib1.dll |
...