Can't connect to PostgreSQL on VirtualBox guest Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar Manara Come Celebrate our 10 Year Anniversary!VirtualBox Port Fowarding to Connect to PostgreSQL DatabaseConnect to localhost from Guest running on VirtualBoxport forwarding with VirtualBoxHow can I perform a controlled shutdown of a virtualbox guest using VBoxManage?unable to connect to PostgreSQL 8.4 on Ubuntu 10.04 serverVirtualBox Port Fowarding to Connect to PostgreSQL DatabaseSpeed up VirtualBox guestVirtualBox: How to set up networking so both host and guest can access internet and talk to each otherPostgreSQL can't connect from python/psycopgVirtualBox inbound network connections failingCan't connect to postgresql on local machine using IP + pgadmin
How was Lagrange appointed professor of mathematics so early?
Like totally amazing interchangeable sister outfit accessory swapping or whatever
Where to find documentation for `whois` command options?
Will I be more secure with my own router behind my ISP's router?
Why does Java have support for time zone offsets with seconds precision?
using NDEigensystem to solve the Mathieu equation
How do I deal with an erroneously large refund?
Why I cannot instantiate a class whose constructor is private in a friend class?
France's Public Holidays' Puzzle
What is a good proxy for government quality?
Bright yellow or light yellow?
Is Bran literally the world's memory?
Why is arima in R one time step off?
Putting Ant-Man on house arrest
Will I lose my paid in full property
Married in secret, can marital status in passport be changed at a later date?
Getting AggregateResult variables from Execute Anonymous Window
Why doesn't the university give past final exams' answers?
How long can a nation maintain a technological edge over the rest of the world?
What to do with someone that cheated their way though university and a PhD program?
Is it OK if I do not take the receipt in Germany?
Can gravitational waves pass through a black hole?
What is a 'Key' in computer science?
How to translate "red flag" into Spanish?
Can't connect to PostgreSQL on VirtualBox guest
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar Manara
Come Celebrate our 10 Year Anniversary!VirtualBox Port Fowarding to Connect to PostgreSQL DatabaseConnect to localhost from Guest running on VirtualBoxport forwarding with VirtualBoxHow can I perform a controlled shutdown of a virtualbox guest using VBoxManage?unable to connect to PostgreSQL 8.4 on Ubuntu 10.04 serverVirtualBox Port Fowarding to Connect to PostgreSQL DatabaseSpeed up VirtualBox guestVirtualBox: How to set up networking so both host and guest can access internet and talk to each otherPostgreSQL can't connect from python/psycopgVirtualBox inbound network connections failingCan't connect to postgresql on local machine using IP + pgadmin
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
When I try to connect from a PostgreSQL client on the host system to the PostgreSQL server on a VirtualBox guest system, I get a "connection attempt failed" message.
The host system is Windows XP. I'm running VirtualBox 3.1.2. The guest system is Ubuntu 9.10 Karmic Koala with PostgreSQL 8.4.
I've forwarded port 5432 in VirtualBox as described in the manual and this post. When I run vboxmanage getextradata vmname enumerate, I get these entries (among others):
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/GuestPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/HostPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/Protocol, Value: TCP
I configured PostgreSQL security in /etc/postgresql/8.4/main/pg_hba.conf with these entries:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.1.0/24 md5
host all all 10.0.2.2/32 md5
Then I reloaded PostgreSQL with sudo /etc/init.d/postgresql-8.4 reload.
For diagnostic purposes only, I've disabled my Windows firewall and my Ubuntu firewall (sudo ufw disable).
Anybody know what steps I've missed?
ubuntu postgresql virtualbox
edited Apr 17 at 12:19
Peter Vandivier
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
add a comment |
When I try to connect from a PostgreSQL client on the host system to the PostgreSQL server on a VirtualBox guest system, I get a "connection attempt failed" message.
The host system is Windows XP. I'm running VirtualBox 3.1.2. The guest system is Ubuntu 9.10 Karmic Koala with PostgreSQL 8.4.
I've forwarded port 5432 in VirtualBox as described in the manual and this post. When I run vboxmanage getextradata vmname enumerate, I get these entries (among others):
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/GuestPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/HostPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/Protocol, Value: TCP
I configured PostgreSQL security in /etc/postgresql/8.4/main/pg_hba.conf with these entries:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.1.0/24 md5
host all all 10.0.2.2/32 md5
Then I reloaded PostgreSQL with sudo /etc/init.d/postgresql-8.4 reload.
For diagnostic purposes only, I've disabled my Windows firewall and my Ubuntu firewall (sudo ufw disable).
Anybody know what steps I've missed?
ubuntu postgresql virtualbox
edited Apr 17 at 12:19
Peter Vandivier
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
add a comment |
When I try to connect from a PostgreSQL client on the host system to the PostgreSQL server on a VirtualBox guest system, I get a "connection attempt failed" message.
The host system is Windows XP. I'm running VirtualBox 3.1.2. The guest system is Ubuntu 9.10 Karmic Koala with PostgreSQL 8.4.
I've forwarded port 5432 in VirtualBox as described in the manual and this post. When I run vboxmanage getextradata vmname enumerate, I get these entries (among others):
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/GuestPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/HostPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/Protocol, Value: TCP
I configured PostgreSQL security in /etc/postgresql/8.4/main/pg_hba.conf with these entries:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.1.0/24 md5
host all all 10.0.2.2/32 md5
Then I reloaded PostgreSQL with sudo /etc/init.d/postgresql-8.4 reload.
For diagnostic purposes only, I've disabled my Windows firewall and my Ubuntu firewall (sudo ufw disable).
Anybody know what steps I've missed?
ubuntu postgresql virtualbox
edited Apr 17 at 12:19
Peter Vandivier
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
When I try to connect from a PostgreSQL client on the host system to the PostgreSQL server on a VirtualBox guest system, I get a "connection attempt failed" message.
The host system is Windows XP. I'm running VirtualBox 3.1.2. The guest system is Ubuntu 9.10 Karmic Koala with PostgreSQL 8.4.
I've forwarded port 5432 in VirtualBox as described in the manual and this post. When I run vboxmanage getextradata vmname enumerate, I get these entries (among others):
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/GuestPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/HostPort, Value: 5432
Key: VBoxInternal/Devices/e1000/0/LUN#0/Config/pgsql/Protocol, Value: TCP
I configured PostgreSQL security in /etc/postgresql/8.4/main/pg_hba.conf with these entries:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.1.0/24 md5
host all all 10.0.2.2/32 md5
Then I reloaded PostgreSQL with sudo /etc/init.d/postgresql-8.4 reload.
For diagnostic purposes only, I've disabled my Windows firewall and my Ubuntu firewall (sudo ufw disable).
Anybody know what steps I've missed?
ubuntu postgresql virtualbox
ubuntu postgresql virtualbox
edited Apr 17 at 12:19
Peter Vandivier
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
edited Apr 17 at 12:19
Peter Vandivier
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
edited Apr 17 at 12:19
Peter Vandivier
15419
edited Apr 17 at 12:19
Peter Vandivier
15419
edited Apr 17 at 12:19
Peter Vandivier
15419
15419
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
asked Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
4002520
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
OK, I found the missed step thanks to this post.
I had forgotten to set the listen_addresses setting in postgresql.conf. I'm using this value, but it could be more restricted:
listen_addresses = '*'
Just to clarify, when you connect to PostgreSQL from the host, use localhost as the server and 5432 as the port. VirtualBox will forward that port to the guest.
I also realized that some settings require you to restart PostgreSQL instead of just reloading it. The command is:
sudo /etc/init.d/postgresql-8.4 restart
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
1
After going through multiple tutorials on the web for hints, AND runningsystemctl reload postgresql,systemctl restart postgresqlis what finally did it for me.
– Amani Kilumanga
Jun 17 '16 at 6:32
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f106168%2fcant-connect-to-postgresql-on-virtualbox-guest%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
OK, I found the missed step thanks to this post.
I had forgotten to set the listen_addresses setting in postgresql.conf. I'm using this value, but it could be more restricted:
listen_addresses = '*'
Just to clarify, when you connect to PostgreSQL from the host, use localhost as the server and 5432 as the port. VirtualBox will forward that port to the guest.
I also realized that some settings require you to restart PostgreSQL instead of just reloading it. The command is:
sudo /etc/init.d/postgresql-8.4 restart
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
1
After going through multiple tutorials on the web for hints, AND runningsystemctl reload postgresql,systemctl restart postgresqlis what finally did it for me.
– Amani Kilumanga
Jun 17 '16 at 6:32
add a comment |
OK, I found the missed step thanks to this post.
I had forgotten to set the listen_addresses setting in postgresql.conf. I'm using this value, but it could be more restricted:
listen_addresses = '*'
Just to clarify, when you connect to PostgreSQL from the host, use localhost as the server and 5432 as the port. VirtualBox will forward that port to the guest.
I also realized that some settings require you to restart PostgreSQL instead of just reloading it. The command is:
sudo /etc/init.d/postgresql-8.4 restart
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
1
After going through multiple tutorials on the web for hints, AND runningsystemctl reload postgresql,systemctl restart postgresqlis what finally did it for me.
– Amani Kilumanga
Jun 17 '16 at 6:32
add a comment |
OK, I found the missed step thanks to this post.
I had forgotten to set the listen_addresses setting in postgresql.conf. I'm using this value, but it could be more restricted:
listen_addresses = '*'
Just to clarify, when you connect to PostgreSQL from the host, use localhost as the server and 5432 as the port. VirtualBox will forward that port to the guest.
I also realized that some settings require you to restart PostgreSQL instead of just reloading it. The command is:
sudo /etc/init.d/postgresql-8.4 restart
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
OK, I found the missed step thanks to this post.
I had forgotten to set the listen_addresses setting in postgresql.conf. I'm using this value, but it could be more restricted:
listen_addresses = '*'
Just to clarify, when you connect to PostgreSQL from the host, use localhost as the server and 5432 as the port. VirtualBox will forward that port to the guest.
I also realized that some settings require you to restart PostgreSQL instead of just reloading it. The command is:
sudo /etc/init.d/postgresql-8.4 restart
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
edited Feb 11 '10 at 19:39
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
answered Jan 25 '10 at 19:11
Don KirkbyDon Kirkby
4002520
4002520
1
After going through multiple tutorials on the web for hints, AND runningsystemctl reload postgresql,systemctl restart postgresqlis what finally did it for me.
– Amani Kilumanga
Jun 17 '16 at 6:32
add a comment |
1
After going through multiple tutorials on the web for hints, AND runningsystemctl reload postgresql,systemctl restart postgresqlis what finally did it for me.
– Amani Kilumanga
Jun 17 '16 at 6:32
1
1
After going through multiple tutorials on the web for hints, AND running
systemctl reload postgresql, systemctl restart postgresql is what finally did it for me.– Amani Kilumanga
Jun 17 '16 at 6:32
After going through multiple tutorials on the web for hints, AND running
systemctl reload postgresql, systemctl restart postgresql is what finally did it for me.– Amani Kilumanga
Jun 17 '16 at 6:32
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f106168%2fcant-connect-to-postgresql-on-virtualbox-guest%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
