Re: Master-Slave error: the database system is starting up

Am 01.02.2018 um 15:43 schrieb Сергей Злобин:
> Hello,
>
> I was advised to write a letter to you
>
> Windows Server 2012
> Postgres 9.6
> I made a replication with the master server. On the slave server service
> postgres 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 configuration 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 configuration 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
>
> http://www.postgresql-archive.org/Master-Slave-error-the-database-system-is-starting-up-td6004044.html

please execute "select * from pg_stat_replication;" and "select * from
pg_replication_slots ;" on the master and show us the output.
Please check also the logs on the standby.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com