Boxinfo

Last updated: 2017-11-10

This is a sample output of the boxinfo program. Some sections were left out to make the page smaller and more readable.

[ACME](/ACME) Postgres server core:

Date gathered: Mon Nov 14 12:21:00 EST 2011
Program version: 1.3.5
Hostname: core
OS: linux
CPU: 2 x Intel(R) Core(TM)2 Duo CPU T6400 @ 2.00GHz (1200 MHz)
RAM: 2.95 GB
VM: No
Uptime: 1 day
Users: 7
Load average: 1.08
Fedora release: Fedora release 11 (Leonidas)
Kernel info:
Kernel name: Linux
Kernel release: 2.6.30.10-105.fc11.i586
Kernel version: \#1 SMP Thu Dec 24 16:26:26 UTC 2009
Hardware name: i686
Processor: i686
Hardware platform: i386
Memory:
shmmax: 32 MB
shmmni: 4096
shmall: 2 MB
swappiness: 40
Free: 563.21 MB
Cached: 1.28 GB
Active: 1.41 GB
Swap Total: 0 bytes
Active shared mem:
Active segments: 24 Active semaphores: 31 Active messages: 0
Interfaces:
Name IP Status Speed Notes
tun0 192.168.255.240 Active 10Mb/s Full point to point
eth0 192.168.1.6 Active 100Mb/s Full
lo 127.0.0.1 Active N/A
tun1 10.201.1.176 Active 10Mb/s Full point to point
wlan0 N/A Inactive N/A
wmaster0 N/A Inactive N/A
Mounting info:
Name Mount Size/Used % Inode % Filesystem (options)
/dev/mapper/ luks-c8fa3e5a-c281-4331-b0d2-66afdeafdfe9 /data 50G/37% 8% ext3 (rw, noatime, nodiratime)
/dev/sda5 / 50G/22% 10% ext3 (rw, noatime, nodiratime)
/dev/sr0 /media/THIEF2_CD2 532M/100% - iso9660 (ro, nosuid, nodev, uhelper=devkit, uid=500, gid=500, iocharset=utf8, mode=0400, dmode=0500)
tmpfs /dev/shm 1.5G/1% 1% tmpfs (rw)
Kernel queue info:
Block Read ahead size Scheduler
sda 8192 KB noop anticipatory [deadline] cfq
sdb 8192 KB noop anticipatory [deadline] cfq
Program versions:
Name Version Name Version Name Version
autoconf 2.63 awk 3.1.6a bash 4.0.23(1)-release
bzip2 1.0.5 cc 4.4.1 chkconfig 1.3.42
convert 6.5.1-2 curl 7.19.7 cvs 1.11.23
elinks 0.12pre3 emacs 23.1.1 find 4.4.0
gcc 4.4.1 gdb 6.8.50.20090302-39.fc11 git 1.6.2.5
gnome-panel 2.26.3 gpg 2.0.12 gzip 1.3.12
iconv 2.10.2 initdb 8.5devel lighttpd 1.4.23
links 0.12pre3 make 3.81 mii-tool 1.9
mysql 5.1.41 (14.14) nano 2.0.6 ntpd 4.2.4p7
openssl 0.9.8k-fips perl 5.10.0 pg_config 8.5devel
pg_dump 8.5devel php 5.2.11 postgres 8.5devel
psql 8.5devel python 2.6 rcs 5.7
rrdtool 1.3.8 rsync 3.0.6 rsyslogd 3.22.1
ruby 1.8.6 screen 4.00.03 sed 4.2.1
sendmail 8.14.3 service 0.91 ssh 5.2p1
svn 1.6.6 vi 7.2 yum 3.2.24
zip 2.31
Perl info:
Version: 5.10.0
IThreads: Yes
Multiplicity: Yes
Perl modules:
Module Version
[DBD::Pg](http://search.cpan.org/dist/DBD-Pg) 2.15.1
[DBD::mysql](http://search.cpan.org/dist/DBD-mysql) 4.010
[DBI](http://search.cpan.org/dist/DBI) 1.611
[DBIx::Safe](http://search.cpan.org/dist/DBIx-Safe) 1.2.5
[Digest::MD5](http://search.cpan.org/dist/Digest-MD5) 2.36_01
[Mail::Sendmail](http://search.cpan.org/dist/Mail-Sendmail) 0.79
[Sys::Syslog](http://search.cpan.org/dist/Sys-Syslog) 0.27
[Time::HiRes](http://search.cpan.org/dist/Time-HiRes) 1.9719
[YAML](http://search.cpan.org/dist/YAML) 0.68
Active Postgres clusters:
Port Socket dir Version
5001 /tmp/ 8.5devel
5002 /tmp/ 8.5devel
5840 /tmp/ 8.4.1
6000 /tmp/ 8.5devel
Postgres config:
Cluster Config Value Source
5001 /tmp/ checkpoint_segments 3 Def
client_encoding UTF8 Def
config_file /data/greg/code/bucardo/m1/postgresql.conf Set
constraint_exclusion partition Def
data_directory /data/greg/code/bucardo/m1 Set
debug_pretty_print on Def
default_statistics_target 100 Def
effective_cache_size 16384 (128 MB) Def
hba_file /data/greg/code/bucardo/m1/pg_hba.conf Set
ident_file /data/greg/code/bucardo/m1/pg_ident.conf Set
integer_datetimes on Def
listen_addresses localhost Def
log_destination stderr Def
log_filename postgresql-%Y-%m-%d_%H%M%S.log Def
log_line_prefix %m %p Conf
log_min_duration_statement -1 (disabled) Def
log_statement all Conf
logging_collector off Def
maintenance_work_mem 16384 (16 MB) Def
max_connections 100 Conf
max_prepared_transactions 0 Def
port 5001 Conf
random_page_cost 4 Def
server_encoding UTF8 Set
shared_buffers 3584 (28 MB) Conf
syslog_facility local0 Def
vacuum_freeze_min_age 50000000 Def
wal_sync_method fdatasync Def
work_mem 1024 (1024 kB) Def
5002 /tmp/ checkpoint_segments 3 Def
client_encoding UTF8 Def
config_file /data/greg/code/bucardo/m2/postgresql.conf Set
constraint_exclusion partition Def
data_directory /data/greg/code/bucardo/m2 Set
debug_pretty_print on Def
default_statistics_target 100 Def
effective_cache_size 16384 (128 MB) Def
hba_file /data/greg/code/bucardo/m2/pg_hba.conf Set
ident_file /data/greg/code/bucardo/m2/pg_ident.conf Set
integer_datetimes on Def
listen_addresses localhost Def
log_destination stderr Def
log_filename postgresql-%Y-%m-%d_%H%M%S.log Def
log_min_duration_statement -1 (disabled) Def
logging_collector off Def
maintenance_work_mem 16384 (16 MB) Def
max_connections 100 Conf
max_prepared_transactions 0 Def
port 5002 Conf
random_page_cost 4 Def
server_encoding UTF8 Set
shared_buffers 3584 (28 MB) Conf
syslog_facility local0 Def
vacuum_freeze_min_age 50000000 Def
wal_sync_method fdatasync Def
work_mem 1024 (1024 kB) Def
5840 /tmp/ checkpoint_segments 3 Def
client_encoding UTF8 Def
config_file /home/greg/code/postgres/8.4/data/postgresql.conf Set
constraint_exclusion partition Def
data_directory /home/greg/code/postgres/8.4/data Set
debug_pretty_print on Def
default_statistics_target 100 Def
effective_cache_size 16384 (128 MB) Def
hba_file /home/greg/code/postgres/8.4/data/pg_hba.conf Set
ident_file /home/greg/code/postgres/8.4/data/pg_ident.conf Set
integer_datetimes on Def
listen_addresses localhost Def
log_destination stderr Def
log_filename postgresql-%Y-%m-%d_%H%M%S.log Def
log_min_duration_statement 0 (logs all durations) Conf
log_statement all Conf
logging_collector off Def
maintenance_work_mem 16384 (16 MB) Def
max_connections 30 Conf
max_prepared_transactions 10 Conf
max_stack_depth 5120 (5 MB) Conf
port 5840 Conf
random_page_cost 4 Def
server_encoding UTF8 Set
shared_buffers 3584 (28 MB) Conf
syslog_facility local0 Def
vacuum_freeze_min_age 50000000 Def
wal_sync_method fdatasync Def
work_mem 2048 (2 MB) Conf
6000 /tmp/ checkpoint_segments 3 Def
client_encoding UTF8 Def
config_file /data/greg/code/bucardo/slave/postgresql.conf Set
constraint_exclusion partition Def
data_directory /data/greg/code/bucardo/slave Set
debug_pretty_print on Def
default_statistics_target 100 Def
effective_cache_size 16384 (128 MB) Def
hba_file /data/greg/code/bucardo/slave/pg_hba.conf Set
ident_file /data/greg/code/bucardo/slave/pg_ident.conf Set
integer_datetimes on Def
listen_addresses localhost Def
log_destination stderr Def
log_filename postgresql-%Y-%m-%d_%H%M%S.log Def
log_line_prefix %m %p Conf
log_min_duration_statement -1 (disabled) Def
log_statement all Conf
logging_collector off Def
maintenance_work_mem 16384 (16 MB) Def
max_connections 100 Conf
max_prepared_transactions 0 Def
port 6000 Conf
random_page_cost 4 Def
server_encoding UTF8 Set
shared_buffers 3584 (28 MB) Conf
syslog_facility local0 Def
vacuum_freeze_min_age 50000000 Def
wal_sync_method fdatasync Def
work_mem 1024 (1024 kB) Def
PG DBs 5001 /tmp/
Name Encoding/ Owner Template/ Connectable/ Age Size Schemas/ Tables/ Functions Languages
postgres UTF8 greg No Yes 253 19.92 MB 2 10 11 plpgsql
template0 UTF8 greg Yes No 253 5.15 MB N/A
template1 UTF8 greg Yes Yes 253 5.23 MB 1 0 0 plpgsql
PG DBs 5002 /tmp/
Name Encoding/ Owner Template/ Connectable/ Age Size Schemas/ Tables/ Functions Languages
postgres UTF8 greg No Yes 76 19.86 MB 2 10 10 plpgsql
template0 UTF8 greg Yes No 76 5.15 MB N/A
template1 UTF8 greg Yes Yes 76 5.23 MB 1 0 0 plpgsql
PG DBs 5840 /tmp/
Name Encoding/ Owner Template/ Connectable/ Age Size Schemas/ Tables/ Functions Languages
"FOO UTF8 greg No Yes 14446 5.16 MB 1 0 0
Xor UTF8 greg No Yes 14446 5.16 MB 1 0 0
bucardo UTF8 bucardo No Yes 14446 6.49 MB 3 19 22 plperlu plpgsql
greg UTF8 greg No Yes 14446 8.14 MB 2 19 20 plperlu plpgsql
mstest UTF8 greg No Yes 14446 5.54 MB 2 8 8 plpgsql
mstest2 UTF8 greg No Yes 14446 5.23 MB 1 1 0 plpgsql
one UTF8 greg No Yes 14446 5.45 MB 2 8 12 plpgsql
postgres UTF8 greg No Yes 14446 5.28 MB 1 1 0
quote'me UTF8 greg No Yes 14446 5.16 MB 1 0 0 plpgsql
template0 UTF8 greg Yes No 14446 5.07 MB N/A
template1 UTF8 greg Yes Yes 14446 5.16 MB 1 0 0 plpgsql
teocalli UTF8 postgres No Yes 14446 5.28 MB 1 1 2 plperlu plpgsql
two UTF8 postgres No Yes 14446 5.45 MB 2 7 12 plpgsql
PG DBs 6000 /tmp/
Name Encoding/ Owner Template/ Connectable/ Age Size Schemas/ Tables/ Functions Languages
postgres UTF8 greg No Yes 66 19.58 MB 1 4 0 plpgsql
template0 UTF8 greg Yes No 66 5.15 MB N/A
template1 UTF8 greg Yes Yes 66 5.23 MB 1 0 0 plpgsql
Bucardo info 5840 /tmp/ bucardo
Config: audit_pid: autosync_ddl: newcol bucardo_current_version: 4.5.0 bucardo_version: 4.5.0 ctl_checkabortedkids_time: 30 ctl_checkonkids_time: 10 ctl_createkid_time: 0.5 ctl_nothingfound_sleep: 0.001 ctl_pingtime: 600 default_email_from: nobody@example.com default_email_host: localhost default_email_to: nobody@example.com email_debug_file: endsync_sleep: 1.0 host_safety_check: kick_sleep: 0.2 kid_abort_limit: 3 kid_abort_sleep: 1 kid_nodeltarows_sleep: 0.001 kid_nothingfound_sleep: 0.001 kid_pingtime: 60 kid_serial_sleep: 10 log_conflict_details: log_conflict_file: bucardo_conflict.log log_showline: log_showpid: log_showtime: 3 max_delete_clause: 200 max_select_clause: 500 mcp_dbproblem_sleep: 15 mcp_loop_sleep: 0.001 mcp_pingtime: 60 piddir: /var/run/bucardo reason_file: bucardo.restart.reason.log stats_script_url: <http://www.bucardo.org/> stopfile: fullstopbucardo syslog_facility: LOG_LOCAL1 tcp_keepalives_count: tcp_keepalives_idle: tcp_keepalives_interval: warning_file: bucardo.warning.log
Databases: m1: dbport=5001 dbname=postgres m2: dbport=5002 dbname=postgres m3: dbport=5003 dbname=postgres slave: dbport=6000 dbname=postgres
Tables: m1.public.accounts m2.public.accounts m3.public.accounts m1.public.branches m2.public.branches m3.public.branches m1.public.history m2.public.history m3.public.history m1.public.tellers m2.public.tellers m3.public.tellers
Sequences: NONE
Syncs: s1 pushdelta uno =\> DB slave s2 pushdelta dos =\> DB slave s3 pushdelta tres =\> DB slave
pg_config info
BINDIR /usr/local/bin
CC gcc
CFLAGS -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
CFLAGS_SL -fpic
CONFIGURE '--with-perl' '--prefix=/home/greg/code/pgsql/8.5devel' '--with-gnu-ld'
CPPFLAGS -D_GNU_SOURCE
DOCDIR /usr/local/share/doc
HTMLDIR /usr/local/share/doc
INCLUDEDIR /usr/local/include
INCLUDEDIR-SERVER /usr/local/include/server
LDFLAGS -Wl,--as-needed -Wl,-rpath,'/home/greg/code/pgsql/8.5devel/lib'
LDFLAGS_SL
LIBDIR /usr/local/lib
LIBS -lpgport -lz -lreadline -lcrypt -ldl -lm
LOCALEDIR /usr/local/share/locale
MANDIR /usr/local/share/man
PGXS /usr/local/lib/pgxs/src/makefiles/pgxs.mk
PKGINCLUDEDIR /usr/local/include
PKGLIBDIR /usr/local/lib
SHAREDIR /usr/local/share
SYSCONFDIR /usr/local/etc
VERSION PostgreSQL 8.5devel
User limits:
Name Limit
POSIX message queues 819200
core file size 1000000
cpu time unlimited
data seg size unlimited
file locks unlimited
file size unlimited
max locked memory 64
max memory size unlimited
max user processes 1024
open files 1024
pending signals 24568
pipe size 8
real-time priority 0
scheduling priority 0
stack size 10240
virtual memory unlimited

Bucardo.org is hosted and supported by End Point Dev

End Point Dev logo

Need assistance with Boxinfo?

End Point Dev offers professional support for Boxinfo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.