From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: aapo.alasuutari@gmail.com
Subject: BUG #16954: After install postgresql.service activates but does not activate postgresql@11-main.service
Date: Thu, 08 Apr 2021 13:35:45 +0000
Message-ID: <16954-0a88eaa43002e0f8@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16954
Logged by: Aapo Alasuutari
Email address: aapo.alasuutari@gmail.com
PostgreSQL version: 11.2
Operating system: Ubuntu 18.04 on WSL2
Description:
I'm trying to install a development environment using some in-house ansible
playbooks. As part of the install postgresql is installed. The installation
commands happen as follows:
dpkg -i ssl-cert_1.0.39_all.deb
dpkg -i libllvm6.0_1%3a6.0-1ubuntu2_amd64.deb
dpkg -i libpq5_11.2-1.pgdg18.04+1_amd64.deb
dpkg -i pgdg-keyring_2018.2_all.deb
dpkg -i postgresql-client-common_199.pgdg18.04+1_all.deb
dpkg -i postgresql-common_199.pgdg18.04+1_all.deb
dpkg -i postgresql-client-11_11.2-1.pgdg18.04+1_amd64.deb
dpkg -i postgresql-11_11.2-1.pgdg18.04+1_amd64.deb
apt-get autoremove -fy
rm -f *.deb
sudo -u postgres /usr/bin/psql -U postgres -d postgres -t -c ALTER USER
Postgres WITH PASSWORD '***';
At the first postgres command the install fails on my WSL2 machine, while it
does not fail on a Ubuntu 18.04 Oracle VBox virtual machine. The reason for
the failure is that there is no socket.
Looking at the postgresql.service, it is active and shows no errors in log.
The latest message is "Started PostgreSQL RDBMS."
However, then looking at the postgresql@11-main.service, the service is
loaded but inactive. So far I have not managed to find any errors pertaining
to the postgresql install that would point to any obvious reason for the
failure for the actual service to activate.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, aapo.alasuutari@gmail.com
Subject: Re: BUG #16954: After install postgresql.service activates but does not activate postgresql@11-main.service
In-Reply-To: <16954-0a88eaa43002e0f8@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox