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

From: Sargez <zsargez(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Master-Slave error: the database system is starting up
Date: 2018-02-02 07:30:40
Message-ID: 1517556640039-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

Thenk you very much fot your interest! I am very grateful!

There are my results:

postgres=# select * from pg_stat_replication;
pid | usesysid | usename | application_name | client_addr |
client_hostname | client_port |
backend_start | backend_xmin | state | sent_location |
write_location | flush_locatio
n | replay_location | sync_priority | sync_state
------+----------+----------+------------------+-------------+-----------------+-------------+------
-------------------------+--------------+-----------+---------------+----------------+--------------
--+-----------------+---------------+------------
4372 | 10 | postgres | walreceiver | ip-slave |
| 57344 | 2018-
02-01 23:08:49.729755+03 | | streaming | A/E7CE29F0 |
A/E7CE2878 | A/E7CE2878
| A/E7CE2878 | 0 | async
(1 строка)

postgres=# select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | active | active_pid |
xmin | catalog_xmin | re
start_lsn | confirmed_flush_lsn
-----------+--------+-----------+--------+----------+--------+------------+------+--------------+---
----------+---------------------
slot_1 | | physical | | | t | 4372 |
| | A/
E7CE3CD0 |
(1 строка)

I'll wait for your reply, in log file the same the same error when trying to
connect to postgres
"the database system is starting up"

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann 2018-02-02 08:03:34 Re: Master-Slave error: the database system is starting up
Previous Message David G. Johnston 2018-02-02 02:56:45 Create schema with in a specific database from a script file