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
Post a Comment