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(dot)klaver(at)aklaver(dot)com