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
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 |