Email or username:

Password:

Forgot your password?
trumpet@mas.to's posts Post Back to profile
Top-level
BitPirate

@trumpet would love to get more information about your current setup. Are you running a Postgres cluster or just a single instance? How do you handle backups? etc etc

6 Nov 2022 at 12:26 | Wall-to-wall | Open on mas.to
3 comments
trumpet@mas.to

@bitpirate I run mas.to in an LXC virtual container for easy portability. It means I can do quick snapshot backups with ZFS, and can just lift and shift to another server if I need to. Running a single Postgres instance at the moment and I think that's the next thing I'll need to upgrade. We're running on a dedicated Intel i9-9900K machine with 128GB at the moment, but I have a 5950X ready as the next step up.

6 Nov 2022 at 12:32 | Open on mas.to
BitPirate

@trumpet take a look at patroni if you want to run a cluster. For backups i can recommend barman. ZFS snapshots work but might have a high recovery time:

postgresql.org/docs/current/ba

tl;dr run CHECKPOINT before creating a snapshot

6 Nov 2022 at 13:14 | Open on mas.to
trumpet@mas.to

@bitpirate Patroni looks great, will have to look into that 🙂

6 Nov 2022 at 15:06 | Open on mas.to
Go Up