Re: ERROR: could not open file "pg_tblspc/ issue with replication setup.

Поиск
Список
Период
Сортировка
От Rajkumar Raghuwanshi
Тема Re: ERROR: could not open file "pg_tblspc/ issue with replication setup.
Дата
Msg-id CAKcux6kEwNPv2WnoLhBpa_1UsR6gZqzQTqaacUN432YBvSK3+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: could not open file "pg_tblspc/ issue with replicationsetup.  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения


On Fri, Apr 17, 2020 at 9:51 AM Michael Paquier <michael@paquier.xyz> wrote:
On Thu, Apr 16, 2020 at 01:56:47PM +0530, Rajkumar Raghuwanshi wrote:
> While testing for a feature I got this tablespace related error while
> running script.

Primary and standby are running on the same host, so they would
interact with each other as the tablespace path used by both clusters
would be the same (primary uses the path defined by the DDL, which is
registered in the WAL record the standby replays).  What you are
looking for here is to create the tablespace before taking the base
backup, and then use the option --tablespace-mapping with
pg_basebackup to avoid the issue.
Thanks for the help.

 
--
Michael

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: xid wraparound danger due to INDEX_CLEANUP false
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: It is not documented that pg_promote can exit standby mode