[ADMIN] openssl-1.0,0e for Solaris 10 64 bit

2012-11-15 Thread Dinesh Bhandary
Hello - Do you know of a source where I can get a binary of Openssl-1.0.0e for Sparc 64 ( Solaris 10). Any tips will be very helpful. Thanks. Dinesh

[ADMIN] binary version of Openssl-1.0.0e on Solaris 10 (64 bit Sparc)

2012-11-15 Thread Dinesh Bhandary
Hello - Do you know of a source where I can get a binary of Openssl-1.0.0e for Sparc 64 ( Solaris 10). Any tips will be very helpful. Thanks. Dinesh

[ADMIN] binary version of Openssl-1.0.0e on Solaris 10 (64 bit Sparc)

2012-11-15 Thread Dinesh Bhandary
Hello - Do you know of a source where I can get a binary of Openssl-1.0.0e for Sparc 64 ( Solaris 10). Any tips will be very helpful. Thanks. Dinesh

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Stephen Frost
* Craig James (cja...@emolecules.com) wrote: > A far better approach is an escalating delay. Check the number of failed > login attempts N and delay (for example) N^2 seconds before responding > again. Legitimate users are mildly inconvenienced, and hackers are > severely hampered. Sadly, in cert

Re: [ADMIN] Date range for pg_stat_all_tables?

2012-11-15 Thread Ronit Allen
Hi - Thanks for below. On 9.1 with postgresql.conf left at defaults, what period of time does a query on pg_stat_all_tables cover? Let's say my database has been running for exactly one year. I then issue SELECT relname, n_tup_ins FROM pg_stat_all_tables; Do the results show me inserts for the

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Craig James
On Thu, Nov 15, 2012 at 1:32 AM, Lukasz Brodziak wrote: > 2012/11/15 Craig Ringer > > Another option would be to monitor syslog or the csvlog and lock the > > user out by changing their password or revoking CONNECT rights if they > > trip the threshold. It wouldn't be as responsive to high-rate b

[ADMIN] How to restore backup

2012-11-15 Thread Ravi Kumar
Dear all ,   when i am trying to  restore backup from WAL files ,the following error came:    cannot stat `/opt/pgsqlbackup/wals/0001.history': No such file or directory LOG:  restored log file "00010003" from archive LOG:  unexpected pageaddr 0/A000 in log file 0, segment 3,

Re: [ADMIN] Query Stuck in running server

2012-11-15 Thread Albe Laurenz
Shams Khan wrote: > Whenever the load of server increases, I find this query running in which seems to me the reason. Is > there any other way I can written in such a way so that it doesn't hang up the entire process? Oh, I see. Try to follow http://wiki.postgresql.org/wiki/Slow_Query_Questions i

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Lukasz Brodziak
2012/11/15 Craig Ringer > Another option would be to monitor syslog or the csvlog and lock the > user out by changing their password or revoking CONNECT rights if they > trip the threshold. It wouldn't be as responsive to high-rate brute > forcing attempts but your IDS should be handing those alre

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Craig Ringer
On 11/15/2012 04:40 PM, Lukasz Brodziak wrote: > Hi, > > As far as I know there is no such parameter in PG. If you use PG as a > database for your program you can implement the feature in the > appplication by logging the failed logins in separate table(or the one > holding application users and th

Re: [ADMIN] Query Stuck in running server

2012-11-15 Thread Shams Khan
Whenever the load of server increases, I find this query running in which seems to me the reason. Is there any other way I can written in such a way so that it doesn't hang up the entire process? On Thu, Nov 15, 2012 at 2:24 PM, Albe Laurenz wrote: > Shams Khan wrote: > > There are few query I fo

Re: [ADMIN] Query Stuck in running server

2012-11-15 Thread Albe Laurenz
Shams Khan wrote: > There are few query I found at the time of monitoring below > > 00:54:43.574338 | 26952 | select a.actno,MAX(b.actid) as actid,MAX(b.actname) as name,MAX(b.phone) > as phone,MAX(b.email) as mail,MAX(a.subsno) as subs,MAX(t.pkgid > ) as svcid,MAX(a.expirydt) as expirydt,MAX

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Lukasz Brodziak
A little suplement to previous answer You can also automate GRANT process by creating a table called e.g. locked_users containing role name and revoke timestamp then make a function that will check the time passed since revoking permissions for each user and if it will by equal or higher than time

Re: [ADMIN] Failed Login Attempts parameter

2012-11-15 Thread Lukasz Brodziak
Hi, As far as I know there is no such parameter in PG. If you use PG as a database for your program you can implement the feature in the appplication by logging the failed logins in separate table(or the one holding application users and their passwords) and then disable login for the user if numb