Re: following install of Postgres on Centos 7, how to install PGAdmin
От | Nicolas Mitchell |
---|---|
Тема | Re: following install of Postgres on Centos 7, how to install PGAdmin |
Дата | |
Msg-id | 6277c172-9e61-7d07-34aa-595c2826c52f@cam.ac.uk обсуждение исходный текст |
Ответ на | RE: following install of Postgres on Centos 7, how to install PGAdmin ("James, David (RIS-SUT)" <david.james@lexisnexisrisk.com>) |
Список | pgsql-novice |
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.
В списке pgsql-novice по дате отправления:
Предыдущее
От: "James, David (RIS-SUT)"Дата:
Сообщение: RE: following install of Postgres on Centos 7, how to install PGAdmin
Следующее
От: "James, David (RIS-SUT)"Дата:
Сообщение: RE: following install of Postgres on Centos 7, how to install PGAdmin