R: dbeaver

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(dot)klaver(at)aklaver(dot)com