Обсуждение: postgres connection
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..
any help
On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T <rameshparnanditech@gmail.com> 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..
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:
any helpOn Thu, Aug 6, 2015 at 6:51 PM, Ramesh T <rameshparnanditech@gmail.com> 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..
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
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