The DB server IP address is 192.168.168.2The client PC that tries to connect to DB server is 192.168.168.73 As you can see, the 2 machines are in the same private network and same subnet.I assume that no firewall is needed in this case.Regards.On Tue, Feb 25, 2014 at 11:56 AM, Victor Hugo <vh.clemente@gmail.com> wrote:What is the IP of the database server? Have router between the database server and pgAdmin III ??? Is on the same subnet ?The firewall ports are enabled?Tk´s ;-)2014-02-25 14:20 GMT-03:00 JORGE MALDONADO <jorgemal1960@gmail.com>:I need to connect to a remote PostgreSQL 9.3 database with pgAdmin III within our private network, so I did the following:* Open postgresql.conf file and verify that listen_addresses = '*'* Open pg_hba.conf and add the following line:host all all 192.168.168.0/24 md5Our private network segment is 192.168.168.** I stop PostgreSQL service.* I start PostgeSQL service.I can connect locally but not remotely.I will very much appreciate your feedback.Respectfully,Jorge Maldonado-- AbcsVictor Hugo - DBAMobile: (21) 99529-5585Google Talk: vh.clementeSkype: vh.clemente "Antes de imprimir, pense em sua responsabilidade e compromisso com o MEIO AMBIENTE"
What is the IP of the database server? Have router between the database server and pgAdmin III ??? Is on the same subnet ?The firewall ports are enabled?Tk´s ;-)2014-02-25 14:20 GMT-03:00 JORGE MALDONADO <jorgemal1960@gmail.com>:I need to connect to a remote PostgreSQL 9.3 database with pgAdmin III within our private network, so I did the following:* Open postgresql.conf file and verify that listen_addresses = '*'* Open pg_hba.conf and add the following line:host all all 192.168.168.0/24 md5Our private network segment is 192.168.168.** I stop PostgreSQL service.* I start PostgeSQL service.I can connect locally but not remotely.I will very much appreciate your feedback.Respectfully,Jorge Maldonado-- AbcsVictor Hugo - DBAMobile: (21) 99529-5585Google Talk: vh.clementeSkype: vh.clemente "Antes de imprimir, pense em sua responsabilidade e compromisso com o MEIO AMBIENTE"
I need to connect to a remote PostgreSQL 9.3 database with pgAdmin III within our private network, so I did the following:* Open postgresql.conf file and verify that listen_addresses = '*'* Open pg_hba.conf and add the following line:host all all 192.168.168.0/24 md5Our private network segment is 192.168.168.** I stop PostgreSQL service.* I start PostgeSQL service.I can connect locally but not remotely.I will very much appreciate your feedback.Respectfully,Jorge Maldonado
pgsql-novice by date:
Соглашаюсь с условиями обработки персональных данных