Re: [GENERAL] create trigger in postgres to check the password strength

2017-02-03 Thread Vladimir Rusinov
assword'; > > where it will test that the password entered should be according to the > company standard, while creation of users. > So please suggest. > Consider using PAM authentication where you can insert any of already existing password strength checks. Or, maybe, LDAP auth where stuff will be enforced by LDAP server. -- Vladimir Rusinov Storage SRE, Google Ireland smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] pgbench initialize

2016-12-16 Thread Vladimir Rusinov
Depends on goals of your benchmarking. What are you trying to achieve? Initialization and vacuuming each time will help achieve more consistent best-case numbers (to reduce variance, I'd also destroy cluster completely and clean up hardware, e.g. run fstrim in case of SSD, etc). If you are howeve

Re: [GENERAL] Extension compatibility between postgresql minor version

2016-11-24 Thread Vladimir Rusinov
Maybe, maybe not. Have you tried installing '=postgresql93-contrib-9.3.14' ? On Thu, Nov 24, 2016 at 3:41 PM David Richer wrote: > Hi guys, > > > > I want to check my production server for the free space map issue. > https://wiki.postgresql.org/wiki/Free_Space_Map_Problems > > I am on Centos 6