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

Поиск
Список
Период
Сортировка
От Sargez
Тема Re: Master-Slave error: the database system is starting up
Дата
Msg-id 1517556640039-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Master-Slave error: the database system is starting up  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Create schema with in a specific database from a script file
Следующее
От: Daniel Westermann
Дата:
Сообщение: Re: Master-Slave error: the database system is starting up