01-13-2009
clive306,
Can you post the version of POSTGRESQL you are using?Do you perform a maintainance detach / attached of the whole database? quarterly maintenance ?
HOw is the disk space usage of your database in a daily basis? .
Cheers!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have an SCO-Unix server running.
There are some processes (unknown to me) which consume a lot of the system resources. This slows down the server dramatically.
Is there a command or program that monitors what processes are using the cpu, disk, etc.. and tell me how excessive and how... (3 Replies)
Discussion started by: Hansaplast
3 Replies
2. Solaris
Hi all,
Solaris is working very slow as login to solaris takes time say after 10 to 15 mins we get the login prompt back after logging in as oracle account/other account.
This causes most Batch run delays(DWHouse jobs) scheduled through cronjobs.
Where should one look for such issues to... (3 Replies)
Discussion started by: a1_win
3 Replies
3. SCO
Hi,
Wonder is someone can help.
I've got a server SCO_SV 3.2v5.0.7 PentIII that is located at a different site and is running slow and has been for a week. I've been speaking to a third party who say nothing is wrong with it but its still running slow.
The 3rd party advise it could be a... (2 Replies)
Discussion started by: tez
2 Replies
4. HP-UX
Any ideas on why SAM would take so long to load and initialize? (4 Replies)
Discussion started by: csaunders
4 Replies
5. UNIX for Dummies Questions & Answers
All, This is my interview questions. Let me explain the question. Some one is asking me that, the unix server is running very slow. As a unix unix admin, what are the steps we should follow?? What/which process we should check?? What is the way to find the root cause ? Please let me know.... (8 Replies)
Discussion started by: govindts
8 Replies
6. Solaris
I am facing a performance problem on a Solaris 10 Sparc V890 server, it is an old one I know. The first time we realized there is a problem with the server, is the time when ftp transfers are made. There were 4 other identical servers doing much better. Network drivers are checked and there... (3 Replies)
Discussion started by: royalliege
3 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I am trying to understand why my system is running at very high. This system is almost out of memory. See below.
swapon -s
Filename Type Size Used Priority
/dev/mapper/VolGroup00-LogVol02 partition 8388600 8235088 -1... (2 Replies)
Discussion started by: samnyc
2 Replies
8. UNIX for Dummies Questions & Answers
Hello,
My PC seems running slow: OS32 system, Pentium(R)4---2.40Ghz, 1GB RAM, 80GB HDI am running Ubuntu 11.10 (Oneiric Ocelot) alone in this box, which seems very slow to me. Is this normal?
Compared with my other PC (Running XP) with 1.99GHz AMD Athlon 3200+, 2GB RAM,500GB HD, XP and Mint... (11 Replies)
Discussion started by: yifangt
11 Replies
9. Shell Programming and Scripting
Slow runnin script. The problem seems to be the sed calls.
In summary the script reads list of users in file1. For each
username search two files (file 1 & file2) for the username
and get the value in the next line after "=". Compare these
values with each other.
If the same then output... (9 Replies)
Discussion started by: u20sr
9 Replies
10. AIX
Hello,
All the commands on AIX are running very slow.
Below is few stats but I didn't find any issue in cpu or memory reosurces
vmstat
System configuration: lcpu=4 mem=6144MB ent=1.00
kthr memory page faults cpu
----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
LEARN ABOUT CENTOS
cracklib-packer
cracklib-format(8) Debian GNU/Linux manual cracklib-format(8)
NAME
cracklib-format, cracklib-packer, cracklib-unpacker - cracklib dictionary utilities
SYNOPSIS
cracklib-format file ...
cracklib-packer cracklib_dictpath
cracklib-unpacker cracklib_dictpath
DESCRIPTION
cracklib-format takes a list of text files each containing a list of words, one per line, It lowercases all words, removes control charac-
ters, and sorts the lists. It outputs the cleaned up list to standard output. The text files may be optionally compressed with gzip(1).
If you supply massive amounts of text to cracklib-format you must have enough free space available for use by the sort(1) command. If you
do not have 20Mb free in /var/tmp (or whatever temporary area your sort(1) command uses), have a look at the /usr/sbin/cracklib-format pro-
gram which is a sh(1) program. You can usually tweak the sort(1) command to use any large area of disk you desire, by use of the -T
option. cracklib-format has a hook for this.
cracklib-packer reads from standard input a list of sorted and cleaned words and creates a database in the directory and prefix given by
the command line argument cracklib_dictpath. Three files are created with the suffixes of .hwm, .pwd, and .pwi. These three files are in
the format that the FascistCheck(3) subroutine, cracklib-unpacker(8), and cracklib-check(8), utilities understand. The number of words
read and written are printed on stdout(3).
cracklib-unpacker reads from the database in the directory and prefix given by the command line argument cracklib_dictpath and outputs on
standard output the list of words that make up the database.
The database is in a binary format generated by the utilities cracklib-format(8) and cracklib-packer(8). On a Debian system the database
is located in the directory /var/cache/cracklib/cracklib_dict and is generated daily with the program /etc/cron.daily/cracklib. The loca-
tion is also defined in the header file crack.h using the constant CRACKLIB_DICTPATH though none of the subroutines in the cracklib
libraries have this location hardcoded into their implementations.
FILES
/var/cache/cracklib/cracklib_dict.[hwm|pwd|pwi]
cracklib dictionary database files used by utilities.
/etc/cron.daily/cracklib
cracklib daily cron program to rebuild the cracklib dictionary database.
/etc/cracklib/cracklib.conf
cracklib configuration file used by the cracklib daily cron program to rebuild the cracklib dictionary database.
/usr/include/crack.h
cracklib header file defining the subroutine FascistCheck(3) and the constant CRACKLIB_DICTPATH used to compile in the location of
the cracklib dictionary database for these utilities.
/usr/sbin/cracklib-format
cracklib shell script to create initial list of words for dictionary database.
SEE ALSO
FascistCheck(3), cracklib-check(8), update-cracklib(8), create-cracklib-dict(8)
/usr/share/doc/libcrack2/libcrack2.html
/usr/share/doc/cracklib-runtime/cracklib-runtime.html
AUTHOR
cracklib2 is written by Alec Muffett <alecm@crypto.dircon.co.uk>. Manual added by Jean Pierre LeJacq <jplejacq@quoininc.com>.
2.7-8.5 Sat Jun 21 22:43:12 CEST 2008 cracklib-format(8)