pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql: Connection refused. pqAdmin: the database system is starting up
3+ messages / 2 participants
[nested] [flat]
* psql: Connection refused. pqAdmin: the database system is starting up
@ 2018-02-01 10:14 Sargez <zsargez@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Sargez @ 2018-02-01 10:14 UTC (permalink / raw)
To: pgsql-admin
Hello all,
OS = Windows Server 2012
PostGres = 9.6
I made a replication with the master server. On the slave server service
postgre is running, but in log files slave's server "FATAL: the database
system is starting up" message will continue.
when I try from the command line run the command "psql.exe -U postgres"
writes the following error:
"psql: ... Connection refused (0x0000274D/10061) ..."
My postgresql.conf configuretions is on the slave server:
listen_addresses = 'ip slave adress'
hot_standby = on
wal_receiver_status_interval = 0
hot_standby_feedback = on
My recovery.conf configuretions is on the slave server:
standby_mode = 'on'
primary_conninfo = 'host=ip master server port=5432 user=postgres'
primary_slot_name = 'slot_1'
trigger_file = 'D:\Postgres Data\Start_master'
Could you please to fix this issue? I don't understand what could be the
problem.
I've made shutdown the server, the problem is not resolved.
Thenk you very much!
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql: Connection refused. pqAdmin: the database system is starting up
@ 2018-02-01 18:26 Azimuddin Mohammed <azimeiu@gmail.com>
parent: Sargez <zsargez@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Azimuddin Mohammed @ 2018-02-01 18:26 UTC (permalink / raw)
To: Sargez <zsargez@gmail.com>; +Cc: pgsql-admin
'ip slave adress' change this to *
On Feb 1, 2018 10:11 AM, "Sargez" <zsargez@gmail.com> wrote:
> Hello all,
> OS = Windows Server 2012
> PostGres = 9.6
>
> I made a replication with the master server. On the slave server service
> postgre is running, but in log files slave's server "FATAL: the database
> system is starting up" message will continue.
>
> when I try from the command line run the command "psql.exe -U postgres"
> writes the following error:
>
> "psql: ... Connection refused (0x0000274D/10061) ..."
>
> My postgresql.conf configuretions is on the slave server:
> listen_addresses = 'ip slave adress'
> hot_standby = on
> wal_receiver_status_interval = 0
> hot_standby_feedback = on
>
> My recovery.conf configuretions is on the slave server:
> standby_mode = 'on'
> primary_conninfo = 'host=ip master server port=5432 user=postgres'
> primary_slot_name = 'slot_1'
> trigger_file = 'D:\Postgres Data\Start_master'
>
> Could you please to fix this issue? I don't understand what could be the
> problem.
> I've made shutdown the server, the problem is not resolved.
>
> Thenk you very much!
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.
> html
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql: Connection refused. pqAdmin: the database system is starting up
@ 2018-02-02 07:33 Sargez <zsargez@gmail.com>
parent: Azimuddin Mohammed <azimeiu@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Sargez @ 2018-02-02 07:33 UTC (permalink / raw)
To: pgsql-admin
thenk you for your response
I 'he made this. 'psql: Connection refused' - is disapear, but error " the
database system is starting up" is persists...
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-02-02 07:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-01 10:14 psql: Connection refused. pqAdmin: the database system is starting up Sargez <zsargez@gmail.com>
2018-02-01 18:26 ` Azimuddin Mohammed <azimeiu@gmail.com>
2018-02-02 07:33 ` Sargez <zsargez@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox