Re: Pg_auto_failover

From: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Pg_auto_failover
Date: 2019-09-25 18:09:53
Message-ID: ca3988a9-3f6c-e671-a4e1-9733cc2e036f@illuminatedcomputing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/25/19 8:55 AM, Sonam Sharma wrote:
> My user has permission to touch inside the Fs.
> I am not getting why it is checking for /backup.
>
> Any suggestions on this , what else I can check

In addition to the code already linked to, I would look at
https://github.com/citusdata/pg_auto_failover/blob/1290edd0bab54c627f577cf4462bd16a56b20a1a/src/bin/pg_autoctl/pgctl.c#L429-L437

You see that pg_auto_failover is trying to `mkdir -p $pgdata/../backup`
(where pgdata is a C variable, not a shell/environment variable). You
might want to read through the rest of that code to see where pgdata is
coming from, and see if it's being set correctly. Do you really want
/backup at the root level?

Clearly whatever user is running pg_basebackup doesn't have permission
to make that directory. But maybe that's okay and the directory should
be somewhere else.

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-09-25 18:21:16 Re: Upgrading old server
Previous Message Michael Lewis 2019-09-25 17:44:36 Re: managing primary key conflicts while restoring data to table with existing data