On 4/1/20 9:17 AM, Roberto Della Pasqua wrote:
Hello, please some questions about a newbie Postgresql user:
- what is the best method to keep the data replicated (for backup purposes):
Can be possible to deploy a master/slave with realtime data replication and
adding a storage where do a journaled backup of the database, eg. a backup
incremental or GTF schema files? Which commands works better at low level for
background backup/restore?
The above is book in itself.
To help more information is needed:
Postgres version(s) involved?
Size of dataset?
OS(es) involved?
Network distance between master standby(s)?
For some high level overview:
https://www.postgresql.org/docs/12/different-replication-solutions.html
https://www.postgresql.org/docs/12/high-availability.html
https://www.postgresql.org/docs/12/app-pgdump.html
https://www.postgresql.org/docs/12/app-pgrestore.html
- does dbeaver is a good frontend for pg administration?
I use the Postgres client psql for administration. I rarely use GUI
frontends so I can't comment on DBeaver.
Roberto Della Pasqua
www.dellapasqua.com
--
Adrian Klaver
adrian.kla...@aklaver.com
