From: | Martín Marqués <martin(at)2ndquadrant(dot)com> |
---|---|
To: | Ramesh T <rameshparnanditech(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres connection |
Date: | 2015-08-10 11:42:51 |
Message-ID: | 55C88E3B.2030302@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Chan | 2015-08-10 13:23:54 | Postgresql 9.4.4: ERROR: bigint out of range |
Previous Message | Leo Baltus | 2015-08-10 08:51:01 | Re: pg_start_backup: file has vanished from pg_subtrans/ |