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 Windows option 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(at)gmail(dot)com>
> Sent: Tuesday, June 27, 2023 1:24 PM
> To: James, David (RIS-SUT) <david(dot)james(at)lexisnexisrisk(dot)com>
> Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
> Subject: Re: following install of Postgres on Centos 7, how to install PGAdmin
>
> You don't often get email from rajivharlalka009(at)gmail(dot)com<mailto:rajivharlalka009(at)gmail(dot)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 necessary configurational changes in pg_hba.conf and postgresql.conf would be needed as per your settings for PGAdmin to be able 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(dot)james(at)lexisnexisrisk(dot)com<mailto:david(dot)james(at)lexisnexisrisk(dot)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 my Windows 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 privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in 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 privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.