BUG #16954: After install postgresql.service activates but does not activate postgresql@11-main.service

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: aapo(dot)alasuutari(at)gmail(dot)com
Subject: BUG #16954: After install postgresql.service activates but does not activate postgresql@11-main.service
Date: 2021-04-08 13:35:45
Message-ID: 16954-0a88eaa43002e0f8@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16954
Logged by: Aapo Alasuutari
Email address: aapo(dot)alasuutari(at)gmail(dot)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(at)11-main(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-04-08 13:53:45 BUG #16955: Replication port problems
Previous Message Michael Paquier 2021-04-08 11:37:21 Re: BUG #16953: OOB access while converting "interval" to char