From: | Azimuddin Mohammed <azimeiu(at)gmail(dot)com> |
---|---|
To: | Sargez <zsargez(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: psql: Connection refused. pqAdmin: the database system is starting up |
Date: | 2018-02-01 18:26:43 |
Message-ID: | CAKUuFd6ibrz4qgh4J88o9oYL8ZAuX-adjyG-Jjj7D++XiwtAKg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
'ip slave adress' change this to *
On Feb 1, 2018 10:11 AM, "Sargez" <zsargez(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sargez | 2018-02-02 07:33:47 | Re: psql: Connection refused. pqAdmin: the database system is starting up |
Previous Message | pavan95 | 2018-02-01 11:14:05 | Re: Heap Only Update |