pg_basebackup: errors on macOS on directories with ".DS_Store" files

From: Mark Guertin <markguertin(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pg_basebackup: errors on macOS on directories with ".DS_Store" files
Date: 2023-04-19 15:45:51
Message-ID: E258CE50-AB0E-455D-8AAD-BB4FE8F882FB@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pg_basebackup: error: backup failed: ERROR: invalid segment number 0 in file ".DS_Store"

This one is pretty self explanatory. When running pg_basebackup on macOS it should probably be ignoring any .DS_Store files found inside data directories instead of transferring/processing them.

Steps to reproduce:
- on a macOS based pg server open a directory containing pg data files and set any kind of view options or move an icon
- this can also happen with inheritance, so even if you do not directly set these kinds of options on data folders, for example if a parent folder has a view option set when a new folder is created it can inherit the same view options, or if spotlight search sets up some metadata this .DS_Store may also be created

My workaround was to manually delete all of the .DS_Store files that the OS created and then immediately run pb_basebackup using the following method:

find <dir> -iname .DS_Store -exec rm {} \;

Some background on .DS_Store files:

https://en.wikipedia.org/wiki/.DS_Store

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Korotkov 2023-04-19 16:26:15 Re: BUG #17847: Unaligned memory access in ltree_gist
Previous Message Tom Lane 2023-04-19 15:42:20 Re: Assert failure with ICU support