Re: postgres connection

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres connection
Date: 2015-08-10 04:49:28
Message-ID: 55C82D58.6080404@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2015-08-10 05:41:48 How to restore
Previous Message Martín Marqués 2015-08-09 21:49:59 Re: official rpm build spec file