[arch-general] postgres 12

[ente]

postgresql-check-db-dir seems to be broken? When I execute:

> postgresql-check-db-dir data

it reports: An old version of the database format was found. Anyone
facing the same issue?

On Fri, 2020-11-13 at 10:36 +0100, ente wrote:
> Hi,
> 
> 
> since the upgrade of postgress from 11.9 to 12.5 I am having issues
> starting up using the systemd service file.
> 
> When I do:
> > su postgres
> > postgress -D data
> 
> it works great. When I do
> > systemctl start postgresql
> 
> I get: An old version of the database format was found.
> 
> Checking the database version shows it is on 12. So obviously the
> systemd unit file seems to point postgres to an unexpected location.
> 
> My system file is pointing to a non-standard location according to
> the
> arch wiki:
> [Service]
> Environment=PGROOT=/pathto/pgroot
> PIDFile=/pathto/pgroot/data/postmaster.pid
> 
> Anyone else facing the same issue? Any suggestions?