Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit29f0052

Browse files
Skip .DS_Store files in server side utils
The macOS Finder application creates .DS_Store files in directorieswhen opened, which creates problems for serverside utilities whichexpect all files to be PostgreSQL specific files. Skip these fileswhen encountered in pg_checksums, pg_rewind and pg_basebackup.This was extracted from a larger patchset for skipping hidden filesand system files, where the concencus was to just skip these. Sincethis is equally likely to happen in every version, backpatch to allsupported versions.Reported-by: Mark Guertin <markguertin@gmail.com>Reviewed-by: Michael Paquier <michael@paquier.xyz>Reviewed-by: Tobias Bussmann <t.bussmann@gmx.net>Discussion:https://postgr.es/m/E258CE50-AB0E-455D-8AAD-BB4FE8F882FB@gmail.comBackpatch-through: v12
1 parent26c89d1 commit29f0052

File tree

9 files changed

+47
-4
lines changed

9 files changed

+47
-4
lines changed

‎doc/src/sgml/protocol.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3062,7 +3062,7 @@ psql "dbname=postgres replication=database" -c "IDENTIFY_SYSTEM;"
30623062
<para>
30633063
Files other than regular files and directories, such as symbolic
30643064
links (other than for the directories listed above) and special
3065-
device files, are skipped. (Symbolic links
3065+
deviceand operating systemfiles, are skipped. (Symbolic links
30663066
in <filename>pg_tblspc</filename> are maintained.)
30673067
</para>
30683068
</listitem>

‎doc/src/sgml/ref/pg_basebackup.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -905,7 +905,8 @@ PostgreSQL documentation
905905
The backup will include all files in the data directory and tablespaces,
906906
including the configuration files and any additional files placed in the
907907
directory by third parties, except certain temporary files managed by
908-
PostgreSQL. But only regular files and directories are copied, except that
908+
PostgreSQL and operating system files. But only regular files and
909+
directories are copied, except that
909910
symbolic links used for tablespaces are preserved. Symbolic links pointing
910911
to certain directories known to PostgreSQL are copied as empty directories.
911912
Other symbolic links and special device files are skipped.

‎doc/src/sgml/ref/pg_rewind.sgml

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -389,8 +389,9 @@ GRANT EXECUTE ON function pg_catalog.pg_read_binary_file(text, bigint, bigint, b
389389
<filename>backup_label</filename>,
390390
<filename>tablespace_map</filename>,
391391
<filename>pg_internal.init</filename>,
392-
<filename>postmaster.opts</filename>, and
393-
<filename>postmaster.pid</filename>, as well as any file or directory
392+
<filename>postmaster.opts</filename>,
393+
<filename>postmaster.pid</filename> and
394+
<filename>.DS_Store</filename> as well as any file or directory
394395
beginning with <filename>pgsql_tmp</filename>, are omitted.
395396
</para>
396397
</step>

‎src/backend/backup/basebackup.c

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1185,6 +1185,10 @@ sendDir(bbsink *sink, const char *path, int basepathlen, bool sizeonly,
11851185
strlen(PG_TEMP_FILE_PREFIX))==0)
11861186
continue;
11871187

1188+
/* Skip macOS system files */
1189+
if (strcmp(de->d_name,".DS_Store")==0)
1190+
continue;
1191+
11881192
/*
11891193
* Check if the postmaster has signaled us to exit, and abort with an
11901194
* error in that case. The error handler further up will call

‎src/bin/pg_basebackup/t/010_pg_basebackup.pl

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,7 @@
33

44
use strict;
55
use warnings;
6+
use Config;
67
use File::Basenameqw(basename dirname);
78
use File::Pathqw(rmtree);
89
use PostgreSQL::Test::Cluster;
@@ -173,6 +174,16 @@
173174
close$file;
174175
}
175176

177+
# Test that macOS system files are skipped. Only test on non-macOS systems
178+
# however since creating incorrect .DS_Store files on a macOS system may have
179+
# unintended side effects.
180+
if ($Config{osname}ne'darwin')
181+
{
182+
openmy$file,'>>',"$pgdata/.DS_Store";
183+
print$file"DONOTCOPY";
184+
close$file;
185+
}
186+
176187
# Connect to a database to create global/pg_internal.init. If this is removed
177188
# the test to ensure global/pg_internal.init is not copied will return a false
178189
# positive.
@@ -242,6 +253,12 @@
242253
ok(!-f"$tempdir/backup/$filename","$filename not copied");
243254
}
244255

256+
# We only test .DS_Store files being skipped on non-macOS systems
257+
if ($Config{osname}ne'darwin')
258+
{
259+
ok(!-f"$tempdir/backup/.DS_Store",".DS_Store not copied");
260+
}
261+
245262
# Unlogged relation forks other than init should not be copied
246263
ok(-f"$tempdir/backup/${baseUnloggedPath}_init",
247264
'unlogged init fork in backup');

‎src/bin/pg_checksums/pg_checksums.c

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -337,6 +337,10 @@ scan_directory(const char *basedir, const char *subdir, bool sizeonly)
337337
strlen(PG_TEMP_FILES_DIR))==0)
338338
continue;
339339

340+
/* Skip macOS system files */
341+
if (strcmp(de->d_name,".DS_Store")==0)
342+
continue;
343+
340344
snprintf(fn,sizeof(fn),"%s/%s",path,de->d_name);
341345
if (lstat(fn,&st)<0)
342346
pg_fatal("could not stat file \"%s\": %m",fn);

‎src/bin/pg_checksums/t/002_actions.pl

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6,6 +6,7 @@
66

77
use strict;
88
use warnings;
9+
use Config;
910
use PostgreSQL::Test::Cluster;
1011
use PostgreSQL::Test::Utils;
1112

@@ -114,6 +115,12 @@ sub check_relation_corruption
114115
append_to_file"$pgdata/global/pg_internal.init","foo";
115116
append_to_file"$pgdata/global/pg_internal.init.123","foo";
116117

118+
# These are non-postgres macOS files, which should be ignored by the scan.
119+
# Only perform this test on non-macOS systems though as creating incorrect
120+
# system files may have side effects on macOS.
121+
append_to_file"$pgdata/global/.DS_Store","foo"
122+
unless ($Config{osname}eq'darwin');
123+
117124
# Enable checksums.
118125
command_ok(['pg_checksums','--enable','--no-sync','-D',$pgdata ],
119126
"checksums successfully enabled in cluster");

‎src/bin/pg_rewind/filemap.c

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -647,6 +647,10 @@ decide_file_action(file_entry_t *entry)
647647
if (strcmp(path,"global/pg_control")==0)
648648
returnFILE_ACTION_NONE;
649649

650+
/* Skip macOS system files */
651+
if (strstr(path,".DS_Store")!=NULL)
652+
returnFILE_ACTION_NONE;
653+
650654
/*
651655
* Remove all files matching the exclusion filters in the target.
652656
*/

‎src/bin/pg_rewind/t/003_extrafiles.pl

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5,6 +5,7 @@
55

66
use strict;
77
use warnings;
8+
use Config;
89
use PostgreSQL::Test::Utils;
910
use Test::More;
1011

@@ -53,6 +54,10 @@ sub run_test
5354
append_to_file
5455
"$test_standby_datadir/tst_standby_dir/standby_subdir/standby_file4",
5556
"in standby4";
57+
# Skip testing .DS_Store files on macOS to avoid risk of side effects
58+
append_to_file
59+
"$test_standby_datadir/tst_standby_dir/.DS_Store",
60+
"macOS system file"unless ($Config{osname}eq'darwin');
5661

5762
mkdir"$test_primary_datadir/tst_primary_dir";
5863
append_to_file"$test_primary_datadir/tst_primary_dir/primary_file1",

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp