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