postgresql - How to connect Pgadmin3 to a database on Virtualbox machine? -


i have ubuntu server postgresql server on virtualbox machine (which runs on local machine), , pgadmin3 on local machine. how can connect pgadmin3 database on virtualbox? getting

"server doesn't listen" 

postgres running inside virtualbox.

found out. make work, did:

1) edited file /etc/postgresql/9.1/main/postgresql.conf , uncommented , edited 1 line contain:

listen_addresses = '10.10.4.14,localhost' 

where 10.10.4.14 address used access server on virtualbox.

2) edited file /etc/postgresql/9.1/main/pg_hba.conf , added 1 line @ end:

host                             10.10.4.14/24           md5 

note file path in case might different if postgres version not same mine, or linux distribution might place files in other locations.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -