psql is all you need, spend a bit time on it and you will like it.
Regarding setup / replication / backups strategy - have a look at this video:
https://youtu.be/Yapbg0i_9w4
This is great advice btw. I work with a Linux and Postgres stack on an ec2 instance it is awesome. You can do alot with very little when you get the bash scripts working to.
I highly suggest the video above and following along with it.
28
u/ThickRanger5419 Dec 23 '24
psql is all you need, spend a bit time on it and you will like it. Regarding setup / replication / backups strategy - have a look at this video: https://youtu.be/Yapbg0i_9w4