Re: how can I use "pg_basebackup" and not include pg_log of master ?

From: lin <jluwln(at)163(dot)com>
To: "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: how can I use "pg_basebackup" and not include pg_log of master ?
Date: 2017-03-21 03:08:48
Message-ID: 44b6fa1c.5e29.15aeed6a2eb.Coremail.jluwln@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can I modify "sendDir" function to skip the log_direction (default is "pg_log") ?

the sendDir function is :
static int64
sendDir(char *path, int basepathlen, bool sizeonly, List *tablespaces)
{
DIR *dir;
struct dirent *de;
charpathbuf[MAXPGPATH];
struct stat statbuf;
int64size = 0;

dir = AllocateDir(path);
while ((de = ReadDir(dir, path)) != NULL)
{
/* Skip special stuff */
if (strcmp(de->d_name, ".") == 0 || strcmp(de->d_name, "..") == 0)
continue;
.......
--if (strcmp(de->d_name, ".") == 0 || strcmp(de->d_name, "..") == 0)
++ if (strcmp(de->d_name, ".") == 0 || strcmp(de->d_name, "..") == 0 || strcmp(de->d_name, "pg_log"))

Is there something wrong ?

Thanks,
wln

At 2017-03-20 20:43:11, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com> wrote:
>On Mon, Mar 20, 2017 at 9:28 PM, lin <jluwln(at)163(dot)com> wrote:
>> all. I use "pg_basebackup" to make slave, but the master has too large
>> logs of pg_log, How Can I use "pg_basebackup" but not include logs of
>> "pg_log" ?
>
>Unfortunately not, there have been several discussions about being
>able to define a blacklist of paths when taking a backup but nothing
>has showed up in the code tree. For log files, there is a trick
>though: you can define log_directory with an absolute path pointing
>out of PGDATA so those logs won't be included in base backups.
>--
>Michael
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-03-21 03:39:27 Re: how can I use "pg_basebackup" and not include pg_log of master ?
Previous Message Klaus P. Pieper 2017-03-20 20:25:34 Why is this functional index not used?