GnuCash Users & Developers

12 readers

1 users here now

📊 Welcome to GnuCash Users & Developers

This community is for users and developers of GnuCash — free, open-source personal and small-business financial accounting software.

✅ What you can post

Questions about setup, usage, and troubleshooting
Tips, workflows, and plugins
Feature discussions and development updates
News, resources, and learning materials

📚 Useful Links

📏 Community Guidelines

Be respectful and keep discussions civil
Stay on topic: GnuCash and related finance/accounting topics
No spam, self-promotion, or unrelated financial advice
Use clear titles when asking for help

Happy bookkeeping, and welcome to the community!

founded 4 months ago

MODERATORS

RinseChessBacked@lemmy.ml

Dumping a GnuCash PostgreSQL Database (lemmy.ml)

submitted 3 months ago by RinseChessBacked@lemmy.ml to c/gnucash@lemmy.ml

0 comments fedilink hide all child comments

I started using a PostgreSQL database with GnuCash instead of a file, and set up a weekly cron job to dump the database to a file. Here's the script:

#!/usr/bin/env bash

# Requires that ~/.pgpass exists, is chmod 600, and contains a line like:
#
# 127.0.0.1:5432:*:gnucash_user:my-secret-password

pg_dump -h 127.0.0.1 -U gnucash_user -d gnucash_db -Fc > ${HOME}/gnucash_$(date +%F).dump

I'm probably going to modify this script to check that ~/.pgpass exists.

Any other changes you think I need?

no comments (yet)

sorted by: hot top controversial new old

there doesn't seem to be anything here