Re: Need help in enabling remote connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

Thanks a lot for all your replies.  The problem is solved now.  This is the correct thing to do:    listen_addresses = '*'
And then restart the service. 

Additional notes:
-- Remember to use single quotes around the * else it will give syntax error.
-- The listen_addresses parameter specifies the client addresses, and not the server.
-- Once this service is started, telneting the server on the given port successfully connects.
-- Dear Ian Lea, i guess 10.0.0.1/24  is the same as 10.0.0.0/24  as the mask '24' means that the first 3 octets (24 bits from the left hand side) must match ie both mean simply 10.0.0.*
-- And i think 'trust' should be fine assuming that this will be used on an isolated network with a few trusted machines or a secure network where a firewall protects a given set of ports.
-- Dear Brian Modra, i guess   listen_addresses = 'localhost,10.0.0.123'   will give error. It should be written as   listen_addresses = 'localhost','10.0.0.123'  that is each IP should be quoted separately.

Thanks again,
Shruthi


On Mon, Nov 2, 2009 at 6:56 PM, Shruthi A <shruthi.iisc@xxxxxxxxx> wrote:
Hi,

I want a postgres client to be able to connect to a postgres sever on a remote machine.  But i'm not able to make it work.  Assume both the machines are on a LAN 10.0.0.* .Following available advice, this is what i did:

-- In pg_hba.conf, i added the line
host all all 10.0.0.1/24 trust

-- In postgresql.conf, i added the line
listen_addresses = 10.0.0.*

-- Restarted the server with the cmd
./pg_ctl -D <data_folder> reload


This doesn't work.  What else should i do to make remote connection work?

I'm lost!  Please help!


Thanks a lot,

Shruthi



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux