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
|
|