Thread: pgAdmin - Post installation question/s ?
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. 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
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 ray@rodonnell.ie
On 25/11/2024 21:00, Peter Richards wrote: > On Mon, 25 Nov 2024 10:27:40 +0000 > Ray O'Donnell <ray@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? > I spent quite a bit of time yesterday viewing documentation, videos of > 'how to', and many other posts. Hardly any, in fact probably none at > all, had information about the 'desktop' version of pgAdmin. So now I'm > resolved to uninstall it, and then install the 'web server' , the full > pgadmin. There are no other servers (except when I use Hugo locally and > that is brief) , so I can't see any conflicts. > > It's a bit like with the desktop version (I think it uses a Python > server, and not apache), there are necessary parts missing. > > So, I'll 'go with the flow' and install the full package. :) Did you try connecting to the server using psql, as I suggested? - this will tell you whether the network is the issue. Ray. > > Peter > > -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie
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: > > > 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 <ray@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 > > > > > > > > > > > > > -- 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
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-lists@jehoshua.com> wrote: > >> On Mon, 25 Nov 2024 10:27:40 +0000 Ray O'Donnell <ray@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 <ray@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 ray@rodonnell.ie
On Tue, 26 Nov 2024 09:34:28 +0000 Ray O'Donnell <ray@rodonnell.ie> wrote: > 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 > Thanks Ray. That link redirects back to the Wiki. As you have suggested, installing Postgresql is the first step. It seems that installing 'pgadmin' assumes one already has a Postgresql db installed/setup. Have read many articles to help and there was progression to the point of starting the Postgresql server. Then the content of the error msg changed to 'fatal and it was password related. Found this video at https://www.youtube.com/watch?v=vFENJpe6eJU , followed the steps and was able to complete the 'register server'. I have it all documented so that the next fresh install will be easier. Peter PS This reply may not get to the lists, seems my replies are being rejected due to some DKIM signature. > HTH, > > Ray. > > > > > > 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: > >> > >>> 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 <ray@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 > >>>> > >>>> > >>> > >> > >> > > > > > > -- 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