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

On Fri, Apr 17, 2020 at 9:51 AM Michael Paquier <michael(at)paquier(dot)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
>