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 11 months ago

MODERATORS

RinseChessBacked@lemmy.ml

Dumping a GnuCash PostgreSQL Database (lemmy.ml)

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

2 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?

you are viewing a single comment's thread
view the rest of the comments

[–] RinseChessBacked@lemmy.ml 2 points 11 months ago

Glad to be here! I'm new to Lemmy (and the whole Fediverse) so I figured this would give me a good reason to get on here regularly and use it. I'm probably going to be mostly posting details about how I set up and use GnuCash for myself, in case it helps anyone else—including my future self when I inevitably forget how I did something 🤣. Feel free to ask questions or post your experiences.