I'm moving files from one QNAP system to another, and I'm using rsync for this. But excluding filed doesn't work!
Last week for 'PGSQL Phriday': Describe how you do backups for your PostgreSQL databases.
Thanks to Ryan Booz we now have the #PGSQLPhriday blogging series. The second edition is about backups. And of course also about restore.
This month's #PGSQLPhriday topic: pick your three favorite or most important best pratices for #PostgreSQL. Tell them in a form that two are true, one is a lie. See if you can spot which one is true and which one is false. The resolution is at the end of this blog posting.
In September 2021, a patch for the upcoming PostgreSQL version 15 was committed which introduces a visible change for users: the 'CREATE' privilege for the 'public' schema is no longer set by default.
While attending a conference (yay) the discussion turned to system columns, and especially 'ctid'. This was in context of backups, and the physical position of data on disk. The question was if that can be used to determine if an incremental backup is required, and if it is enough to just copy that field where the 'ctid' points to. Not quite, but I’d like to use this question to describe the system columns more in detail.
Together with Lætitia Avrot and Nikolay Samokhvalov I was invited to participate in a Community Panel about PostgreSQL Upgradability at Postgres Vision 2022. During this panel each of us provided examples for how easy or complicated *PostgreSQL* upgrades still are.
The Google Summer of Code 2021 for the PostgreSQL Project is wrapped up.
Among other external solutions, I store some data on Storage Boxes from Hetzner. The Storage Box allows you to have sub-accounts, so for every server and system storing data there, I use a separate account. For each sub-account, one can select a subdirectory where the data is stored, and the sub-account then can only see this data. The Admin account can see all data, and see all directories.
Wow! The PostgreSQL Project got all 7 proposals accepted into Google Summer of Code 2021!