pg_ctl can't start db server

From: Tanja Savic <tanja(dot)savic(at)crossmasters(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_ctl can't start db server
Date: 2020-05-29 15:19:42
Message-ID: VI1PR02MB3023BFD1415100747B1D9397948F0@VI1PR02MB3023.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We did the upgrade of PostgreSQL 10 to 12 on linux server. Everything was fine (can connect via pgAdmin, data is there...) except two tablespaces which are still in directory for PostgreSQL 10.
So we followed these steps to move tablespaces: https://www.enterprisedb.com/blog/moving-tablespaces-postgresql
The problem was at the end while executing:
$ pg_ctl start

This is the error trace:

pg_ctl: another server might be running; trying to start server anyway
waiting for server to start....postgres: could not access the server configuration file "/var/lib/postgresql/12/main/postgresql.conf": No such file or directory
stopped waiting
pg_ctl: could not start server
Examine the log output.

The configuration file path is /etc/postgresql/12/main/ postgresql.conf and it is configured in /var/lib/postgresql/12/main/postmaster.opts:

"/usr/lib/postgresql/12/bin/postgres "-D" "/var/lib/postgresql/12/main" "-c" "config_file=/etc/postgresql/12/main/postgresql.conf"

Why does pg_ctl complains about the postgresql.conf path?

Thank you,
Tanja

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-05-29 15:32:14 Re: pg_ctl can't start db server
Previous Message Tom Lane 2020-05-29 14:19:38 Re: problem with self built postgres 9.0.9