Boxinfo/Example

From Bucardo

Jump to: navigation, search

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:

NameIPStatusSpeedNotes
tun0192.168.255.240Active10Mb/s Fullpoint to point
eth0192.168.1.6Active100Mb/s Full  
lo127.0.0.1ActiveN/A  
tun110.201.1.176Active10Mb/s Fullpoint to point
wlan0N/AInactiveN/A  
wmaster0N/AInactiveN/A  

Mounting info:

NameMountSize/Used %Inode %Filesystem (options)
/dev/mapper/
luks-c8fa3e5a-c281-4331-b0d2-66afdeafdfe9
/data50G/37%8% ext3 (rw,
noatime,
nodiratime)
/dev/sda5/50G/22%10% ext3 (rw,
noatime,
nodiratime)
/dev/sr0/media/THIEF2_CD2532M/100%- iso9660 (ro,
nosuid,
nodev,
uhelper=devkit,
uid=500,
gid=500,
iocharset=utf8,
mode=0400,
dmode=0500)
tmpfs/dev/shm1.5G/1%1% tmpfs (rw)

Kernel queue info:

BlockRead ahead sizeScheduler
sda8192 KBnoop anticipatory [deadline] cfq
sdb8192 KBnoop anticipatory [deadline] cfq

Program versions:

NameVersionNameVersionNameVersion
autoconf2.63 awk3.1.6a bash4.0.23(1)-release
bzip21.0.5 cc4.4.1 chkconfig1.3.42
convert6.5.1-2 curl7.19.7 cvs1.11.23
elinks0.12pre3 emacs23.1.1 find4.4.0
gcc4.4.1 gdb6.8.50.20090302-39.fc11 git1.6.2.5
gnome-panel2.26.3 gpg2.0.12 gzip1.3.12
iconv2.10.2 initdb8.5devel lighttpd1.4.23
links0.12pre3 make3.81 mii-tool1.9
mysql5.1.41 (14.14) nano2.0.6 ntpd4.2.4p7
openssl0.9.8k-fips perl5.10.0 pg_config8.5devel
pg_dump8.5devel php5.2.11 postgres8.5devel
psql8.5devel python2.6 rcs5.7
rrdtool1.3.8 rsync3.0.6 rsyslogd3.22.1
ruby1.8.6 screen4.00.03 sed4.2.1
sendmail8.14.3 service0.91 ssh5.2p1
svn1.6.6 vi7.2 yum3.2.24
zip2.31     

Perl info:

Version:5.10.0
IThreads:Yes
Multiplicity:Yes

Perl modules:

ModuleVersion
DBD::Pg2.15.1
DBD::mysql4.010
DBI1.611
DBIx::Safe1.2.5
Digest::MD52.36_01
Mail::Sendmail0.79
Sys::Syslog0.27
Time::HiRes1.9719
YAML0.68

Active Postgres clusters:

PortSocket dirVersion
5001/tmp/8.5devel
5002/tmp/8.5devel
5840/tmp/8.4.1
6000/tmp/8.5devel

→ Postgres config:

ClusterConfigValueSource
5001
/tmp/
checkpoint_segments3Def
client_encodingUTF8Def
config_file/data/greg/code/bucardo/m1/postgresql.confSet
constraint_exclusionpartitionDef
data_directory/data/greg/code/bucardo/m1Set
debug_pretty_printonDef
default_statistics_target100Def
effective_cache_size16384 (128 MB)Def
hba_file/data/greg/code/bucardo/m1/pg_hba.confSet
ident_file/data/greg/code/bucardo/m1/pg_ident.confSet
integer_datetimesonDef
listen_addresseslocalhostDef
log_destinationstderrDef
log_filenamepostgresql-%Y-%m-%d_%H%M%S.logDef
log_line_prefix%m %p Conf
log_min_duration_statement-1 (disabled)Def
log_statementallConf
logging_collectoroffDef
maintenance_work_mem16384 (16 MB)Def
max_connections100Conf
max_prepared_transactions0Def
port5001Conf
random_page_cost4Def
server_encodingUTF8Set
shared_buffers3584 (28 MB)Conf
syslog_facilitylocal0Def
vacuum_freeze_min_age50000000Def
wal_sync_methodfdatasyncDef
work_mem1024 (1024 kB)Def
5002
/tmp/
checkpoint_segments3Def
client_encodingUTF8Def
config_file/data/greg/code/bucardo/m2/postgresql.confSet
constraint_exclusionpartitionDef
data_directory/data/greg/code/bucardo/m2Set
debug_pretty_printonDef
default_statistics_target100Def
effective_cache_size16384 (128 MB)Def
hba_file/data/greg/code/bucardo/m2/pg_hba.confSet
ident_file/data/greg/code/bucardo/m2/pg_ident.confSet
integer_datetimesonDef
listen_addresseslocalhostDef
log_destinationstderrDef
log_filenamepostgresql-%Y-%m-%d_%H%M%S.logDef
log_min_duration_statement-1 (disabled)Def
logging_collectoroffDef
maintenance_work_mem16384 (16 MB)Def
max_connections100Conf
max_prepared_transactions0Def
port5002Conf
random_page_cost4Def
server_encodingUTF8Set
shared_buffers3584 (28 MB)Conf
syslog_facilitylocal0Def
vacuum_freeze_min_age50000000Def
wal_sync_methodfdatasyncDef
work_mem1024 (1024 kB)Def
5840
/tmp/
checkpoint_segments3Def
client_encodingUTF8Def
config_file/home/greg/code/postgres/8.4/data/postgresql.confSet
constraint_exclusionpartitionDef
data_directory/home/greg/code/postgres/8.4/dataSet
debug_pretty_printonDef
default_statistics_target100Def
effective_cache_size16384 (128 MB)Def
hba_file/home/greg/code/postgres/8.4/data/pg_hba.confSet
ident_file/home/greg/code/postgres/8.4/data/pg_ident.confSet
integer_datetimesonDef
listen_addresseslocalhostDef
log_destinationstderrDef
log_filenamepostgresql-%Y-%m-%d_%H%M%S.logDef
log_min_duration_statement0 (logs all durations)Conf
log_statementallConf
logging_collectoroffDef
maintenance_work_mem16384 (16 MB)Def
max_connections30Conf
max_prepared_transactions10Conf
max_stack_depth5120 (5 MB)Conf
port5840Conf
random_page_cost4Def
server_encodingUTF8Set
shared_buffers3584 (28 MB)Conf
syslog_facilitylocal0Def
vacuum_freeze_min_age50000000Def
wal_sync_methodfdatasyncDef
work_mem2048 (2 MB)Conf
6000
/tmp/
checkpoint_segments3Def
client_encodingUTF8Def
config_file/data/greg/code/bucardo/slave/postgresql.confSet
constraint_exclusionpartitionDef
data_directory/data/greg/code/bucardo/slaveSet
debug_pretty_printonDef
default_statistics_target100Def
effective_cache_size16384 (128 MB)Def
hba_file/data/greg/code/bucardo/slave/pg_hba.confSet
ident_file/data/greg/code/bucardo/slave/pg_ident.confSet
integer_datetimesonDef
listen_addresseslocalhostDef
log_destinationstderrDef
log_filenamepostgresql-%Y-%m-%d_%H%M%S.logDef
log_line_prefix%m %p Conf
log_min_duration_statement-1 (disabled)Def
log_statementallConf
logging_collectoroffDef
maintenance_work_mem16384 (16 MB)Def
max_connections100Conf
max_prepared_transactions0Def
port6000Conf
random_page_cost4Def
server_encodingUTF8Set
shared_buffers3584 (28 MB)Conf
syslog_facilitylocal0Def
vacuum_freeze_min_age50000000Def
wal_sync_methodfdatasyncDef
work_mem1024 (1024 kB)Def

→ PG DBs
5001
/tmp/

Name Encoding/
Owner
Template/
Connectable/
Age
SizeSchemas/
Tables/
Functions
Languages
postgresUTF8
greg
No
Yes
253
19.92 MB2
10
11
plpgsql
template0UTF8
greg
Yes
No
253
5.15 MBN/A 
template1UTF8
greg
Yes
Yes
253
5.23 MB1
0
0
plpgsql

→ PG DBs
5002
/tmp/

Name Encoding/
Owner
Template/
Connectable/
Age
SizeSchemas/
Tables/
Functions
Languages
postgresUTF8
greg
No
Yes
76
19.86 MB2
10
10
plpgsql
template0UTF8
greg
Yes
No
76
5.15 MBN/A 
template1UTF8
greg
Yes
Yes
76
5.23 MB1
0
0
plpgsql

→ PG DBs
5840
/tmp/

Name Encoding/
Owner
Template/
Connectable/
Age
SizeSchemas/
Tables/
Functions
Languages
"FOOUTF8
greg
No
Yes
14446
5.16 MB1
0
0
 
XorUTF8
greg
No
Yes
14446
5.16 MB1
0
0
 
bucardoUTF8
bucardo
No
Yes
14446
6.49 MB3
19
22
plperlu
plpgsql
gregUTF8
greg
No
Yes
14446
8.14 MB2
19
20
plperlu
plpgsql
mstestUTF8
greg
No
Yes
14446
5.54 MB2
8
8
plpgsql
mstest2UTF8
greg
No
Yes
14446
5.23 MB1
1
0
plpgsql
oneUTF8
greg
No
Yes
14446
5.45 MB2
8
12
plpgsql
postgresUTF8
greg
No
Yes
14446
5.28 MB1
1
0
 
quote'meUTF8
greg
No
Yes
14446
5.16 MB1
0
0
plpgsql
template0UTF8
greg
Yes
No
14446
5.07 MBN/A 
template1UTF8
greg
Yes
Yes
14446
5.16 MB1
0
0
plpgsql
teocalliUTF8
postgres
No
Yes
14446
5.28 MB1
1
2
plperlu
plpgsql
twoUTF8
postgres
No
Yes
14446
5.45 MB2
7
12
plpgsql

→ PG DBs
6000
/tmp/

Name Encoding/
Owner
Template/
Connectable/
Age
SizeSchemas/
Tables/
Functions
Languages
postgresUTF8
greg
No
Yes
66
19.58 MB1
4
0
plpgsql
template0UTF8
greg
Yes
No
66
5.15 MBN/A 
template1UTF8
greg
Yes
Yes
66
5.23 MB1
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:

NameLimit
POSIX message queues819200
core file size1000000
cpu timeunlimited
data seg sizeunlimited
file locksunlimited
file sizeunlimited
max locked memory64
max memory sizeunlimited
max user processes1024
open files1024
pending signals24568
pipe size8
real-time priority0
scheduling priority0
stack size10240
virtual memoryunlimited
Personal tools