Postgres 9.3 service no longer starts on Windows 8.1

Поиск
Список
Период
Сортировка
От Lisa Ruby
Тема Postgres 9.3 service no longer starts on Windows 8.1
Дата
Msg-id ac324c4d-7084-137a-55cb-d2e80df8a280@protonmail.com
обсуждение исходный текст
Ответы Re: Postgres 9.3 service no longer starts on Windows 8.1  (Lisa Ruby <lbruby1@protonmail.com>)
Список pgsql-general
I am using Postgres 9.3 on a Windows 8.1 computer. I've been using it
for over 5 years on the same computer to provide a database for a local
JIRA Server. I did a normal restart of my computer last night and ever
since then the Postgres service fails to start. I am able to start
Postgres from the command line using pg_ctl start -D <path to database>
-w,  and JIRA is then able to connect to the database.

When I try (or the system tries) to start the Postgres Service from
Windows Services the event log shows this error for Postgres:

2021-01-25 23:37:36 PST FATAL:  data directory
"D:/mysoftware/PostgreSQL/9.3" does not exist

The database does exist in this data directory, and I use the same exact
path for it when starting Postgres from the command line. This error
started appearing when Postgres stopped correctly starting as a service.

There are no other errors/warnings in the Event log that aren't always
there.

The latest entries in the postgresql log look like this:

2021-01-26 17:21:05 PST LOG:  database system was shut down at
2021-01-26 17:20:31 PST
2021-01-26 17:21:05 PST LOG:  MultiXact member wraparound protections
are now enabled
2021-01-26 17:21:05 PST LOG:  database system is ready to accept connections
2021-01-26 17:21:05 PST LOG:  autovacuum launcher started
2021-01-26 17:25:05 PST LOG:  server process (PID 2372) was terminated
by exception 0xC000013A
2021-01-26 17:25:05 PST DETAIL:  Failed process was running: UPDATE
public.clusteredjob SET  VERSION = $1 ,  NEXT_RUN = $2  WHERE JOB_ID=$3
AND VERSION=$4
2021-01-26 17:25:05 PST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2021-01-26 17:25:05 PST LOG:  terminating any other active server processes
2021-01-26 17:25:05 PST WARNING:  terminating connection because of
crash of another server process
2021-01-26 17:25:05 PST DETAIL:  The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-01-26 17:25:05 PST HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2021-01-26 17:25:05 PST WARNING:  terminating connection because of
crash of another server process
2021-01-26 17:25:05 PST DETAIL:  The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-01-26 17:25:05 PST HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2021-01-26 17:25:05 PST WARNING:  terminating connection because of
crash of another server process
2021-01-26 17:25:05 PST DETAIL:  The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-01-26 17:25:05 PST HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2021-01-26 17:25:05 PST WARNING:  terminating connection because of
crash of another server process
2021-01-26 17:25:05 PST DETAIL:  The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-01-26 17:25:05 PST HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2021-01-26 17:25:05 PST WARNING:  terminating connection because of
crash of another server process
2021-01-26 17:25:05 PST DETAIL:  The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2021-01-26 17:25:05 PST HINT:  In a moment you should be able to
reconnect to the database and repeat your command.
2021-01-26 17:25:05 PST LOG:  all server processes terminated;
reinitializing
2021-01-26 17:25:05 PST LOG:  database system was interrupted; last
known up at 2021-01-26 17:21:05 PST
2021-01-26 17:25:07 PST LOG:  startup process (PID 5376) was terminated
by exception 0xC000013A
2021-01-26 17:25:07 PST HINT:  See C include file "ntstatus.h" for a
description of the hexadecimal value.
2021-01-26 17:25:07 PST LOG:  aborting startup due to startup process
failure

Can anyone help me fix this so that Postgres will again start as a
Windows service like it has been for the last 5 years, until last night?

Thank you.

Lisa




В списке pgsql-general по дате отправления:

Предыдущее
От: Wenjun Che
Дата:
Сообщение: Re: Change work_mem for one user
Следующее
От: Lisa Ruby
Дата:
Сообщение: Re: Postgres 9.3 service no longer starts on Windows 8.1