Re: Size of PostgreSQL backup ./. Sybase DUMP

I don't know anything about Sybase, but if that dump is something akin to "pg_dump", then you are comparing apples and oranges. Moreover, the base backup is compressed, and I don't know if the Sybase dump is. If you had used PostgreSQL v13, you could check the backup for completenes. But the be

Re: Failed Login Attempts in PostgreSQL

You can use fail2ban for example. See for example this thread here https://www.postgresql.org/message-id/flat/61463e206b7c4c0ca17b03a59e890b78%40lmco.com, and the config on https://github.com/rc9000/postgres-fail2ban-lockout. (probably needs some small adaptations, but as a base it should work

RE: EXTERNAL: Re: Netapp SnapCenter

>> On 23. Jun, 2020, at 22:59, Wolff, Ken L wrote: >> >> https://www.netapp.com/us/media/tr-4770.pdf > I will check this out. Thank you very much. There's actually a lot of good stuff in that document about Postgres in general. I'd be curious to hear wh

Re: Netapp SnapCenter

One last follow up on this thread. I don't remember this being mentioned, so wanted to share in case if might be of help. The following is NetApps's Best Practices for PostgreSQL on NetApp ONTAP storage: https://www.netapp.com/us/media/tr-4770.pdf

Re: Netapp SnapCenter

in-time at which that snapshot was taken? Thanks much. Ken -Original Message- From: Stephen Frost Sent: Monday, June 22, 2020 7:06 AM To: Paul Förster Cc: Magnus Hagander ; Wolff, Ken L (US) ; pgsql-general Subject: EXTERNAL: Re: Netapp SnapCenter Greetings, * Paul Förster (

RE: Netapp SnapCenter

We got the following from one of our NetApp contacts regarding a similar question. I'd be interested to hear if anyone feels the steps mentioned are not accurate: There is presently no NetApp supported plugin for PostgreSQL for SnapCenter. There is a community support plugin for PostgreSQL,

Re: Inherited an 18TB DB & need to backup

Depending on your storage subsystem, perhaps storage-level snapshots might be an option? They often seem to be the best choice for VLDBs. From: Suhail Bamzena Sent: Friday, May 15, 2020 7:23 AM To: Christoph Berg Cc: Rory Campbell-Lange ; pgsql-general@lists.postgresql.org; pgeu-gene...@lists

RE: EXTERNAL: Re: Lock Postgres account after X number of failed logins?

Thanks again, everyone, for all the responses and ideas. I'm still getting caught up on the various responses but with respect to LDAP/AD, I truly wish it were an option. I agree with the various sentiments that AD authentication is more manageable, scalable, secure, etc. However, if there we

Re: Lock Postgres account after X number of failed logins?

requests in the queue. Just adding my $.02 here. Thanks again for your time & thoughts. Ken -Original Message- From: Stephen Frost Sent: Tuesday, May 05, 2020 2:46 PM To: Tom Lane Cc: Wolff, Ken L (US) ; Allan Kamau ; pgsql-general@lists.postgresql.org; Adrian Klaver Subject: EXTE

Re: Lock Postgres account after X number of failed logins?

some other method. Again, thank you very much for taking the time to respond and for all your ideas. I do appreciate it! Ken From: Allan Kamau Sent: Tuesday, May 05, 2020 8:40 AM To: Wolff, Ken L (US) Cc: pgsql-general@lists.postgresql.org; Adrian Klaver Subject: EXTERNAL: Re: Lock Post

Lock Postgres account after X number of failed logins?

Hi, everyone. Wondering if there's a way in PostgreSQL to automatically lock accounts after a number of failed logins (a security requirement for my organization). I've been investigating this for a while and the only reference I've found is to write a hook: https://wiki.postgresql.org/image