Обсуждение: 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

El 07/08/15 a las 07:31, Ramesh T escribió:
> FATAL:  syntax error in file "recovery.conf" line 2, near token "config"
> < 2015-08-07 05:21:13.086 EDT >LOG:  startup process (PID 6129) exited with
> exit code 1
> < 2015-08-07 05:21:13.086 EDT >LOG:  aborting startup due to startup
> process failure

What did you have on line 2 of recovery.conf (I see that this might just
be a standby).

> in pg_log
>
> I changed  in Recovery.conf
>
> restore_command = 'cp /test/pgsql/pg_log_archive/%f %p'

Is this line 2? What was it set to before?

> bash-4.1$ /etc/init.d/postgresql-9.3 start
>
> Starting postgresql-9.3 service:                           [FAILED]
>
> bash-4.1$pg_ctl start
> Starting postgresql-9.3 service:                           [FAILED]
> bash-4.1$service postgres-9.3 start
> Starting postgresql-9.3 service:                           [FAILED]

Well, evidently your postgres server is not starting, hence those
[FAILED] signs.

> when i try to conect server from pgadmin3
> return error like
>        could not connect to the server: connection refused on host
> 2.3.421.1 and accepting tcp/ip connection on port 5432.

Is 2.3.421.1 the server from above in this mail? It's obviously not running.

> any help to start server..

Logs from just after you tried to start the server. The mysterious line
2 of recovery.conf. Network parameters from postgresql.conf.

Those 3 things could help.

Regards,


--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services