Re: connect external app via pgadmin - Mailing list pgadmin-support

From bw
Subject Re: connect external app via pgadmin
Date
Msg-id CAKqYf_Lq7D2RJuEq4H+N12mmkr7uf8+Sm=7HETckqzq7f3ih5A@mail.gmail.com
Whole thread Raw
In response to Re: connect external app via pgadmin  (androxkentaki <androxkentaki@gmail.com>)
Responses Re: connect external app via pgadmin  (androxkentaki <androxkentaki@gmail.com>)
List pgadmin-support
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

pgadmin-support by date:

Previous
From: Alexander Smyslov
Date:
Subject: Schema diff tool
Next
From: androxkentaki
Date:
Subject: Re: connect external app via pgadmin