Re: following install of Postgres on Centos 7, how to install PGAdmin

There's a link to the documentation on that page - latest docs.

Download and install pgadmin on your Windows machine. Assuming SSH is 
enabled on the pgsql machine...

Next you'll want to edit pg_hba.conf (on your pgsql server) to include a 
line similar to this:

host   all   all   127.0.0.1/32   scram-sha-256

Next you'll need to register the server in pgadmin.

Under Connection, the host name/address should be localhost
If you're managing all databases on the server, leave the user/database 
information as is. i.e. connect as postgres, connect to postgres.

You can enter your postgres password here and opt to have it saved.

Under SSH Tunnel, enter the pgsql server's hostname and the username 
with which you can connect to it via SSH.

Save the connection and you should be prompted for at least your SSH 
password, possibly the postgres user password too.

If you have not set a password for the postgres user, you must do that 
first.

If you do not have admin rights on the Windows PC you may not be able to 
follow through with this because an exception has to be added to the 
Windows firewall, which may, depending on local policy, be restricted to 
administrators.

Nic

On 27/06/23 13:37, James, David (RIS-SUT) wrote:
> many thanks for your reply – are you saying that although I have Postgres running on Linux, I only need to choose the
Windowsoption for installing PGAdmin?
 
> 
> So, I should start from here ? https://www.pgadmin.org/download/pgadmin-4-windows/
> 
> If you know of any documentation that might accompany this?
> 
> Thank you again.
> 
> DJ.
> 
> From: Rajiv Harlalka <rajivharlalka009@gmail.com>
> Sent: Tuesday, June 27, 2023 1:24 PM
> To: James, David (RIS-SUT) <david.james@lexisnexisrisk.com>
> Cc: pgsql-novice@lists.postgresql.org
> Subject: Re: following install of Postgres on Centos 7, how to install PGAdmin
> 
> You don't often get email from rajivharlalka009@gmail.com<mailto:rajivharlalka009@gmail.com>. Learn why this is
important<https://aka.ms/LearnAboutSenderIdentification>
> 
> *** External email: use caution ***
> 
> 
> Since you'll access the Server on the Windows machine, PGAdmin needs to be installed on the Windows machine. Only
necessaryconfigurational changes in pg_hba.conf and postgresql.conf would be needed as per your settings for PGAdmin to
beable to connect to the server on the CentOS server.
 
> 
> Regards,
> Rajiv
> 
> 
> On Tue, Jun 27, 2023 at 3:13 PM James, David (RIS-SUT)
<david.james@lexisnexisrisk.com<mailto:david.james@lexisnexisrisk.com>>wrote:
 
> Hello All
> 
> This is my first ever post here.
> I have successfully installed Postgres on our Centos 7 server. I would now like to install PGAdmin so I can use via
myWindows machine – do I follow the notes here ? :
 
> 
> https://www.pgadmin.org/download/pgadmin-4-rpm/
> 
> 
> Thanks.
> 
> 
> 
> ________________________________
> The information contained in this e-mail message is intended only for the personal and confidential use of the
recipient(s)named above. This message may be an attorney-client communication and/or work product and as such is
privilegedand confidential. If the reader of this message is not the intended recipient or an agent responsible for
deliveringit to the intended recipient, you are hereby notified that you have received this document in error and that
anyreview, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this
communicationin error, please notify us immediately by e-mail, and delete the original message.
 
> 
> ________________________________
> The information contained in this e-mail message is intended only for the personal and confidential use of the
recipient(s)named above. This message may be an attorney-client communication and/or work product and as such is
privilegedand confidential. If the reader of this message is not the intended recipient or an agent responsible for
deliveringit to the intended recipient, you are hereby notified that you have received this document in error and that
anyreview, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this
communicationin error, please notify us immediately by e-mail, and delete the original message.