Zabbix + CentOS + PostgreSQL не коннектится Веб к БД.

[Dev_LC]

Доброго времени суток.

Не получается соединиться с базой данных Postgress во время настройки Вэб интерфейса. Error connecting to database.

Please create database manually,
and set the configuration parameters for connection to this database.

Press "Test connection" button when done.

Type PostgreSQL
Host localhost
Port 5432
Name zabbix
User zabuser
Password *****

Test = fail.


хотя телнетом я соединяюсь по порту без проблем. сам сервер в логах вроде тоже проблем не пишет.
psql -U zabuser zabbix - после ввода пароля в базу попадаю.
также пробовал в настройках веба прописать пользователя рута БД (postgres) и его пароль - также fail.
В чем может быть дело ?

[dima_dm]

базу создали?
http://www.zabbix.com/documentation/...on_from_source
Для PostgreSQL:
shell> psql -U <username>
psql> create database zabbix;
psql> \q
shell> cd create/schema
shell> cat postgresql.sql | psql -U <username> zabbix
shell> cd ../data
shell> cat data.sql | psql -U <username> zabbix
shell> cat images_pgsql.sql | psql -U <username> zabbix

[Dev_LC]

базу создали?
http://www.zabbix.com/documentation/...on_from_source
Для PostgreSQL:
shell> psql -U <username>
psql> create database zabbix;
psql> \q
shell> cd create/schema
shell> cat postgresql.sql | psql -U <username> zabbix
shell> cd ../data
shell> cat data.sql | psql -U <username> zabbix
shell> cat images_pgsql.sql | psql -U <username> zabbix

да, базу сделал. все вроде без ошибок прошло. в случае с FreeBSD + MySQL проблем совсем не возникало.
Из-за предполагаемых больших размеров базы решили выбрать centos+postgres

[Dev_LC]

....
WARNING: nonstandard use of \\ in a string literal at character 64
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 68
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 68
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 71
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 80
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 81
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 84
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.


вот это в логе /var/lib/pgsql/data/pg_log/postgresql-Fri.log
после добавления базы скриптами. Насколько нормально - незнаю.

[ugh]

Из-за предполагаемых больших размеров базы решили выбрать centos+postgres

если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?

[Dev_LC]

если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?

postgres может держать в себе больший объем данных по сравнению с сикуэлом и не захлебываться. на счет линукса - вычитал на форумах что фря+забикс бывает беспричинно вываливается, так что заодно и линукс переставил.

[Dev_LC]

Вот список всех проинсталленых пакетов

Installed Packages
Deployment_Guide-ru-RU.noarch 5.2-11.el5.centos installed
GConf2.i386 2.14.0-9.el5 installed
MAKEDEV.i386 3.23-1.2 installed
NetworkManager.i386 1:0.7.0-10.el5_5.2 installed
NetworkManager-glib.i386 1:0.7.0-10.el5_5.2 installed
ORBit2.i386 2.14.3-5.el5 installed
OpenIPMI-libs.i386 2.0.16-7.el5 installed
SysVinit.i386 2.86-15.el5 installed
acl.i386 2.2.39-6.el5 installed
acpid.i386 1.0.4-9.el5_4.2 installed
amtu.i386 1.0.6-1.el5 installed
anacron.i386 2.3-45.el5.centos installed
apmd.i386 1:3.2.2-5 installed
apr.i386 1.2.7-11.el5_5.3 installed
apr-util.i386 1.2.7-11.el5_5.2 installed
aspell.i386 12:0.60.3-7.1 installed
aspell-en.i386 50:6.0-2.1 installed
aspell-ru.i386 50:0.99f7-2.2.2 installed
at.i386 3.1.8-84.el5 installed
atk.i386 1.12.2-1.fc6 installed
attr.i386 2.4.32-1.1 installed
audit.i386 1.7.17-3.el5 installed
audit-libs.i386 1.7.17-3.el5 installed
audit-libs-python.i386 1.7.17-3.el5 installed
authconfig.i386 5.3.21-6.el5 installed
autofs.i386 1:5.0.1-0.rc2.143.el5_5.6 installed
avahi.i386 0.6.16-9.el5_5 installed
avahi-compat-libdns_sd.i386 0.6.16-9.el5_5 installed
basesystem.noarch 8.0-5.1.1.el5.centos installed
bash.i386 3.2-24.el5 installed
bc.i386 1.06-21 installed
bind-libs.i386 30:9.3.6-4.P1.el5_5.3 installed
bind-utils.i386 30:9.3.6-4.P1.el5_5.3 installed
binutils.i386 2.17.50.0.6-14.el5 installed
bitstream-vera-fonts.noarch 1.10-7 installed
bluez-gnome.i386 0.5-5.fc6 installed
bluez-libs.i386 3.7-1.1 installed
bluez-utils.i386 3.7-2.2.el5.centos installed
bzip2.i386 1.0.3-6.el5_5 installed
bzip2-libs.i386 1.0.3-6.el5_5 installed
cadaver.i386 0.22.3-4.el5 installed
cairo.i386 1.2.4-5.el5 installed
ccid.i386 1.3.8-1.el5 installed
centnixtime-release.noarch 5-5.el5 installed
centos-release.i386 10:5-5.el5.centos installed
centos-release-notes.i386 5.5-0 installed
checkpolicy.i386 1.33.1-6.el5 installed
chkconfig.i386 1.3.30.2-2.el5 installed
chkfontpath.i386 1.10.1-1.1 installed
conman.i386 0.1.9.2-8.el5 installed
coolkey.i386 1.1.0-14.el5 installed
coreutils.i386 5.97-23.el5_4.2 installed
cpio.i386 2.6-23.el5_4.1 installed
cpuspeed.i386 1:1.2.1-9.el5 installed
cracklib.i386 2.8.9-3.3 installed
cracklib-dicts.i386 2.8.9-3.3 installed
crash.i386 4.1.2-4.el5.centos.1 installed
crontabs.noarch 1.10-8 installed
cryptsetup-luks.i386 1.0.3-5.el5 installed
cups.i386 1:1.3.7-18.el5_5.8 installed
cups-libs.i386 1:1.3.7-18.el5_5.8 installed
curl.i386 7.15.5-9.el5 installed
cyrus-sasl.i386 2.1.22-5.el5_4.3 installed
cyrus-sasl-lib.i386 2.1.22-5.el5_4.3 installed
cyrus-sasl-plain.i386 2.1.22-5.el5_4.3 installed
db4.i386 4.3.29-10.el5_5.2 installed
dbus.i386 1.1.2-14.el5 installed
dbus-glib.i386 0.73-10.el5_5 installed
dbus-libs.i386 1.1.2-14.el5 installed
dbus-python.i386 0.70-9.el5_4 installed
desktop-file-utils.i386 0.10-7 installed
device-mapper.i386 1.02.39-1.el5_5.2 installed
device-mapper-event.i386 1.02.39-1.el5_5.2 installed
device-mapper-multipath.i386 0.4.7-34.el5_5.6 installed
dhclient.i386 12:3.0.5-23.el5_5.2 installed
dhcpv6-client.i386 1.0.10-18.el5 installed
diffutils.i386 2.8.1-15.2.3.el5 installed
dmidecode.i386 1:2.10-3.el5 installed
dmraid.i386 1.0.0.rc13-63.el5 installed
dmraid-events.i386 1.0.0.rc13-63.el5 installed
dnsmasq.i386 2.45-1.1.el5_3 installed
dos2unix.i386 3.1-27.2.el5 installed
dosfstools.i386 2.11-9.el5 installed
dump.i386 0.4b41-4.el5 installed
e2fsprogs.i386 1.39-23.el5_5.1 installed
e2fsprogs-libs.i386 1.39-23.el5_5.1 installed
ecryptfs-utils.i386 75-5.el5 installed
ed.i386 0.2-39.el5_2 installed
eject.i386 2.1.5-4.2.el5 installed
elfutils-libelf.i386 0.137-3.el5 installed
elinks.i386 0.11.1-6.el5_4.1 installed
epel-release.noarch 5-4 installed
ethtool.i386 6-4.el5 installed
expat.i386 1.95.8-8.3.el5_5.3 installed
fbset.i386 2.1-22 installed
fetchmail.i386 6.3.6-1.1.el5_3.1 installed
file.i386 4.17-15.el5_3.1 installed
filesystem.i386 2.4.0-3.el5 installed
findutils.i386 1:4.2.27-6.el5 installed
finger.i386 0.17-32.2.1.1 installed
fipscheck.i386 1.2.0-1.el5 installed
fipscheck-lib.i386 1.2.0-1.el5 installed
firstboot-tui.i386 1.4.27.8-1.el5.centos installed
fontconfig.i386 2.4.1-7.el5 installed
fonts-KOI8-R.noarch 1.0-9.1.1 installed
fonts-KOI8-R-100dpi.noarch 1.0-9.1.1 installed
fonts-KOI8-R-75dpi.noarch 1.0-9.1.1 installed
fping.i386 2.4-1.b2.2.el5.rf installed
freetype.i386 2.2.1-28.el5_5.1 installed
ftp.i386 0.17-35.el5 installed
gamin.i386 0.1.7-8.el5 installed
gamin-python.i386 0.1.7-8.el5 installed
gawk.i386 3.1.5-14.el5 installed
gdbm.i386 1.8.0-26.2.1 installed
gettext.i386 0.14.6-4.el5 installed
glib2.i386 2.12.3-4.el5_3.1 installed
glibc.i686 2.5-49.el5_5.7 installed
glibc-common.i386 2.5-49.el5_5.7 installed
gmp.i386 4.1.4-10.el5 installed
gnu-efi.i386 3.0c-1.1 installed
gnupg.i386 1.4.5-14.el5_5.1 installed
gnutls.i386 1.4.1-3.el5_4.8 installed
gpm.i386 1.20.1-74.1 installed
grep.i386 2.5.1-55.el5 installed
groff.i386 1.18.1.1-11.1 installed
grub.i386 0.97-13.5 installed
gtk2.i386 2.10.4-21.el5_5.6 installed
gzip.i386 1.3.5-11.el5.centos.1 installed
hal.i386 0.5.8.1-59.el5 installed
hdparm.i386 6.6-2 installed
hesiod.i386 3.1.0-8 installed
hicolor-icon-theme.noarch 0.9-2.1 installed
hmaccalc.i386 0.9.6-3.el5 installed
htmlview.noarch 4.0.0-2.el5 installed
httpd.i386 2.2.3-43.el5.centos.3 installed
hwdata.noarch 0.213.18-1.el5.1 installed
ibmasm.i386 3.0-9 installed
ifd-egate.i386 0.05-15 installed
iksemel.i386 1.2-14.el5 installed
info.i386 4.8-14.el5 installed
initscripts.i386 8.45.30-3.el5.centos installed
iproute.i386 2.6.18-11.el5 installed
ipsec-tools.i386 0.6.5-14.el5_5.5 installed
iptables.i386 1.3.5-5.3.el5_4.1 installed
iptables-ipv6.i386 1.3.5-5.3.el5_4.1 installed
iptstate.i386 1.4-2.el5 installed
iputils.i386 20020927-46.el5 installed
irda-utils.i386 0.9.17-2.fc6 installed
irqbalance.i386 2:0.55-15.el5 installed
isdn4k-utils.i386 3.2-56.el5 installed
jwhois.i386 3.2.3-8.el5 installed
kbd.i386 1.12-21.el5 installed
kernel.i686 2.6.18-194.el5 installed
kernel.i686 2.6.18-194.32.1.el5 installed
keyutils.i386 1.2-1.el5 installed
keyutils-libs.i386 1.2-1.el5 installed
kpartx.i386 0.4.7-34.el5_5.6 installed
krb5-libs.i386 1.6.1-36.el5_5.6 installed
krb5-workstation.i386 1.6.1-36.el5_5.6 installed
ksh.i386 20100202-1.el5_5.1 installed
kudzu.i386 1.2.57.1.24-1.el5.centos installed
less.i386 436-2.el5 installed
lftp.i386 3.7.11-4.el5_5.3 installed
libFS.i386 1.0.0-3.1 installed
libICE.i386 1.0.1-2.1 installed
libIDL.i386 0.8.7-1.fc6 installed
libSM.i386 1.0.1-3.1 installed
libX11.i386 1.0.3-11.el5 installed
libXau.i386 1.0.1-3.1 installed
libXaw.i386 1.0.2-8.1 installed
libXcursor.i386 1.1.7-1.1 installed
libXdmcp.i386 1.0.1-2.1 installed
libXext.i386 1.0.1-2.1 installed
libXfixes.i386 4.0.1-2.1 installed
libXfont.i386 1.2.2-1.0.3.el5_1 installed
libXft.i386 2.1.10-1.1 installed
libXi.i386 1.0.1-4.el5_4 installed
libXinerama.i386 1.0.1-2.1 installed
libXmu.i386 1.0.2-5 installed
libXpm.i386 3.5.5-3 installed
libXrandr.i386 1.1.1-3.3 installed
libXrender.i386 0.9.1-3.1 installed
libXres.i386 1.0.1-3.1 installed
libXt.i386 1.0.2-3.2.el5 installed
libXxf86vm.i386 1.0.1-3.1 installed
libacl.i386 2.2.39-6.el5 installed
libaio.i386 0.3.106-5 installed
libattr.i386 2.4.32-1.1 installed
libcap.i386 1.10-26 installed
libdaemon.i386 0.10-5.el5 installed
libdrm.i386 2.0.2-1.1 installed
libedit.i386 2.11-2.20080712cvs.el5 installed
libevent.i386 1.4.13-1 installed
libfontenc.i386 1.0.2-2.2.el5 installed
libgcc.i386 4.1.2-48.el5 installed
libgcrypt.i386 1.4.4-5.el5 installed
libgpg-error.i386 1.4-2 installed
libgssapi.i386 0.10-2 installed
libhugetlbfs.i386 1.3-7.el5 installed
libidn.i386 0.6.5-1.1 installed
libjpeg.i386 6b-37 installed
libnotify.i386 0.4.2-6.el5 installed
libpcap.i386 14:0.9.4-15.el5 installed
libpng.i386 2:1.2.10-7.1.el5_5.3 installed
libselinux.i386 1.33.4-5.5.el5 installed
libselinux-python.i386 1.33.4-5.5.el5 installed
libselinux-utils.i386 1.33.4-5.5.el5 installed
libsemanage.i386 1.9.1-4.4.el5 installed
libsepol.i386 1.15.2-3.el5 installed
libstdc++.i386 4.1.2-48.el5 installed
libsysfs.i386 2.0.0-6 installed
libtermcap.i386 2.0.8-46.1 installed
libtiff.i386 3.8.2-7.el5_5.5 installed
libusb.i386 0.1.12-5.1 installed
libuser.i386 0.54.7-2.1.el5_4.1 installed
libutempter.i386 1.1.4-4.el5 installed
libvolume_id.i386 095-14.21.el5_5.1 installed
libwnck.i386 2.16.0-4.fc6 installed
libwvstreams.i386 4.2.2-2.1 installed
libxml2.i386 2.6.26-2.1.2.8.el5_5.1 installed
libxml2-python.i386 2.6.26-2.1.2.8.el5_5.1 installed
libxslt.i386 1.1.17-2.el5_2.2 installed
lm_sensors.i386 2.10.7-9.el5 installed
lockdev.i386 1.0.1-10 installed
logrotate.i386 3.7.4-9.el5_5.2 installed
logwatch.noarch 7.3-8.el5 installed
lrzsz.i386 0.12.20-22.1 installed
lsof.i386 4.78-3 installed
lvm2.i386 2.02.56-8.el5_5.6 installed
m2crypto.i386 0.16-6.el5.6 installed
m4.i386 1.4.5-3.el5.1 installed
mailcap.noarch 2.1.23-1.fc6 installed
mailx.i386 8.1.1-44.2.2 installed
make.i386 1:3.81-3.el5 installed
man.i386 1.6d-1.1 installed
man-pages.noarch 2.39-15.el5_4 installed
man-pages-ru.noarch 0.97-1.1.1 installed
mcstrans.i386 0.2.11-3.el5 installed
mdadm.i386 2.6.9-3.el5 installed
mesa-libGL.i386 6.5.1-7.8.el5 installed
mgetty.i386 1.1.33-9.fc6 installed
microcode_ctl.i386 1:1.17-1.50.el5 installed
mingetty.i386 1.07-5.2.2 installed
minicom.i386 2.1-3 installed
mkbootdisk.i386 1.5.3-2.1 installed
mkinitrd.i386 5.1.19.6-61.el5_5.2 installed
mktemp.i386 3:1.5-23.2.2 installed
mlocate.i386 0.15-1.el5.2 installed
module-init-tools.i386 3.3-0.pre3.1.60.el5_5.1 installed
mtools.i386 3.9.10-2.fc6 installed
mtr.i386 2:0.71-3.1 installed
mutt.i386 5:1.4.2.2-3.0.2.el5 installed
nano.i386 1.3.12-1.1 installed
nash.i386 5.1.19.6-61.el5_5.2 installed
nc.i386 1.84-10.fc6 installed
ncurses.i386 5.5-24.20060715 installed
neon.i386 0.25.5-10.el5_4.1 installed
net-snmp.i386 1:5.3.2.2-9.el5_5.1 installed
net-snmp-libs.i386 1:5.3.2.2-9.el5_5.1 installed
net-tools.i386 1.60-81.el5 installed
newt.i386 0.52.2-15.el5 installed
nfs-utils.i386 1:1.0.9-47.el5_5 installed
nfs-utils-lib.i386 1.0.8-7.6.el5 installed
notification-daemon.i386 0.3.5-9.el5 installed
nscd.i386 2.5-49.el5_5.7 installed
nspr.i386 4.8.6-1.el5_5 installed
nss.i386 3.12.8-1.el5.centos installed
nss-tools.i386 3.12.8-1.el5.centos installed
nss_db.i386 2.2-35.4.el5_5 installed
nss_ldap.i386 253-25.el5 installed
ntsysv.i386 1.3.30.2-2.el5 installed
numactl.i386 0.9.8-11.el5 installed
oddjob.i386 0.27-9.el5 installed
oddjob-libs.i386 0.27-9.el5 installed
openldap.i386 2.3.43-12.el5_5.3 installed
openssh.i386 4.3p2-41.el5_5.1 installed
openssh-clients.i386 4.3p2-41.el5_5.1 installed
openssh-server.i386 4.3p2-41.el5_5.1 installed
openssl.i686 0.9.8e-12.el5_5.7 installed
pam.i386 0.99.6.2-6.el5_5.2 installed
pam_ccreds.i386 3-5 installed
pam_krb5.i386 2.2.14-15 installed
pam_passwdqc.i386 1.0.2-1.2.2 installed
pam_pkcs11.i386 0.5.3-23 installed
pam_smb.i386 1.1.7-7.2.1 installed
pango.i386 1.14.9-8.el5.centos installed
paps.i386 0.6.6-19.el5 installed
parted.i386 1.8.1-27.el5 installed
passwd.i386 0.73-1 installed
patch.i386 2.5.4-29.2.3.el5 installed
pax.i386 3.4-2.el5_4 installed
pciutils.i386 2.2.3-8.el5_4 installed
pcmciautils.i386 014-5 installed
pcre.i386 6.6-2.el5_1.7 installed
pcsc-lite.i386 1.4.4-4.el5_5 installed
pcsc-lite-libs.i386 1.4.4-4.el5_5 installed
perl.i386 4:5.8.8-32.el5_5.2 installed
perl-String-CRC32.i386 1.4-2.fc6 installed
php.i386 5.3.5-1.el5.remi.1 installed
php-bcmath.i386 5.3.5-1.el5.remi.1 installed
php-cli.i386 5.3.5-1.el5.remi.1 installed
php-common.i386 5.3.5-1.el5.remi.1 installed
php-gd.i386 5.3.5-1.el5.remi.1 installed
php-mbstring.i386 5.3.5-1.el5.remi.1 installed
php-pdo.i386 5.3.5-1.el5.remi.1 installed
php-pgsql.i386 5.3.5-1.el5.remi.1 installed
php-xml.i386 5.3.5-1.el5.remi.1 installed
pinfo.i386 0.6.9-1.fc6 installed
pkinit-nss.i386 0.7.6-1.el5 installed
pm-utils.i386 0.99.3-10.el5.centos installed
policycoreutils.i386 1.33.12-14.8.el5 installed
poppler.i386 0.5.4-4.4.el5_5.14 installed
poppler-utils.i386 0.5.4-4.4.el5_5.14 installed
popt.i386 1.10.2.3-20.el5_5.1 installed
portmap.i386 4.0-65.2.2.1 installed
postgresql-libs.i386 8.1.22-1.el5_5.1 installed
postgresql84.i386 8.4.5-1.el5_5.1 installed
postgresql84-contrib.i386 8.4.5-1.el5_5.1 installed
postgresql84-devel.i386 8.4.5-1.el5_5.1 installed
postgresql84-libs.i386 8.4.5-1.el5_5.1 installed
postgresql84-server.i386 8.4.5-1.el5_5.1 installed
ppp.i386 2.4.4-2.el5 installed
prelink.i386 0.4.0-2.el5 installed
procmail.i386 3.22-17.1.el5.centos installed
procps.i386 3.2.7-16.el5 installed
psacct.i386 6.3.2-44.el5 installed
psmisc.i386 22.2-7 installed
pygobject2.i386 2.12.1-5.el5 installed
python.i386 2.4.3-27.el5_5.3 installed
python-elementtree.i386 1.2.6-5 installed
python-iniparse.noarch 0.2.3-4.el5 installed
python-sqlite.i386 1.1.7-1.2.1 installed
python-urlgrabber.noarch 3.1.0-5.el5 installed
quota.i386 1:3.13-1.2.5.el5 installed
rdate.i386 1.4-8.el5 installed
rdist.i386 1:6.1.5-44 installed
readahead.i386 1:1.3-8.el5 installed
readline.i386 5.1-3.el5 installed
redhat-logos.noarch 4.9.99-11.el5.centos installed
redhat-lsb.i386 3.1-12.3.EL.el5.centos installed
redhat-menus.noarch 6.7.8-3.el5 installed
remi-release.noarch 5-8.el5.remi installed
rhpl.i386 0.194.1-1 installed
rmt.i386 0.4b41-4.el5 installed
rng-utils.i386 1:2.0-1.14.1.fc6 installed
rootfiles.noarch 8.1-1.1.1 installed
rp-pppoe.i386 3.5-32.1 installed
rpm.i386 4.4.2.3-20.el5_5.1 installed
rpm-libs.i386 4.4.2.3-20.el5_5.1 installed
rpm-python.i386 4.4.2.3-20.el5_5.1 installed
rsh.i386 0.17-40.el5 installed
rsync.i386 2.6.8-3.1 installed
sed.i386 4.1.5-5.fc6 installed
selinux-policy.noarch 2.4.6-279.el5_5.2 installed
selinux-policy-targeted.noarch 2.4.6-279.el5_5.2 installed
sendmail.i386 8.13.8-8.el5 installed
setarch.i386 2.0-1.1 installed
setools.i386 3.0-3.el5 installed
setserial.i386 2.17-19.2.2 installed
setup.noarch 2.5.58-7.el5 installed
setuptool.i386 1.19.2-1.el5.centos installed
sgpio.i386 1.2.0_10-2.el5 installed
shadow-utils.i386 2:4.0.17-15.el5 installed
slang.i386 2.0.6-4.el5 installed
slrn.i386 0.9.8.1pl1-1.2.2 installed
smartmontools.i386 1:5.38-2.el5 installed
sos.noarch 1.7-9.49.el5 installed
specspo.noarch 13-1.el5.centos installed
sqlite.i386 3.3.6-5 installed
startup-notification.i386 0.8-4.1 installed
stunnel.i386 4.15-2.el5.1 installed
sudo.i386 1.7.2p1-9.el5_5 installed
symlinks.i386 1.2-24.2.2 installed
sysfsutils.i386 2.0.0-6 installed
sysklogd.i386 1.4.1-46.el5 installed
syslinux.i386 3.11-4 installed
system-config-network-tui.noarch 1.3.99.18-1.el5 installed
system-config-securitylevel-tui.i386 1.6.29.1-5.el5 installed
t1lib.i386 5.1.1-7.el5 installed
talk.i386 0.17-29.2.2 installed
tar.i386 2:1.15.1-30.el5 installed
tcl.i386 8.4.13-4.el5 installed
tcp_wrappers.i386 7.6-40.7.el5 installed
tcpdump.i386 14:3.9.4-15.el5 installed
tcsh.i386 6.14-17.el5_5.2 installed
telnet.i386 1:0.17-39.el5 installed
termcap.noarch 1:5.5-1.20060701.1 installed
time.i386 1.7-27.2.2 installed
tmpwatch.i386 2.9.7-1.1.el5.2 installed
traceroute.i386 3:2.0.1-5.el5 installed
tree.i386 1.5.0-4 installed
trousers.i386 0.3.1-4.el5 installed
ttmkfdir.i386 3.0.9-23.el5 installed
tzdata.i386 2010l-1.el5 installed
udev.i386 095-14.21.el5_5.1 installed
udftools.i386 1.0.0b3-0.1.el5 installed
unix2dos.i386 2.2-26.2.3.el5 installed
unixODBC.i386 2.2.11-7.1 installed
unzip.i386 5.52-3.el5 installed
usbutils.i386 0.71-2.1 installed
usermode.i386 1.88-3.el5.2 installed
util-linux.i386 2.13-0.52.el5_4.1 installed
vconfig.i386 1.9-3 installed
vim-common.i386 2:7.0.109-6.el5 installed
vim-enhanced.i386 2:7.0.109-6.el5 installed
vim-minimal.i386 2:7.0.109-6.el5 installed
vixie-cron.i386 4:4.1-77.el5_4.1 installed
wget.i386 1.11.4-2.el5_4.1 installed
which.i386 2.16-7 installed
wireless-tools.i386 1:28-2.el5 installed
words.noarch 3.0-9.1 installed
wpa_supplicant.i386 1:0.5.10-9.el5 installed
wvdial.i386 1.54.0-5.2.2.1 installed
xorg-x11-filesystem.noarch 7.1-2.fc6 installed
xorg-x11-font-utils.i386 1:7.1-2 installed
xorg-x11-xfs.i386 1:1.0.2-4 installed
yp-tools.i386 2.9-1.el5 installed
ypbind.i386 3:1.19-12.el5 installed
yum.noarch 3.2.22-26.el5.centos installed
yum-fastestmirror.noarch 1.1.16-14.el5.centos.1 installed
yum-metadata-parser.i386 1.1.2-3.el5.centos installed
yum-updatesd.noarch 1:0.9-2.el5 installed
zabbix.i386 1.8.3-1.el5 installed
zabbix-agent.i386 1.8.3-1.el5 installed
zabbix-server-pgsql.i386 1.8.3-1.el5 installed
zabbix-web.i386 1.8.3-1.el5 installed
zip.i386 2.31-2.el5 installed
zlib.i386 1.2.3-3 installed
zsh.i386 4.2.6-3.el5 installed

[costas]

если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?

mysql vs postgresql - для zabbix скорее всего эффект однозначный - там где mysql не справляется с нагрузкой postgresql спокойно работает, ну а если на mysql работает то разницы никакой нет, по части ОСь (*BSD или linux) - это регламентировано либо инфраструктурой компании либо скилами админа, для больших компаний обычно не характерно держать зоопарк из ОСь.

З.Ы. для провайдерского уровня *BSD стандарт де факто, на практике - кто во что горазд

[ugh]

хех)
читаю интернеты и прям все так хорошо у постргеса )))
буду пробовать чтоле )

пысы: 2,2 миллиарда строк в хистори_уинт )

[mkolomiets]

Привет!

....
WARNING: nonstandard use of \\ in a string literal at character 64
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 68
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.


вот это в логе /var/lib/pgsql/data/pg_log/postgresql-Fri.log
после добавления базы скриптами. Насколько нормально - незнаю.

На эти сообщения можно не обращать внимания.

А относительно ошибки подключения к БД из ВЕБ-морды проверьте: наличие пакета php-pgsql, что бы было разрешение на подключение в pg_hba.conf и что бы правильно резолвилось имя хоста БД если задаете именем.

Тестируете не "psql -U zabuser zabbix" а "psql -h localhost -U zabuser zabbix" что бы точно знать что подключаетесь через TCP.

ЗЫ. В логах постгреса должны быть ошибки подключения.

[Dev_LC]

Привет!

На эти сообщения можно не обращать внимания.

А относительно ошибки подключения к БД из ВЕБ-морды проверьте: наличие пакета php-pgsql, что бы было разрешение на подключение в pg_hba.conf и что бы правильно резолвилось имя хоста БД если задаете именем.

Тестируете не "psql -U zabuser zabbix" а "psql -h localhost -U zabuser zabbix" что бы точно знать что подключаетесь через TCP.

ЗЫ. В логах постгреса должны быть ошибки подключения.

Спасибо за ответ.
Попробовать не могу - переставил уже все на Debian. Разнес на два сервера Debian+Zabbix+PosgreSQL на один и FreeBSD-Web-Frontend на другой.
Все завелось без особых проблем. Что-то на центосе пошло не так