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? LATEST VERSION 12 Size of dataset? 1 million of records (varchar mainly x 10 columns) OS(es) involved? ClearLinux, XFS over nvmexpress Network distance between master standby(s)? Same network, 1Gbps, 1msec Does exist a common set of configurations to make the "select" op quicker? Does PG support in-memory tables (disk persisted) as MSSQL? For some high level overview: https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fdifferent-replication-solutions.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637213552584407018&sdata=naRegPRNIXs1zwv5I4K3o290qNQuxYLnz6Y3ocPJBn4%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fhigh-availability.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637213552584407018&sdata=cw%2Bk%2F1ifbZaOULKZpwdLRrbhjo1K7Vn58VOhx%2FkiUsk%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fapp-pgdump.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637213552584417025&sdata=vC8CAR8sCuTmhIEjNG9I7b51jLs0PwiDvu6kkCzxMWI%3D&reserved=0 https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F12%2Fapp-pgrestore.html&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637213552584417025&sdata=MNyfy9r7Bp67vzoGWdHVM3nug7YMZ%2F1%2Fugyb6EnZ9vE%3D&reserved=0 > - 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 > https://nam02.safelinks.protection.outlook.com/?url=www.dellapasqua.co > m&data=02%7C01%7C%7C2733978376ec4315c8a808d7d659978f%7C84df9e7fe9f > 640afb435aaaaaaaaaaaa%7C1%7C0%7C637213552584417025&sdata=LPtWHn7e6 > at%2BvpLaIXEqn2yDcQuicRQd3UZ4RCu%2BZQ4%3D&reserved=0 > -- Adrian Klaver adrian.kla...@aklaver.com
