PostgreSQL

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall

See also mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. I’m linking this because I use both articles on a regular basis. Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a …

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall Read More »

Pentabarf email tokens

As found at: http://web.archive.org/web/20160309091535/http://pentabarf.org/Email Variables The following variables may be used in the text and subject of the mail {{name}} The name of the recipient. {{person_id}} The person-id of the recipient. {{conference_acronym}} The acronym of the conference if the recipients are conference specific. {{conference_title}} The title of the current conference if the recipients are conference …

Pentabarf email tokens Read More »

pg_dump: aborting because of server version mismatch

Here’s something to be aware of. Update your PostgreSQL client on your Bacula client if it is used for backing up the Catalog. Ngaios just told me: FILE_AGE WARNING: /usr/backups/bacula/MyCatalog.dump is 45125 seconds old and 0 bytes I looked at the backup job from earlier today: 28-Dec 08:15 bacula-dir JobId 195194: shell command: run BeforeJob …

pg_dump: aborting because of server version mismatch Read More »

Scroll to Top