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.
