R: dbeaver
От | Roberto Della Pasqua |
---|---|
Тема | R: dbeaver |
Дата | |
Msg-id | AM0PR0502MB36506444373D81B92361E38099C90@AM0PR0502MB3650.eurprd05.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: dbeaver (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: R: dbeaver
|
Список | pgsql-general |
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 backupof the database, eg. a backup incremental or GTF schema files? Which commands works better at low level for backgroundbackup/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.klaver@aklaver.com
В списке pgsql-general по дате отправления:
Следующее
От: Silvio Fabi - NBS srlДата:
Сообщение: postgres: archiver process failed on 000000010000020A00000073