On 5/29/20 8:19 AM, Tanja Savic wrote:
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 thepostgresql.conf path?
I'm guessing you are on Debian/Ubuntu?
If so what does the below show?:
pg_lsclusters
If it shows clusters then do:
sudo pg_ctlcluster 12 main start
If the above is not correct, then what user where you doing:
pg_ctl start
as?
Thank you,
Tanja
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
