brainfry35
12-19-2010, 12:28 PM
I'm looking to connect to my postgres db from my local network and when i add lines to the pg_hba.conf file it doesnt save it. I add the line press save and reopen the file to verify and its not there.
I'm following these instructions:
Change the pg_hba.conf file likewise. Choose File/Open pg_hba.conf (file can be found in PostgreSQL/8.3/data directory).
Add a line like in the picture by double clicking in the square in the new line
pgadmin-03.jpg
Add a line like host/all/postgres/0.0.0.0/md5 if you want to access your database from the internet (See also additional steps for Internet access)
Or add a line like host/all/postgres/192.168.2.3 (= Ip-adres laptop)/md5 if you only want to access your database from inside your local network with your laptop/ second computer.
Or add a line like host/all/postgres/192.168.2.0 (= address of your local network)/md5 if your laptop is getting an IP Adres from a DHCP server within your network.
Or add a line like host/all/192.168.2.3/trust if you do not want have anything to do with passwords.
I'm following these instructions:
Change the pg_hba.conf file likewise. Choose File/Open pg_hba.conf (file can be found in PostgreSQL/8.3/data directory).
Add a line like in the picture by double clicking in the square in the new line
pgadmin-03.jpg
Add a line like host/all/postgres/0.0.0.0/md5 if you want to access your database from the internet (See also additional steps for Internet access)
Or add a line like host/all/postgres/192.168.2.3 (= Ip-adres laptop)/md5 if you only want to access your database from inside your local network with your laptop/ second computer.
Or add a line like host/all/postgres/192.168.2.0 (= address of your local network)/md5 if your laptop is getting an IP Adres from a DHCP server within your network.
Or add a line like host/all/192.168.2.3/trust if you do not want have anything to do with passwords.