[arch-general] postgres 12

[Maksim Fomin]

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, November 13, 2020 9:36 AM, ente <ente at ck76.de> 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?

Yes, there is a bug. It cost me my local database.