Re: pgAdmin - Post installation question/s ?

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(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
>>>>
>>>>
>>>
>>
>>
>
>

--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie