Re: pgAdmin - Post installation question/s ?

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(at)jehoshua(dot)com> wrote:

> On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <ray(at)rodonnell(dot)ie>
> wrote:
>
> > It certainly sounds like a network issue. Can you connect to the
> > server using psql, from the same machine as the one with pgAdmin?
>
> 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)
>
> peter(at)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?
>
> peter(at)Thinkpad-T470S:~$ apt list --installed | grep sql
>
> WARNING: apt does not have a stable CLI interface. Use with caution in
> scripts.
>
> 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]
>
> Although this works ..
>
> peter(at)Thinkpad-T470S:~$ psql --version
> psql (PostgreSQL) 16.4 (Ubuntu 16.4-0ubuntu0.24.04.2)
>
> The Apache service is running ..
>
> peter(at)Thinkpad-T470S:~$ systemctl status apache2
> ● 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=/usr/sbin/apachectl start (code=exited,
> status=0/SUCCESS) Main PID: 5041 (apache2)
> Tasks: 84 (limit: 9288)
> Memory: 172.8M (peak: 181.8M)
> CPU: 7.331s
> CGroup: /system.slice/apache2.service
> ├─5041 /usr/sbin/apache2 -k start
> ├─5043 /usr/sbin/apache2 -k start
> ├─5044 /usr/sbin/apache2 -k start
> └─5045 /usr/sbin/apache2 -k start
>
> 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.
>
> Cheers,
>
> Peter
>
>
> On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <ray(at)rodonnell(dot)ie>
> wrote:
>
> > On 24/11/2024 23:23, Peter Richards wrote:
> > > 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.
> >
> > It certainly sounds like a network issue. Can you connect to the
> > server using psql, from the same machine as the one with pgAdmin?
> >
> > Ray.
> >
> >
> >
> > >
> > > Peter
> > >
> > >
> >
> >
>
>
>

--
Peter Richards
-- -- -- -- -- -- --

There’s 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