Message-ID: 
 <0102019367d27d65-a1e920a8-0761-4b29-95a8-6ec957bd5211-000000@eu-west-1.amazonses.com>
Date: Tue, 26 Nov 2024 09:34:28 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pgAdmin - Post installation question/s ?
To: Peter Richards <pgsql-pgadmin-lists@jehoshua.com>,
	pgadmin-support@lists.postgresql.org
References: <20241125092331.2f031abd@Thinkpad-T470S>
 <0102019362dcd77a-d7a30c23-0cd1-43df-be4c-a3eb22af9b8f-000000@eu-west-1.amazonses.com>
 <20241126104345.4e1342e0@Thinkpad-T470S>
 <20241126122417.5e4d116b@Thinkpad-T470S>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: <20241126122417.5e4d116b@Thinkpad-T470S>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Feedback-ID: 
 ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES
Archived-At: 
 <https://www.postgresql.org/message-id/0102019367d27d65-a1e920a8-0761-4b29-95a8-6ec957bd5211-000000%40eu-west-1.amazonses.com>
Precedence: bulk

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