[pgpool-general: 7397] Re: non-default tablespaces

[Murat K]

temp_tablespaces=temp is in the postgresql.conf
there is no entry related with the tablespaces in pgpool.conf.

On Sat, Jan 16, 2021 at 1:16 PM Murat K <srvrmurat at gmail.com> wrote:

> This is the setup Pgpool-II + Watchdog Setup Example
> <https://www.pgpool.net/docs/latest/en/html/example-cluster.html>
>
> When running pcp_recovery_node script, it logs:
> pg_basebackup: error: directory "/u01/pgdata/temp" exists but is not empty
> pg_basebackup: removing data directory "/var/lib/pgsql/13/data"
>
> Moving directory is necessary  for pcp_recovery_node to run.
>
>
> When failover is triggered new primary runs but standby does not follow
> the new primary.
> In pgpool.conf tablespace related configuration is:
> temp_tablespaces = temp
>
> Regards
>
>
>
> On Sat, Jan 16, 2021 at 12:22 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> > Dear Tatsuo,
>> >
>> > I am implementing example setup on pgpool website. Nothing different
>> from
>> > setup. It runs successfully. In case of failover, standby follows the
>> new
>> > primary db and syncronizes. What I see is /var/lib/pgsql/13/data is
>> moved
>> > to .../data.old.
>>
>> Can you tell me the exact url of "example setup on pgpool website"?
>> IMO there is no code doing "mv data to data.old" in the sample scripts
>> provided by the official pgpool sample scripts.
>>
>> > Then I created two non-default tablespaces in /u01/xxx and /u01/yyy.
>> Tried
>> > the failover but it is not working. It looks follow_primary.sh is not
>> > working as before. I could not find any clue. Shall I move non-default
>> > tablespaces to xxx.old, yyy.old at beginning of follow_primary.sh? What
>> is
>> > the proper way of working with non-defult tablespaces?
>>
>> That depends how you use the tablespaces. Can you share pgpool.conf?
>> It should tell how you use the tablespaces.
>>
>> > Thanks,
>> > murat
>> >
>> > On Fri, Jan 15, 2021 at 11:43 AM Tatsuo Ishii <ishii at sraoss.co.jp>
>> wrote:
>> >
>> >> > Dear All,
>> >> >
>> >> > My configuration is pgpool 4.2.1, postgresql-13 and centos7. I have
>> >> > non-default tablespaces. It looks in case of recovery and failover
>> it is
>> >> > not working as I anticipated. As far as I see pgpool moves var
>> directory
>> >> to
>> >> > var.old but for non-default tablespace directories it does not behave
>> >> like
>> >> > that. What is the proper way of working with non-default tablespaces?
>> >>
>> >> Can you elaborate more? How exactly Pgpool-II does not work as you
>> >> expected?  Since for recovery and failover you need to provide scripts
>> >> to perform actual recovery and failover, without sharing those scripts
>> >> I cannot say anything about what's wrong.
>> >>
>> >> Also I don't understand "pgpool moves var directory to var.old"
>> >> because Pgpool-II does not have code that does that.
>> >>
>> >> Best regards,
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>> >>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20210116/0afbcda0/attachment-0001.htm>