Re: pg_ctl can't start db server

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@aklaver.com