[arch-general] postgres 12

[ente]

WTF. postgresql-check-db-dir. 

> pacman -Q | grep postgres
postgresql 12.5-1
postgresql-libs 12.5-1

Content of postgresql-check-db-dir:

# PGMAJORVERSION is major version
PGMAJORVERSION=13
# PREVMAJORVERSION is the previous major version
PREVMAJORVERSION=12

So it seems postgresql-check-db-dir is slightly ahead of its time?

Of course I could now go an fix this manually. How quick can the
maintainer take care?



On Fri, 2020-11-13 at 10:44 +0100, ente wrote:
> 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?