PostgreSQL安装指南.docx
- 文档编号:26956268
- 上传时间:2023-06-24
- 格式:DOCX
- 页数:23
- 大小:18.93KB
PostgreSQL安装指南.docx
《PostgreSQL安装指南.docx》由会员分享,可在线阅读,更多相关《PostgreSQL安装指南.docx(23页珍藏版)》请在冰豆网上搜索。
PostgreSQL安装指南
SUSEPostgreSQL下载地址:
http:
//oscg-
其他的版本可以到这个地址选择:
这个RPM版本我也没装过,不知道安装完毕之后是否需要手工添加用户,下面是手工添加账号的命令
adduserpostgres
然后将postgres用户的密码改为123456,也可以是其他的密码,但是需要更改SCGWEBApp的配置文件(位置在应用程序的安装目录下的WEB-INF\classes\db.conf文件),编辑这个文件,将里面db.pass=xx改为你指定的密码即可。
估计这个rpm版本安装完毕之后会自动已service的形式运行,重启系统之后,用如下命令测试
su-postgres
/usr/local/pgsql/bin/createdbscgdb注释:
创建scgdb数据库
/usr/local/pgsql/bin/psqlscgdb注释:
连接到scgdb,输入密码之后会进入psql的控制台
将附件的内容粘贴到控制台运行,即创建所需的数据表
\q退出psql的控制台
这样就可以启动SCGwebapp了。
PostgreSQL源码编译方式安装:
下载源码:
http:
//ftp.postgresql.org/pub/source/v8.4.17/postgresql-8.4.17.tar.gz
解压这个文件
./configure
gmake
su
gmakeinstall
adduserpostgres
mkdir/usr/local/pgsql/data
chownpostgres/usr/local/pgsql/data
su-postgres
/usr/local/pgsql/bin/initdb-D/usr/local/pgsql/data
/usr/local/pgsql/bin/postgres-D/usr/local/pgsql/data>logfile2>&1&
/usr/local/pgsql/bin/createdbscgdb
/usr/local/pgsql/bin/psqlscgdb
然后在控制台上将附件中的文件内容粘贴进去即可
\q退出psql的控制台
以服务的形式启动这个程序,看系统的runlevel是多少,默认可能是3
在/etc/rc3.d/编辑一个SXXXPostgresql的文件,文件内容如下即可
su-postgres
/usr/local/pgsql/bin/postgres-D/usr/local/pgsql/data>logfile2>&1&
附录:
将下面的内容粘贴到psql的控制台即可。
不知道word是否会更改内容,我会给你加一个附件在邮件中。
--Table:
tb_if1status
--DROPTABLEtb_if1status;
CREATETABLEtb_if1status
(
time_sintegerNOTNULL,
time_usintegerNOTNULL,
stattypeintegerNOTNULL,--统计类型...
localipcharactervaryingNOTNULL,
localportintegerNOTNULL,
destipcharactervaryingNOTNULL,
destportintegerNOTNULL,
connectstatusintegerNOTNULL
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_if1status
OWNERTOpostgres;
COMMENTONTABLEtb_if1status
IS'IF1连接状态表';
COMMENTONCOLUMNtb_if1status.stattypeIS'统计类型
1:
发送
2:
接收';
COMMENTONCOLUMNtb_if1status.connectstatusIS'IF1状态类型
0:
断线
1:
在线
2:
正在连接';
--Table:
tb_role
--DROPTABLEtb_role;
CREATETABLEtb_role
(
roleidbigintNOTNULL,
rolenamecharactervaryingNOTNULL,
CONSTRAINTtb_role_pkeyPRIMARYKEY(roleid)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_role
OWNERTOpostgres;
insertintotb_role(roleid,rolename)values(1,'root');
insertintotb_role(roleid,rolename)values(2,'config');
insertintotb_role(roleid,rolename)values(3,'view');
--Table:
tb_user
--DROPTABLEtb_user;
--Table:
tb_user
--DROPTABLEtb_user;
CREATETABLEtb_user
(
useridbigintNOTNULL,
usernamecharactervarying(20)NOTNULL,
userpasscharactervarying(32)NOTNULL,
roleidbigintNOTNULL,
usermemocharactervarying,--备注
CONSTRAINTtb_user_pkeyPRIMARYKEY(userid),
CONSTRAINTtb_user_roleid_fkeyFOREIGNKEY(roleid)
REFERENCEStb_role(roleid)MATCHSIMPLE
ONUPDATENOACTIONONDELETENOACTION
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_user
OWNERTOpostgres;
COMMENTONCOLUMNtb_user.usermemoIS'备注';
insertintotb_user(userid,username,userpass,roleid,usermemo)values(1,'root','14e1b600b1fd579f47433b88e8d85291',1,'rootuser');
--Table:
tb_systemconfig
--DROPTABLEtb_systemconfig;
CREATETABLEtb_systemconfig
(
configidbigintNOTNULL,--1:
网卡1的IP地址...
confignamecharactervaryingNOTNULL,
configvaluecharactervaryingNOTNULL,
CONSTRAINTtb_systemconfig_pkeyPRIMARYKEY(configid)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_systemconfig
OWNERTOpostgres;
COMMENTONCOLUMNtb_systemconfig.configidIS'1:
网卡1的IP地址
2:
网卡1的掩码
3:
网卡1的网关
4:
网卡2的IP地址
5:
网卡2的掩码
6:
网卡2的网关
7:
网卡3的IP地址
8:
网卡3的掩码
9:
网卡3的网关
10:
网卡4的IP地址
11:
网卡4的掩码
12:
网卡4的网关
13:
NTP服务器的IP
14:
处理性能告警门限
15:
日志最大存储门限
17:
面向共享平台的SCGVersion
20:
NTPRefreshInterval
100:
面向设备的SCGVersion
101:
面向设备的监听端口';
--Table:
tb_spconfig
--DROPTABLEtb_spconfig;
CREATETABLEtb_spconfig
(
spidbigintNOTNULL,--共享平台ID
ctypebigintNOTNULL,--配置类型...
configidbigintNOTNULL,--1:
CPU利用率告警门限...
configvaluecharactervaryingNOTNULL,
CONSTRAINTtb_spconfig_pkeyPRIMARYKEY(spid,configid)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_spconfig
OWNERTOpostgres;
COMMENTONTABLEtb_spconfig
IS'面向共享平台的告警配置';
COMMENTONCOLUMNtb_spconfig.spidIS'共享平台ID';
COMMENTONCOLUMNtb_spconfig.ctypeIS'配置类型
1:
告警配置
3:
IF1告警配置
';
COMMENTONCOLUMNtb_spconfig.configidIS'1:
CPU利用率告警门限
2:
内存利用率告警门限
3:
硬盘利用率告警门限
10:
eth0(value:
0uncheck1check)
11:
eth1
12:
eth2
13:
eth3
21:
CPU过负荷告警(1:
上报共享平台0:
不上报)
22:
内存少告警
23:
输入链路中断告警
24:
采集网关数据丢失告警
25:
磁盘少告警
26:
网口故障告警
27:
进程异常告警
28:
网关上报无数据
29:
采集板卡端口告警
30:
Abis链路(时隙)物理故障告警
31:
采集板卡端口故障恢复
32:
Abis链路(时隙)无数据周期状态上报
33:
Abis链路(时隙)物理故障周期上报
34:
Abis链路(时隙)正常状态周期上报
35:
Abis链路(时隙)无数据恢复
36:
Abis链路(时隙)物理故障恢复
';
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,21,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,22,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,23,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,24,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,25,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,26,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,27,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,28,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,29,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,30,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,31,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,32,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,33,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,34,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,35,'1');
insertintotb_spconfig(spid,ctype,configid,configvalue)values(1,3,36,'1');
--Table:
tb_devconfig
--DROPTABLEtb_devconfig;
CREATETABLEtb_devconfig
(
idserialNOTNULL,
loginidcharactervarying,
psdcharactervarying,
CONSTRAINTtb_devconfig_pkeyPRIMARYKEY(id)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_devconfig
OWNERTOpostgres;
COMMENTONTABLEtb_devconfig
IS'面向设备的配置';
--Table:
tb_sporder
--DROPTABLEtb_sporder;
CREATETABLEtb_sporder
(
idserialNOTNULL,
spidbigintNOTNULL,--共享平台id
datachannelbigintNOTNULL,--数据通道ID...
ordertypeintegerNOTNULL,--1:
LAC&CI...
param1charactervarying,
param2charactervarying,
startdatecharactervarying,
enddatecharactervarying,
weekcharactervarying,
starttimebigintNOTNULL,--开始时间
endtimebigintNOTNULL,--结束时间
CONSTRAINTtb_sporder_pkeyPRIMARYKEY(id)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_sporder
OWNERTOpostgres;
COMMENTONTABLEtb_sporder
IS'共享平台订阅表';
COMMENTONCOLUMNtb_sporder.spidIS'共享平台id';
COMMENTONCOLUMNtb_sporder.datachannelIS'数据通道ID
tb_spconfig.configid取值101-108';
COMMENTONCOLUMNtb_sporder.ordertypeIS'1:
LAC&CI
2:
LAC
3:
CARDID/PORTID
4:
CardId
5:
ALL';
COMMENTONCOLUMNtb_sporder.starttimeIS'开始时间';
COMMENTONCOLUMNtb_sporder.endtimeIS'结束时间';
--Table:
tb_lacandci
--DROPTABLEtb_lacandci;
CREATETABLEtb_lacandci
(
laccharactervaryingNOTNULL,
cicharactervaryingNOTNULL,
cardidcharactervarying,
portcharactervarying,
stm1charactervarying,
e1charactervarying,
tscharactervarying,
ratecharactervarying,
CONSTRAINTtb_lacandci_pkeyPRIMARYKEY(lac,ci)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_lacandci
OWNERTOpostgres;
COMMENTONTABLEtb_lacandci
IS'LAC/CI';
--Table:
tb_perf
--DROPTABLEtb_perf;
CREATETABLEtb_perf
(
time_sintegerNOTNULL,
time_usintegerNOTNULL,
stattypeintegerNOTNULL,--统计类型...
localipcharactervaryingNOTNULL,
localportintegerNOTNULL,
destipcharactervaryingNOTNULL,
destportintegerNOTNULL,
totalframebigint,
totalbytesbigint,
totaldiscardframebigint,
totaldiscardbytesbigint
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_perf
OWNERTOpostgres;
COMMENTONTABLEtb_perf
IS'性能统计表';
COMMENTONCOLUMNtb_perf.stattypeIS'统计类型
1:
发送
2:
接收';
--Table:
tb_log
--DROPTABLEtb_log;
CREATETABLEtb_log
(
logtypeintegerNOTNULLDEFAULT1,--日志类型,当前只有一个值...
alarmtypeintegerNOTNULL,--告警类型...
alarmidintegerNOTNULL,--1:
CPU过负荷告警...
logtime_sbigintNOTNULL,
logtime_usbigintNOTNULLDEFAULT0,
laccharactervarying,
cicharactervarying,
teicharactervarying,
cardidcharactervarying,
ratecharactervarying,
tscharactervarying,
e1charactervarying,
stm1charactervarying,
portnocharactervarying,
CONSTRAINTtb_log_pkeyPRIMARYKEY(logtype,alarmtype,alarmid,logtime_s,logtime_us)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_log
OWNERTOpostgres;
COMMENTONCOLUMNtb_log.logtypeIS'日志类型,当前只有一个值
1:
告警';
COMMENTONCOLUMNtb_log.alarmtypeIS'告警类型
1:
销警
2:
告警
';
COMMENTONCOLUMNtb_log.alarmidIS'1:
CPU过负荷告警
2:
内存少告警
3:
输入链路中断告警
4:
采集网关数据丢失告警
5:
磁盘少告警
6:
网口故障告警
7:
进程异常告警
10网关上报无数据
12.采集板卡端口告警
16.Abis链路(时隙)物理故障告警
220.采集板卡端口故障恢复
215、Abis链路(时隙)无数据周期状态上报
216、Abis链路(时隙)物理故障周期上报
217、Abis链路(时隙)正常状态周期上报
218Abis链路(时隙)无数据恢复
219Abis链路(时隙)物理故障恢复
';
--Table:
tb_func
--DROPTABLEtb_func;
CREATETABLEtb_func
(
funcidbigintNOTNULL,
funcdesc_encharactervaryingNOTNULL,
funcdesc_zhcharactervaryingNOTNULL,
parentidbigintNOTNULL,
isleafintNOTNULLDEFAULT0,
funcurlcharactervaryingNOTNULL,
CONSTRAINTtb_func_pkeyPRIMARYKEY(funcid)
)
WITH(
OIDS=FALSE
);
ALTERTABLEtb_func
OWNERTOpostgres;
insertintotb_func(funcid,funcdesc_en,funcdesc_zh,parentid,isleaf,funcurl)values(1,'AccountManagement','用户管理',0,1,'user.jsp');
insertintotb_func(funcid,funcdesc_en,funcdesc_zh,parentid,isleaf,funcurl)values(3,'SystemConfiguration','系统配置',0,1,'sysconfig.jsp');
in
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PostgreSQL 安装 指南