Re: New option for pg_basebackup, to specify a different directory for pg_xlog - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: New option for pg_basebackup, to specify a different directory for pg_xlog
Date
Msg-id 52F583FE.6060306@gmx.net
Whole thread Raw
In response to Re: New option for pg_basebackup, to specify a different directory for pg_xlog  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: New option for pg_basebackup, to specify a different directory for pg_xlog  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers
On 1/29/14, 7:37 PM, Haribabu Kommi wrote:
> 
> On Tue, Jan 28, 2014 at 1:17 PM, Peter Eisentraut wrote:
> 
>     On 11/30/13, 6:59 AM, Haribabu kommi wrote:
>     > To detect provided data and xlog directories are same or not, I
>     reused the
>     > Existing make_absolute_path() code as follows.
> 
>     I note that initdb does not detect whether the data and xlog directories
>     are the same.  I think there is no point in addressing this only in
>     pg_basebackup.  If we want to forbid it, it should be done in initdb
>     foremost.
> 
>  Thanks for pointing it. if the following approach is fine for
> identifying the identical directories
>  then I will do the same for initdb also.

I wouldn't bother.  It's a lot of work for little benefit.  Any mistake
a user would make can easily be fixed.

>     I'm not sure it's worth the trouble, but if I were to do it, I'd just
>     stat() the two directories and compare their inodes.  That seems much
>     easier and more robust than comparing path strings
> 
> stat() is having problems in windows, because of that reason the patch is
> written to identify the directories with string comparison.

If stat() is having problems on Windows, then those problems would need
to be addressed.

I don't think a string comparison is going to be reliable.  It can
easily be tricked by using multiple slashes for example, or various
kinds of links or bind mounts.  You'd need to put in an awful lot of
work, and it still wouldn't work all the time.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: commit fest 2014-01 week 3 report
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Relocation of tablespaces in pg_basebackup