On 26/11/2024 02:24, Peter Richards wrote:
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.
PgAdmin is a administration tool - the actual database server is
different altogether, and as you've seen, needs to be installed
separately. It looks as if you're on Debian or a Debian-based
distribution, so to install PostgreSQL itself you'll need to do
something like:
sudo apt install postgresql-17
...or whatever version is available. I'd strongly recommend using the
community apt repo - see the instructions here:
https://apt.postgresql.org
HTH,
Ray.
Peter
On Tue, 26 Nov 2024 10:43:45 +1000
Peter Richards <pgsql-pgadmin-li...@jehoshua.com> wrote:
On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <r...@rodonnell.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@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@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@Thinkpad-T470S:~$ psql --version
psql (PostgreSQL) 16.4 (Ubuntu 16.4-0ubuntu0.24.04.2)
The Apache service is running ..
peter@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 <r...@rodonnell.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
--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie
