Re: Backup & Restore

HiCan u suggest a good backup solution for a windows installation ?  Looks like the suggested two [ pgbarman, pgbackrest ] works only in Linux. On Tuesday, 25 February, 2020, 01:46:33 am IST, Stephen Frost wrote: Greetings, * Dor Ben Dov (dor.ben-...@amdocs.com) wrote: > What is your

Re: LDAP with TLS is taking more time in Postgresql 11.5

On 2/24/20 11:50 AM, Mani Sankar wrote: Hi All, We have recently upgraded our postgres servers from 9.4 version to 11.5 version. Post upgrade we are see delay in authentication. Issue is when we are using ldaptls=1 the authentication takes 1 second or greater than that. But if I disable ldap

Re: Backup & Restore

Greetings, * Dor Ben Dov (dor.ben-...@amdocs.com) wrote: > What is your backup and restore solution in production when working with > Postgres ? > (+ if you can say few words why you picked this X solution instead of others) I'd recommend pgbackrest- https://www.pgbackrest.org, it's got lots of

Re: Backup & Restore

Am 24.02.20 um 09:18 schrieb Dor Ben Dov: Hi All, What is your backup and restore solution in production when working with Postgres ? most of our customers using Barman: https://www.pgbarman.org/ Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

LDAP with TLS is taking more time in Postgresql 11.5

Hi All, We have recently upgraded our postgres servers from 9.4 version to 11.5 version. Post upgrade we are see delay in authentication. Issue is when we are using ldaptls=1 the authentication takes 1 second or greater than that. But if I disable ldaptls it's getting authenticated within millise

Re: Reset DB stats suggestion pg_stat_reset()

> > We have seen some deadlocks and tempfile count in pg_stat_database view. > We are trying to reset the stats. > Can we use pg_stat_reset() function to reset these stats without any > impact stats of databases. > Please advise the process to reset the stats. > Yes, you could reset stats every mo

Re: backup broken

I correct the pg_hba.conf host all all 0.0.0.0/0 md5 to trust and the backup script work as root and postgres but pgAdmin4 stop launched. I needed to change all from ident to trust and add host all all 0.0.0.0/0 trust all working fine now. thank you. Bach-Nga -- Sent from: https://www.postg

backup broken

Hello, my pg_backup_rotated.sh script ran fine since Dec 20 and after rebuild the slave now it's broken and I do not know why. I can run pg_dumpall > /tmp_all_db_backup.sql but not from the script. From the log its pg_dumall: could not connect to database "template1": FATAL: Ident authenticatio

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

"Nick Renders" writes: > We have set up a new test environment running PostgreSQL v12.2 on macOS > 10.14 and the issue is still there. Some nearby threads prompt these two questions: 1. Are you using your own build, or is this from EDB's installer? 2. If the latter, does turning JIT off ("set

Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

We have set up a new test environment running PostgreSQL v12.2 on macOS 10.14 and the issue is still there. One thing I noticed, is that the returning columns do not affect the behaviour: SELECT * FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 'TEST' and SELECT gwsc_sequence FROM f

Re: Can I trigger an action from a coalesce ?

On 2020-02-24 05:20:49 +, sivapostg...@yahoo.com wrote: > It could also be done by putting those values in square bracket, if > substituted > with default values. > eg. [0] >4 >45 > [100] > Values within square brackets are default values. This would also work in many

Backup & Restore

Hi All, What is your backup and restore solution in production when working with Postgres ? (+ if you can say few words why you picked this X solution instead of others) Regards, Dor This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email