Обсуждение: pgsql: Skip temp tables from basebackup.

Поиск
Список
Период
Сортировка

pgsql: Skip temp tables from basebackup.

От
Teodor Sigaev
Дата:
Skip temp tables from basebackup.

Do not store temp tables in basebackup, they will not be visible anyway, so,
there are not reasons to store them.

Author: David Steel
Reviewed by: me
Discussion: https://www.postgresql.org/message-id/flat/5ea4d26a-a453-c1b7-eff9-5a3ef8f8aceb@pgmasters.net

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/920a5e500a119b03356fb1fb64a677eb1aa5fc6f

Modified Files
--------------
doc/src/sgml/protocol.sgml                   |  2 +-
src/backend/replication/basebackup.c         | 10 ++++++
src/backend/storage/file/fd.c                |  3 +-
src/bin/pg_basebackup/t/010_pg_basebackup.pl | 49 +++++++++++++++++++++++++++-
src/include/storage/fd.h                     |  1 +
5 files changed, 61 insertions(+), 4 deletions(-)


Re: pgsql: Skip temp tables from basebackup.

От
Teodor Sigaev
Дата:
Hm, seems, Windows doesn't like this patch
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27

David, could you have a look?

Teodor Sigaev wrote:
> Skip temp tables from basebackup.
> 
> Do not store temp tables in basebackup, they will not be visible anyway, so,
> there are not reasons to store them.
> 
> Author: David Steel
> Reviewed by: me
> Discussion: https://www.postgresql.org/message-id/flat/5ea4d26a-a453-c1b7-eff9-5a3ef8f8aceb@pgmasters.net
> 
> Branch
> ------
> master
> 
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/920a5e500a119b03356fb1fb64a677eb1aa5fc6f
> 
> Modified Files
> --------------
> doc/src/sgml/protocol.sgml                   |  2 +-
> src/backend/replication/basebackup.c         | 10 ++++++
> src/backend/storage/file/fd.c                |  3 +-
> src/bin/pg_basebackup/t/010_pg_basebackup.pl | 49 +++++++++++++++++++++++++++-
> src/include/storage/fd.h                     |  1 +
> 5 files changed, 61 insertions(+), 4 deletions(-)
> 

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


Re: pgsql: Skip temp tables from basebackup.

От
Teodor Sigaev
Дата:

Re: pgsql: Skip temp tables from basebackup.

От
David Steele
Дата:
On 3/27/18 10:17 AM, Teodor Sigaev wrote:
> Hm, seems, Windows doesn't like this patch
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27

Will do. Probably a path problem, which hopefully I can fix with the new
function Andrew wrote.

-- 
-David
david@pgmasters.net


Re: pgsql: Skip temp tables from basebackup.

От
Tom Lane
Дата:
David Steele <david@pgmasters.net> writes:
> Will do. Probably a path problem, which hopefully I can fix with the new
> function Andrew wrote.

Looks to me more like a failure-to-count-the-number-of-tests
problem.  There's no test reported as "not ok".

            regards, tom lane


Re: pgsql: Skip temp tables from basebackup.

От
Andrew Gierth
Дата:
>>>>> "Teodor" == Teodor Sigaev <teodor@sigaev.ru> writes:

 Teodor> Hm, seems, Windows doesn't like this patch

You added two tests to the SKIP: block without updating the number of
tests that would be skipped, so the final count of tests comes out
wrong.

    skip "symlinks not supported on Windows", 15 if ($windows_os);

above 15 should presumably be 17 (did not test this myself since I don't
have windows)

-- 
Andrew (irc:RhodiumToad)


Re: pgsql: Skip temp tables from basebackup.

От
David Steele
Дата:
On 3/27/18 10:24 AM, Teodor Sigaev wrote:
>> Hm, seems, Windows doesn't like this patch
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27
>>
> 
> sorry for wrong URL
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27%2013%3A30%3A24

Looks like the skip total for Windows is incorrect.  The attached should
fix it.

Thanks,
-- 
-David
david@pgmasters.net

Вложения

Re: pgsql: Skip temp tables from basebackup.

От
Teodor Sigaev
Дата:
Thanks for everyone, pushed. Let us follow the pgbuildfarm

David Steele wrote:
> On 3/27/18 10:24 AM, Teodor Sigaev wrote:
>>> Hm, seems, Windows doesn't like this patch
>>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27
>>>
>>
>> sorry for wrong URL
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=bowerbird&dt=2018-03-27%2013%3A30%3A24
> 
> Looks like the skip total for Windows is incorrect.  The attached should
> fix it.
> 
> Thanks,
> 

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/