Re: postgres connection

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