Date: Tue, 26 Nov 2024 12:24:17 +1000
From: Peter Richards <pgsql-pgadmin-lists@jehoshua.com>
To: pgadmin-support@lists.postgresql.org
Subject: Re: pgAdmin - Post installation question/s ?
Message-ID: <20241126122417.5e4d116b@Thinkpad-T470S>
In-Reply-To: <20241126104345.4e1342e0@Thinkpad-T470S>
References: <20241125092331.2f031abd@Thinkpad-T470S>
	<0102019362dcd77a-d7a30c23-0cd1-43df-be4c-a3eb22af9b8f-000000@eu-west-1.amazonses.com>
	<20241126104345.4e1342e0@Thinkpad-T470S>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/20241126122417.5e4d116b%40Thinkpad-T470S>
Precedence: bulk


The article at https://wiki.postgresql.org/wiki/Apt  , for the
quick-start has the following commands:

	sudo apt install -y postgresql-common
	sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

as postgresql-common is not installed, and the file directory above
doesn't exist, should I install as per those above commands ?

I would have thought pgadmin4 installation would have included
everything though.

 Peter

 On Tue, 26 Nov 2024 10:43:45 +1000
Peter Richards <pgsql-pgadmin-lists@jehoshua.com> wrote:

> On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <ray@rodonnell.ie>
> wrote:
>=20
> > It certainly sounds like a network issue. Can you connect to the
> > server using psql, from the same machine as the one with pgAdmin? =20
>=20
> So, I have now installed pgadmin4, and still getting the same message
> ( Unable to connect to server. connection failed. connection to a
> server at "127.0.0.1":port 5432 failed)
>=20
> peter@Thinkpad-T470S:~$ psql
> psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
> Is the server running locally and accepting connections on that
> socket?
>=20
> peter@Thinkpad-T470S:~$ apt list --installed | grep sql
>=20
> WARNING: apt does not have a stable CLI interface. Use with caution in
> scripts.
>=20
> libaprutil1-dbd-sqlite3/noble,now 1.6.3-1.1ubuntu7 amd64
> [installed,automatic] libqt5sql5-sqlite/noble,now
> 5.15.13+dfsg-1ubuntu1 amd64 [installed,automatic]
> libqt5sql5t64/noble,now 5.15.13+dfsg-1ubuntu1 amd64
> [installed,automatic] libqt6sql6-sqlite/noble,now
> 6.4.2+dfsg-21.1build5 amd64 [installed,automatic]
> libqt6sql6t64/noble,now 6.4.2+dfsg-21.1build5 amd64
> [installed,automatic] libsqlcipher1/noble,now 4.5.6-1build2 amd64
> [installed,automatic] libsqlite3-0/noble,now 3.45.1-1ubuntu2 amd64
> [installed,automatic] postgresql-client-16/noble-updates,now
> 16.4-0ubuntu0.24.04.2 amd64 [installed,automatic]
> postgresql-client-common/noble-updates,noble-updates,now 257build1.1
> all [installed,automatic]
> postgresql-client/noble-updates,noble-updates,now 16+257build1.1 all
> [installed,automatic] sqlitebrowser/noble,now 3.12.2-3build2 amd64
> [installed]
>=20
> Although this works ..
>=20
> peter@Thinkpad-T470S:~$ psql --version
> psql (PostgreSQL) 16.4 (Ubuntu 16.4-0ubuntu0.24.04.2)
>=20
> The Apache service is running ..
>=20
> peter@Thinkpad-T470S:~$ systemctl status apache2
> =E2=97=8F apache2.service - The Apache HTTP Server
>      Loaded: loaded (/usr/lib/systemd/system/apache2.service; enabled;
> preset: enabled) Active: active (running) since Tue 2024-11-26
> 08:44:04 AEST; 1h 54min ago Docs: https://httpd.apache.org/docs/2.4/
>     Process: 5037 ExecStart=3D/usr/sbin/apachectl start (code=3Dexited,
> status=3D0/SUCCESS) Main PID: 5041 (apache2)
>       Tasks: 84 (limit: 9288)
>      Memory: 172.8M (peak: 181.8M)
>         CPU: 7.331s
>      CGroup: /system.slice/apache2.service
>              =E2=94=9C=E2=94=805041 /usr/sbin/apache2 -k start
>              =E2=94=9C=E2=94=805043 /usr/sbin/apache2 -k start
>              =E2=94=9C=E2=94=805044 /usr/sbin/apache2 -k start
>              =E2=94=94=E2=94=805045 /usr/sbin/apache2 -k start
>=20
> Nov 26 08:44:04 Thinkpad-T470S systemd[1]: Starting apache2.service -
> The Apache HTTP Server... Nov 26 08:44:04 Thinkpad-T470S
> apachectl[5040]: AH00558: apache2: Could not reliably determine the
> server's fully qualified domain name, using 127.0.1.1. Set the
> 'ServerName' directive globally to suppress this message Nov 26
> 08:44:04 Thinkpad-T470S systemd[1]: Started apache2.service - The
> Apache HTTP Server.
>=20
> Cheers,
>=20
> Peter
>=20
>=20
> On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <ray@rodonnell.ie>
> wrote:
>=20
> > On 24/11/2024 23:23, Peter Richards wrote: =20
> > > Running Kubuntu 24.04 and needing to maintain a PostGreSQL
> > > database. Wanting to use pgAdmin and possibly some Python code to
> > > maintain the database.
> > >
> > > I have downloaded and installed the APT version from
> > > https://www.pgadmin.org/download/pgadmin-4-apt/
> > >
> > > Keep getting stuck on the Register Server | Connection
> > >   - Unable to connect to server. connection failed. connection to
> > > a server at "127.0.0.1":port 5432 failed"
> > >
> > > Is this just a firewall related error ? I have looked through
> > > various guides and cannot find one that is a 'post install'
> > > based.   =20
> >=20
> > It certainly sounds like a network issue. Can you connect to the
> > server using psql, from the same machine as the one with pgAdmin?
> >=20
> > Ray.
> >=20
> >=20
> >  =20
> > >
> > >   Peter
> > >
> > >   =20
> >=20
> >  =20
>=20
>=20
>=20


--=20
Peter Richards
-- -- -- -- -- -- --=20

There=E2=80=99s not something etched in stone that must be achieved in order
for healing to occur, except complete and unconditional
self-acceptance.-  Yeshua - Way of Mastery