Master-Slave error: the database system is starting up

From: Сергей Злобин <zsargez(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Master-Slave error: the database system is starting up
Date: 2018-02-01 14:43:48
Message-ID: CAJ1FJWBPEebroqdBRSSB=o7h1g+m5beUWVrDmvTCMi6Jk1joVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-02-01 16:48:42 Re: Master-Slave error: the database system is starting up
Previous Message Robert Zenz 2018-02-01 08:25:27 Re: Information on savepoint requirement within transctions