Data Base Error

[mobiledataforce]

I now have this issue after a reboot.

Code: Select all

[root@nagios ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      9.5G  4.3G  4.8G  47% /
tmpfs                 504M     0  504M   0% /dev/shm
/dev/sda1              97M   21M   72M  23% /boot
[root@nagios ~]# df -i
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      632736  173413  459323   28% /
tmpfs                 128850       1  128849    1% /dev/shm
/dev/sda1              25688      38   25650    1% /boot
[root@nagios ~]# service postgresql start
Starting postgresql service:                               [FAILED]
[root@nagios ~]# getenforce
Disabled

EDIT: I reverted to the snapshot I took prior so this is no longer an issue for now. This arose trying to get my hostname set in all the proper places. I got it to where I was seeing the desired outputs outlined here: http://cbl.abuseat.org/hostname.html but caused the DB connection error.

[slansing]

Hmm, even though it is working now, I would recommend running a vacuum on the database:

Code: Select all

    psql nagiosxi nagiosxi

If so, run

Code: Select all

    VACUUM ANALYZE;

If no errors (warnings are ok) run

Code: Select all

    VACUUM FULL;

[mobiledataforce]

I can't seem to get the commands to go through.
ADDED VACUUM FULL; OUTPUT

Code: Select all

[root@localhost ~]# psql nagiosxi nagiosxi
psql (8.4.12)
Type "help" for help.

nagiosxi=> VACUUM ANALYZE;
WARNING:  skipping "pg_database" --- only superuser can vacuum it
WARNING:  skipping "pg_authid" --- only superuser can vacuum it
WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
VACUUM
nagiosxi=> su
nagiosxi-> VACUUM ANALYZE;
ERROR:  syntax error at or near "su"
LINE 1: su
        ^
nagiosxi=> VACUUM FULL;
WARNING:  skipping "pg_database" --- only superuser can vacuum it
WARNING:  skipping "pg_authid" --- only superuser can vacuum it
WARNING:  skipping "pg_tablespace" --- only superuser can vacuum it
WARNING:  skipping "pg_pltemplate" --- only superuser can vacuum it
WARNING:  skipping "pg_shdepend" --- only superuser can vacuum it
WARNING:  skipping "pg_shdescription" --- only superuser can vacuum it
WARNING:  skipping "pg_auth_members" --- only superuser can vacuum it
VACUUM

[abrist]

The "skipping" errors are WAI. They can be ignored. Just proceed with the rest of the commands for the full vacuum.