[HACKERS] blocking the alter role command

2016-01-12 Thread JotaComm
Hello, I would like to know if is it possible to block the following command: ALTER USER myuser PASSWORD; ​My target is allow ​to execute this command from a specific address. Thanks a lot. ​Regards​ -- JotaComm http://jotacomm.wordpress.com

Re: [HACKERS] Problems with autovacuum and vacuum

2011-01-03 Thread JotaComm
Hello, Filip 2011/1/1 Filip Rembiałkowski > > 2010/12/30 JotaComm > >> Hello, >> >> Last week I had a serious problem with my PostgreSQL database. My >> autovacuum is OFF, but in September it started to prevent the transaction >> wraparoud; however l

[HACKERS] Problems with autovacuum and vacuum

2010-12-30 Thread JotaComm
he vacuum was blocked has billion of rows. I'm using the PostgreSQL 8.3.8 The configuration of the vacuum parameters are: vacuum_cost_limit = 200 vacuum_cost_delay = 0 vacuum_freeze_min_age = 1 autovacuum = off autovacuum_freeze_max_age = 20000 Regards, João Paulo -- JotaComm http://jotacomm.wordpress.com