[GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start
Дата
Msg-id alpine.LNX.2.11.1703100914240.26081@localhost
обсуждение исходный текст
Ответы Re: [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start
Список pgsql-general
   I've tried resolving this but do not see what changed.

   1. Shut down postgres:
     pg_ctl stop -D /var/lib/pgsql/9.6/data

   2. Upgraded version (using SlackBuilds.org package as usual).

   3. Tried re-starting postgres:

postgres@salmo:~$ postgres -D /var/lib/pgsql/9.6/data/ &
[1] 17585
postgres@salmo:~$ LOG:  could not open secondary authentication file
"@authcomment@" as "/var/lib/pgsql/9.6/data/authcomment@": No such file or
directory
LOG:  could not open secondary authentication file
"@remove-line-for-nolocal@" as
"/var/lib/pgsql/9.6/data/remove-line-for-nolocal@": No such file or
directory
LOG:  could not open secondary authentication file
"@remove-line-for-nolocal@local" as
"/var/lib/pgsql/9.6/data/remove-line-for-nolocal@local": No such file or
directory
LOG:  could not open secondary authentication file "@authmethodlocal@" as
"/var/lib/pgsql/9.6/data/authmethodlocal@": No such file or directory
LOG:  could not open secondary authentication file
"@remove-line-for-nolocal@" as
"/var/lib/pgsql/9.6/data/remove-line-for-nolocal@": No such file or
directory
LOG:  invalid connection type "all"
CONTEXT:  line 80 of configuration file
"/var/lib/pgsql/9.6/data/pg_hba.conf"
FATAL:  could not load pg_hba.conf
LOG:  database system is shut down

   4. Line 80 in pg_hba.conf:
@remove-line-for-nolocal@local   all    all   @authmethodlocal@

   5. Tried commenting out that line to match backup, but that also did not
allow postgres to start.

   6. All files are owned by postgres.users.

   Please teach me how to fix this.

TIA,

Rich



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Unable to start postgresql
Следующее
От: Rich Shepard
Дата:
Сообщение: [GENERAL] INSERT and ON CONFLICT