Re: Pg_auto_failover - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: Pg_auto_failover
Date
Msg-id ca3988a9-3f6c-e671-a4e1-9733cc2e036f@illuminatedcomputing.com
Whole thread Raw
In response to Re: Pg_auto_failover  (Sonam Sharma <sonams1209@gmail.com>)
Responses Re: Pg_auto_failover
List 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@illuminatedcomputing.com



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: managing primary key conflicts while restoring data to table withexisting data
Next
From: Adrian Klaver
Date:
Subject: Re: Upgrading old server