From: | vignesh C <vignesh21(at)gmail(dot)com> |
---|---|
To: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_basebackup failure after setting default_table_access_method option |
Date: | 2019-06-06 08:11:13 |
Message-ID: | CALDaNm1izx5yqwVnfLFs39JOUFCAfnKc62QdVLVe2BT2pK_-tg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thanks Hari for helping in verifying.
Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com
On Thu, Jun 6, 2019 at 6:50 AM Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
wrote:
>
> On Thu, Jun 6, 2019 at 1:46 AM vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
>>
>> Hi,
>>
>> *I noticed pg_basebackup failure when default_table_access_method option
>> is set.*
>>
>> *Test steps:*
>>
>> Step 1: Init database
>> ./initdb -D data
>>
>> Step 2: Start Server
>> ./postgres -D data &
>>
>> Step 3: Set Guc option
>> export PGOPTIONS='-c default_table_access_method=zheap'
>>
>> Step 4: Peform backup
>> /pg_basebackup -D backup -p 5432 --no-sync
>> 2019-06-05 20:35:04.088 IST [11601] FATAL: cannot read pg_class without
>> having selected a database
>> pg_basebackup: error: could not connect to server: FATAL: cannot read
>> pg_class without having selected a database
>>
>> *Reason why it is failing:*
>> pg_basebackup does not use any database to connect to server as it backs
>> up the whole data instance.
>> As the option default_table_access_method is set.
>> It tries to validate this option, but while validating the option in
>> ScanPgRelation function:
>> if (!OidIsValid(MyDatabaseId))
>> elog(FATAL, "cannot read pg_class without having selected a database");
>>
>> Here as pg_basebackup uses no database the command fails.
>>
>
> Thanks for the details steps to reproduce the bug, I am also able to
> reproduce the problem.
>
>
>
>> Fix:
>> The patch has the fix for the above issue:
>>
>> Let me know your opinion on this.
>>
>
> Thanks for the patch and it fixes the problem.
>
> Regards,
> Haribabu Kommi
> Fujitsu Australia
>
--
Regards,
vignesh
Have a nice day
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2019-06-06 08:16:30 | Small review comment on pg_checksums |
Previous Message | Dent John | 2019-06-06 08:07:06 | Use of reloptions by EXTENSIONs |