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 "
| YT 回复于：2003-01-19 15:22:22 |
| 好文章，保存先～！
支持 |
| sgiman 回复于：2003-01-20 13:26:18 |
| 谢谢你szh ，发表我的文章！ |
| microroad 回复于：2003-01-21 16:00:33 |
| [quote:899079a4ec="sgiman"]谢谢你szh ，发表我的文章！[/quote:899079a4ec]
你想和szh抢功，现在szh正申请斑竹呢，你不支持到来挖墙角  |
| szh 回复于：2003-01-21 16:11:59 |
| 关于这篇文章我发表我的看法！！
以上这篇文章是我在http://www.avcc.com.cn/这个网站上看到的！！ 当时我看不错就下载了下来，顺便也就帖了出来分享给大家了！！！希望大家也能从中受益！！ 我帖这篇文章没有其它任何意思！！！ 至于这篇文章是谁的我也不知道！！ |
| microroad 回复于：2003-01-21 16:23:17 |
| 呵呵，我们都看到了AV技术论坛的的那篇文章，你只要帖一个网址不就可以了吗，多简单！ |
| szh 回复于：2003-01-21 16:25:24 |
| 哦！！
以后记住了！！不是自己的千万不可以往出帖！！ 呵呵！！！ |
| YT 回复于：2003-01-29 11:09:20 |
| 没有关系，SZH你可以说是别人COPY你的嘛。。。呵呵 |
延伸阅读
文章来源于领测软件测试网 https://www.ltesting.net/