postgres connection

any help

On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T <rameshparnanditech@gmail.com>
wrote:

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

in pg_log

I changed in Recovery.conf

restore_command = 'cp /test/pgsql/pg_log_archive/%f %p'

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]

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.

any help to start server..

On Fri, Aug 7, 2015 at 2:26 PM, Ramesh T <rameshparnanditech@gmail.com>
wrote:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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

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