Re: postgres connection

On 8/6/2015 6:21 AM, Ramesh T wrote:
> Hi all,
>          I got a problem when i start postgres server.
> like'
>        could not connect to the server: connection refused on host 
> 2.3.421.1 and accepting tcp/ip connection on port 5432.
>
> any help appreciated..

you could start with telling us what operating 
system/distribution/version you're running, and how you installed postgresql

most system default configurations, the server only listens to 
localhost, not other IP addresses, you need to change the 
listen_addresses parameter in postgresql.conf and adjust your 
authentication methods appropriately in pg_hba.conf... but before 
messing with that, verify the server is actually running, or not.

Do note, /etc/init.d scripts are meant to be run by the root user only, 
not by a regular user account.





-- 
john r pierce, recycling bits in santa cruz