Re: [pgadmin-support] PG Admin 4 domain

[Christian Castelli]

Thank you Dave and Murtuza.

2017-02-16 13:06 GMT+01:00 Dave Page :

>
>
> On Thu, Feb 16, 2017 at 12:02 PM, Murtuza Zabuawala  enterprisedb.com> wrote:
>
>> By default pgAdmin4 runs on loopback adapter, to make it run on ethernet
>> (eth0) you need to change some of configuration options.
>>
>> You need to add below config options,
>>
>> DEFAULT_SERVER = '0.0.0.0'
>>
>> in config_local.py (in "pgAdmin4" folder).
>>
>> Now restart pgAdmin4, Now try accessing pgAdmin4 using IP address you
>> mentioned(eg, http://172.xxx.xxx.xx:8081)
>>
>
> Yeah, but *don't* do that without switching SERVER_MODE = true to ensure
> that authentication is enabled, otherwise you're opening pgAdmin (and any
> saved passwords etc) to anyone on your network.
>
> For production use, you should use Apache or similar per the instructions
> I just posted.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
*Christian Castelli*
Senior Developer


*Habble Srl*
Via della Canapiglia, 5
56019 Vecchiano (Pi) - Italy
Lat: 43° 46' 53.03" N
Long: 10° 20' 10.36" E
Help Desk: +39 050 6397490
E-Fax:+39 050 6390236
Web: http://www.habble.it
Skype id: christrack
LinkedIn: christian.castelli 


Rispetta l'ambiente, stampa questa mail solo se veramente necessario.

Re: [pgadmin-support] PG Admin 4 domain

[Dave Page]

On Thu, Feb 16, 2017 at 12:02 PM, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> By default pgAdmin4 runs on loopback adapter, to make it run on ethernet
> (eth0) you need to change some of configuration options.
>
> You need to add below config options,
>
> DEFAULT_SERVER = '0.0.0.0'
>
> in config_local.py (in "pgAdmin4" folder).
>
> Now restart pgAdmin4, Now try accessing pgAdmin4 using IP address you
> mentioned(eg, http://172.xxx.xxx.xx:8081)
>

Yeah, but *don't* do that without switching SERVER_MODE = true to ensure
that authentication is enabled, otherwise you're opening pgAdmin (and any
saved passwords etc) to anyone on your network.

For production use, you should use Apache or similar per the instructions I
just posted.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgadmin-support] PG Admin 4 domain

[Dave Page]

On Thu, Feb 16, 2017 at 11:53 AM, Christian Castelli <
christian.caste...@habble.it> wrote:

> Thanks for rapid reply,
> I'm running it in desktop mode, following a post on Stack Overflow
> .
> It's all fine if I browse it on localhost:5050 but if I try with my private
> IP it cannot connect.
> I attach my version of PG Admin 4 running on Ubuntu 16.04 Linux daneel
> 4.4.0-62-generic.
>

Oh, Ok. There are instructions at
https://www.pgadmin.org/docs4/1.x/server_deployment.html for running a
server deployment.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgadmin-support] PG Admin 4 domain

[Murtuza Zabuawala]

By default pgAdmin4 runs on loopback adapter, to make it run on ethernet
(eth0) you need to change some of configuration options.

You need to add below config options,

DEFAULT_SERVER = '0.0.0.0'

in config_local.py (in "pgAdmin4" folder).

Now restart pgAdmin4, Now try accessing pgAdmin4 using IP address you
mentioned(eg, http://172.xxx.xxx.xx:8081)
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, Feb 16, 2017 at 5:23 PM, Christian Castelli <
christian.caste...@habble.it> wrote:

> Thanks for rapid reply,
> I'm running it in desktop mode, following a post on Stack Overflow
> .
> It's all fine if I browse it on localhost:5050 but if I try with my private
> IP it cannot connect.
> I attach my version of PG Admin 4 running on Ubuntu 16.04 Linux daneel
> 4.4.0-62-generic.
>
>
>
> 2017-02-16 12:44 GMT+01:00 Dave Page :
>
>> Hi
>>
>> On Thu, Feb 16, 2017 at 11:35 AM, Christian Castelli <
>> christian.caste...@habble.it> wrote:
>>
>>> Hello PG Admin 4 developers,
>>> first of all congrats for your complete rewrite of this program, this
>>> web version is impressive.
>>>
>>
>> Thanks!
>>
>>
>>> I was just wondering if it's possible to run an instance of pgadmin4 in
>>> order to be visible to others machine in a private LAN (for example
>>> 172.19.xxx.xxx:5050). Does any property exists for doing this?
>>>
>>
>> You can run it on any webserver, it doesn't matter whether it's private
>> or public. I've got a feeling that's not quite what you're asking though?
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> *Christian Castelli*
> Senior Developer
>
>
> *Habble Srl*
> Via della Canapiglia, 5
> 56019 Vecchiano (Pi) - Italy
> Lat: 43° 46' 53.03" N
> Long: 10° 20' 10.36" E
> Help Desk: +39 050 6397490
> E-Fax:+39 050 6390236
> Web: http://www.habble.it
> Skype id: christrack
> LinkedIn: christian.castelli
> 
>
>
> Rispetta l'ambiente, stampa questa mail solo se veramente necessario.
>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>

Re: [pgadmin-support] PG Admin 4 domain

[Christian Castelli]

Thanks for rapid reply,
I'm running it in desktop mode, following a post on Stack Overflow
.
It's all fine if I browse it on localhost:5050 but if I try with my private
IP it cannot connect.
I attach my version of PG Admin 4 running on Ubuntu 16.04 Linux daneel
4.4.0-62-generic.



2017-02-16 12:44 GMT+01:00 Dave Page :

> Hi
>
> On Thu, Feb 16, 2017 at 11:35 AM, Christian Castelli <
> christian.caste...@habble.it> wrote:
>
>> Hello PG Admin 4 developers,
>> first of all congrats for your complete rewrite of this program, this web
>> version is impressive.
>>
>
> Thanks!
>
>
>> I was just wondering if it's possible to run an instance of pgadmin4 in
>> order to be visible to others machine in a private LAN (for example
>> 172.19.xxx.xxx:5050). Does any property exists for doing this?
>>
>
> You can run it on any webserver, it doesn't matter whether it's private or
> public. I've got a feeling that's not quite what you're asking though?
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
*Christian Castelli*
Senior Developer


*Habble Srl*
Via della Canapiglia, 5
56019 Vecchiano (Pi) - Italy
Lat: 43° 46' 53.03" N
Long: 10° 20' 10.36" E
Help Desk: +39 050 6397490
E-Fax:+39 050 6390236
Web: http://www.habble.it
Skype id: christrack
LinkedIn: christian.castelli 


Rispetta l'ambiente, stampa questa mail solo se veramente necessario.

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] PG Admin 4 domain

[Dave Page]

Hi

On Thu, Feb 16, 2017 at 11:35 AM, Christian Castelli <
christian.caste...@habble.it> wrote:

> Hello PG Admin 4 developers,
> first of all congrats for your complete rewrite of this program, this web
> version is impressive.
>

Thanks!


> I was just wondering if it's possible to run an instance of pgadmin4 in
> order to be visible to others machine in a private LAN (for example
> 172.19.xxx.xxx:5050). Does any property exists for doing this?
>

You can run it on any webserver, it doesn't matter whether it's private or
public. I've got a feeling that's not quite what you're asking though?

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company