Search Postgresql Archives

Re: postgres connection

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux