Boxinfo/Example

From Bucardo

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

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 2.15.1 DBD::mysql 4.010 DBI 1.611 DBIx::Safe 1.2.5 Digest::MD5 2.36_01 Mail::Sendmail 0.79 Sys::Syslog 0.27 Time::HiRes 1.9719 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