|
Postgresql Database Setup for IRIX6.5
1.Add a user
User name: postgres
Shell:tcsh
2.Make DataBase Dir
# mkdir /usr/people/postgres/data
# chown postgres /usr/people/postgres/data
# su - postgres
# cd /usr/freeware/bin
3.#./initdb -D /samba/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Fixing permissions on pre-existing data directory /samba/data
Creating database system directory /samba/data/base
Creating database XLOG directory /samba/data/pg_xlog
Creating template database in /samba/data/base/template1
Creating global relations in /samba/data/base
Adding template1 database to pg_database
Creating view pg_user.
Creating view pg_rules.
Creating view pg_views.
Creating view pg_tables.
Creating view pg_indexes.
Loading pg_description.
Vacuuming database.
Success. You can now start the database server using:
./postmaster -D /samba/data
or
./pg_ctl -D /samba/data start
4.#./pg_ctl -D /samba/data start
postmaster successfully started up.
www 10% DEBUG: Data Base System is starting up at Wed Aug 8 21:23:16 2001
DEBUG: Data Base System was shut down at Wed Aug 8 21:23:03 2001
DEBUG: Data Base System is in production state at Wed Aug 8 21:23:16 2001
#
5.OK
How to use Quotas in IRIX6.5 system ?
Author:general@avcc.com.cn
1. How to use Quotas Subsystem For every user disk space ?
Notes:quota just use in localdisk,except sysdisk and remote disk can't use.
a.setup quotas subsystem of IRIX6.x
b.# chkconfig quotacheck on
# chkconfig quotas on
/etc/init.d
# quotas stop
# quotas start
c. at /etc/mtab and fstab
add "/dev/dsk/dks1d6s7 /disk1 xfs rw,quota 0 0"
d.Add a user e.g jaleo use disk space just 25m
at /disk1/jaleo(/dev/dsk/dks1d6s7)
e.at /disk1/quotas (under every filesystem root must be creat a quotas file )
# touch /disk1/quotas
add " fs /disk1 kbytes (soft = 25000, hard = 25000) inodes (soft = 25000, hard = 25000)"
f. Limit User
#edquota jaleo
add "fs /disk1 kbytes (soft = 25000, hard = 25000) inodes (soft = 25000, hard = 25000)"
2.Notes: How to copy jaleo user limit to share jack user limit ?
#edquota -p jaleo share jack
g.start quota
# quotaon -v -a
# reboot
h.How to test quota succeed ?
# quota -v jaleo
Disk quotas for jaleo (uid 64684):
Filesystem usage quota limit timeleft files quota limit timeleft
/disk1 96 25000 25000 49 25000 25000
#repquota -v -a
/dev/dsk/dks1d6s7 (/disk1):
---------------------------
Disk limits File limits
User used soft hard timeleft used soft hard timeleft
root --4099488 0 0 75 0 0
jaleo -- 96 25000 25000 49 25000 25000
i.If user disk space over mix 25m will be list Quota Message:" Disk quota exceeded "
|
![[ 永远的UNIX::UNIX技术资料的宝库 ]](/images/title.gif)
