网管联盟 | 网管论坛 | 网管u家 | 网管博客 | 网管软件 | 网管求职 | 小游戏 | 网管搜索 | 网管原创 | 网管聚合 | 网管读摘 | 网管焦点 | 世界素材 | 会员投稿 | 会员中心 
中国网管联盟
Windows Linux Cisco 网络技术 数据库 黑客攻防 DotNet Java PHP 认证 新闻资讯 服务器 存储资讯 网络设备 网管学堂 技术专题 焦点 网吧频道
 当前位置: > bitsCN.com > 数据库技术 > 其它数据库 > Postgresql Database Setup for IRIX6.5  

Postgresql Database Setup for IRIX6.5

2006-06-18  作者:BitsCN整理  来源:中国网管联盟  点评 投稿 收藏

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". 网管有家www.bitscn.net
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 网管论坛bbs_bitsCN_com
#
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 ?

网管有家www.bitscn.net



#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 "

 上一篇:Linux数据库大比拚(1)   下一篇:PostgreSQL入门,V0.9.3+++
Postgresql Database Setup for IRIX6.5 评论:
loading.. 评论加载中…
评论:请自觉遵守互联网相关政策法规,评论不得超过250字。

验证码: 注册用户
本类热门排行:
最新推荐文章:
网管论坛交流: