[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 по дате отправления: