如何查看 zabbix-server-pgsql 版本

查看服务器RAID信息，硬盘是否正常。

[root@monitor~]# hpacucli ctrl all show config

Smart Array P410i in Slot 0 (Embedded)(sn: 5001438018042FF0)

array A (SAS, Unused Space: 0 MB)

logicaldrive 1 (279.4 GB, RAID 1, OK)

physicaldrive 1I:1:1 (port 1I:box 1:bay 1, SAS, 300 GB, OK)

physicaldrive 1I:1:2 (port 1I:box 1:bay 2, SAS, 300 GB, OK)

3)通过hpacucli ctrl all show config detail命令可以详细地查看RAID和硬盘的信息。

[root@monitor ~]# hpacucli ctrl all show config detail

Smart Array P410i in Slot 0 (Embedded)

Bus Interface: PCI

Slot: 0

Serial Number: 5001438018042FF0

Cache Serial Number: PBCDH0CRH1FH62

RAID 6 (ADG) Status: Disabled

Controller Status: OK

Chassis Slot:

Hardware Revision: Rev C

Firmware Version: 5.14

Rebuild Priority: Medium

Expand Priority: Medium

Surface Scan Delay: 15 secs

Monitor and Performance Delay: 60 min

Elevator Sort: Enabled

Degraded Performance Optimization: Disabled

Inconsistency Repair Policy: Disabled

Post Prompt Timeout: 0 secs

Cache Board Present: True

Cache Status: OK

Accelerator Ratio: 25% Read / 75% Write

Drive Write Cache: Disabled

Total Cache Size: 512 MB

No-Battery Write Cache: Disabled

Cache Backup Power Source: Capacitors

Battery/Capacitor Count: 1

Battery/Capacitor Status: OK

SATA NCQ Supported: True

Array: A

Interface Type: SAS

Unused Space: 0 MB

Status: OK

Logical Drive: 1

Size: 279.4 GB

Fault Tolerance: RAID 1

Heads: 255

Sectors Per Track: 32

Cylinders: 65535

Stripe Size: 128 KB

Status: OK

Array Accelerator: Enabled

Unique Identifier: 600508B1001034373220202020200002

Disk Name: /dev/cciss/c0d0

Mount Points: /boot 99 MB

Logical Drive Label: A00ADBD9PR7AMU1472 898D

Mirror Group 0:

physicaldrive 1I:1:1 (port 1I:box 1:bay 1, SAS, 300 GB, OK)

Mirror Group 1:

physicaldrive 1I:1:2 (port 1I:box 1:bay 2, SAS, 300 GB, OK)

physicaldrive 1I:1:1

Port: 1I

Box: 1

Bay: 1

Status: OK

Drive Type: Data Drive

Interface Type: SAS

Size: 300 GB

Rotational Speed: 10000

Firmware Revision: HPD4

Serial Number: ECA1PC80GTS31234

Model: HP EG0300FBDSP

PHY Count: 2

PHY Transfer Rate: 6.0GBPS, Unknown

physicaldrive 1I:1:2

Port: 1I

Box: 1

Bay: 2

Status: OK

Drive Type: Data Drive

Interface Type: SAS

Size: 300 GB

Rotational Speed: 10000

Firmware Revision: HPD7

Serial Number: PMX6902D

Model: HP EG0300FBDBR

PHY Count: 2

PHY Transfer Rate: 6.0GBPS, Unknown

HP官方还有一个hpasmcli管理工具，可以很详细查看服务器CPU，内存，处理器，电源等的温度信息。

在已经安装了PostgreSQL的Linux上，使用下面的命令即可查询安装的版本：

psql --version

PostgreSQL是以加州大学伯克利分校计算机系开发的 POSTGRES，现在已经更名为PostgreSQL，版本 4.2为基础的对象关系型数据库管理系统（ORDBMS）。PostgreSQL支持大部分 SQL标准并且提供了许多其他现代特性：复杂查询、外键、触发器、视图、事务完整性、MVCC。同样，PostgreSQL 可以用许多方法扩展，比如， 通过增加新的数据类型、函数、 *** 作符、聚集函数、索引。免费使用、修改、和分发 PostgreSQL，不管是私用、商用、还是学术研究使用。

---