[arch-general] postgres 12
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?
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?
pacman -Q | grep postgres
WTF. postgresql-check-db-dir. 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?
Checking the bug tracker should be the first spot to look for an answer https://bugs.archlinux.org/task/68601 Local files got mixed after the test build as the tree contained a rebuild bump. Just wait for -3 hitting the repos and upgrade to it. Cheers
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Friday, November 13, 2020 9:36 AM, ente <ente@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.
participants (3)
-
ente
-
Levente Polyak
-
Maksim Fomin