Re: connect external app via pgadmin

But pgAdmin runs at the same ports, so You need them to be opened.

You can set in pgconf allowed IP pool.

You can change default port no por postgresql

Maybe You can consider "hardware" solution: on Your gateway make in firewall rule for specific IP address with port mapping/triggering

e.g. If Your pg is on default port 5432 make an rule that from if somebody from external will try to connect via 87654 port will be redirected to 5432

I don't know how Your infrastructure looks like so i can't give you more detailed solution

śr., 12 sie 2020 o 12:41 bw <bwakkie@gmail.com> napisał(a):

Andrzej,

QGIS is just an example as I use it in combination with postgis in order to work in mapping GIS elements.

With odbc I still need to open up the server ports to the outside world which is what I want to avoid.

regards,

Bastiaan

On Wed, 12 Aug 2020 at 11:43, androxkentaki <androxkentaki@gmail.com> wrote:

i don't know what id Qgis and why You want to do it via pgAdmin...

But did You consider using ODBC connection and its driver?

śr., 12 sie 2020 o 08:58 bw <bwakkie@gmail.com> napisał(a):

Hi,

As I do not like to open-up my postgresql port to the outside world and managing users via pgadmin is very user friendly. I was wondering if somehow it would be possible to give external applications like Qgis for instance access to the database via pgadmin?

For example in qgis in order to access the database it needs to connect directly to the postgresql port and I have to create a linux user for them. I do not want that. I rather manage this inside pgadmin. If qgis would somehow be able to connect to the db via a pgadmin api that would be really great.

regards,

Bastiaan

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Z wyrazami szacunku
Andrzej Gerasimuk