[pgpool-general: 7397] Re: non-default tablespaces
srvrmurat at gmail.com
Sat Jan 16 19:20:01 JST 2021
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
> 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
> 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
>> > setup. It runs successfully. In case of failover, standby follows the
>> > primary db and syncronizes. What I see is /var/lib/pgsql/13/data is
>> > 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.
>> > 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
>> > 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>
>> >> > 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
>> >> 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...
More information about the pgpool-general