module(load="imtcp")
input(type="imtcp" port="514")
input(type="imtcp" port="5140")
# netstat -antup | grep rsyslog
tcp 0 0 0.0.0.0:5140 0.0.0.0:* LISTEN 1333/rsyslogd
tcp 0 0 0.0.0.0:514 0.0.0.0:* LISTEN 1333/rsyslogd
#
*.*;local4.none :ommysql:localhost,Syslog,rsyslog,PASSWORD
$template STOPSQL, "/var/log/%fromhost%/%$year%%$month%%$day%.log"
if \
( $fromhost-ip == '192.168.233.100' or \
$fromhost-ip == '192.168.233.101' ) \
then {
action(type="omfile"
DirCreateMode="0750"
DirGroup="logadmin"
FileCreateMode="0640"
FileOwner="logadmin"
dynaFile="STOPSQL")
stop
}
*.* :ommysql:localhost,Syslog,rsyslog,PASSWORD
<追加時>
# ip addr add 192.168.233.8/24 dev ens32
<削除時>
# ip addr del 192.168.233.8/24 dev ens32
# ip addr show
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: ens32: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 00:0c:29:7e:2f:54 brd ff:ff:ff:ff:ff:ff
inet 192.168.233.7/24 brd 192.168.233.255 scope global ens32
valid_lft forever preferred_lft forever
inet 192.168.233.8/24 brd 192.168.233.255 scope global secondary ens32
valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe7e:2f54/64 scope link
valid_lft forever preferred_lft forever
#
# grep ^menuent /boot/grub2/grub.cfg | awk -F\' '{ print $2 }'
CentOS Linux, with Linux 3.10.0-123.el7.x86_64 <-最も古いkernel
CentOS Linux, with Linux 3.10.0-123.6.3.el7.x86_64 <-最新のkernel
CentOS Linux, with Linux 3.10.0-123.4.4.el7.x86_64
CentOS Linux, with Linux 3.10.0-123.4.2.el7.x86_64
CentOS Linux, with Linux 0-rescue-09cc85c5693c44fe999137f3ea268654
#
# grub2-mkconfig -o /boot/grub2/grub.cfg
GRUB_DEFAULT=saved
GRUB_SAVEDEFAULT=true <－追記
# grub2-mkconfig -o /boot/grub2/grub.cfg- OS起動時に起動するkernelを手動で選択する
# grep ^menuentry /boot/grub2/grub.cfg
# grub2-set-default <上記で調べたmenuentry_id_option>
# grub2-mkconfig -o /boot/grub2/grub.cfg
# grub2-editenv list
saved_entry=gnulinux-3.10.0-123.9.2.el7.x86_64-advanced-8bb0c9cd-5584-492e-a498-0723073163b9
# mkfs.s3ql s3://s3ql-mail
Enter backend login: Access Key ID を入力
Enter backend passphrase: Secret Access Key を入力
Before using S3QL, make sure to read the user's guide, especially
the 'Important Rules to Avoid Loosing Data' section.
Enter encryption password: 暗号化パスワード を入力
Confirm encryption password: 暗号化パスワード を再度入力
Generating random encryption key...
Creating metadata tables...
Dumping metadata...
..objects..
..blocks..
..inodes..
..inode_blocks..
..symlink_targets..
..names..
..contents..
..ext_attributes..
Compressing and uploading metadata...
Wrote 150 bytes of compressed metadata.
#
# mkdir /mail_storage
# mount.s3ql --allow-other s3://s3ql-mail /mail_storage
Using 2 upload threads.
Autodetected 10202 file descriptors available for cache entries
Enter backend login:Access Key ID を入力
Enter backend passphrase:Secret Access Key を入力
Enter file system encryption passphrase:暗号化パスワード を入力
Using cached metadata.
Setting cache size to 8732 MB
Mounting filesystem...
#
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 13G 1.4G 11G 11% /
tmpfs 935M 0 935M 0% /dev/shm
/dev/sda1 194M 86M 98M 47% /boot
s3://s3ql-mail 1.0T 0 1.0T 0% /mail_storage
#
# touch ~/.s3ql/authinfo2
# chmod 600 ~/.s3ql/authinfo2
# vi ~/.s3ql/authinfo2
<記述内容>==========================
[s3]
storage-url: s3://s3ql-mail
backend-login: Access Key ID
backend-password: Secret Access Key
fs-passphrase: 暗号化パスワード
====================================
# chkconfig --add s3ql
#!/bin/bash
#
# chkconfig: 35 60 40
# description: S3QL Backup File System
#
# Source function library.
. /etc/init.d/functions
#
AUTHFILE="/root/.s3ql/authinfo2"
BUCKET="s3://s3ql-mail"
MOUNTPOINT="/mail_storage"
OPTIONS="--allow-other"
start() {
echo -n $"Mounting S3QL: "
mount | grep $MOUNTPOINT > /dev/null
if [ $? -eq 0 ];then
echo $"Cannot mount $MOUNTPOINT. Already mounted !!"
echo
exit 1
fi
echo
fsck.s3ql --batch $BUCKET
mount.s3ql $OPTIONS $BUCKET $MOUNTPOINT
RETVAL=$?
[ $RETVAL -eq 0 ] && success || failure
echo
}
stop() {
echo -n $"Unmounting S3QL: "
mount | grep $MOUNTPOINT > /dev/null
if [ $? -ne 0 ];then
echo $"Already unmounted !!"
echo
exit 1
fi
umount.s3ql $MOUNTPOINT && success || failure
echo
}
case "$1" in
start)
start
;;
stop)
stop
;;
*)
echo "Usage: `basename $0` {start|stop}"
exit 1
;;
esac
# yum install autoconf gcc unzip fuse fuse-devel libattr-devel
# cd /etc/pki/rpm-gpg/
# wget -q http://springdale.math.ias.edu/data/puias/6/x86_64/os/RPM-GPG-KEY-puias
# rpm --import RPM-GPG-KEY-puias
# cat <<EOF >> /etc/yum.repos.d/puias-computational.repo
> [PUIAS_6_computational]
> name=PUIAS Computational Base
> mirrorlist=http://puias.math.ias.edu/data/puias/computational/\$releasever/\$basearch/mirrorlist
> gpgcheck=1
> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-puias
> EOF
#
# yum install python3 python3-devel python3-libs
# wget -O - https://raw.github.com/pypa/pip/master/contrib/get-pip.py | python3
# pip -V
pip 1.5.6 from /usr/lib/python3.3/site-packages (python 3.3)
#
# pip list
pip (1.5.6)
setuptools (5.4.2)
#
$ wget http://www.sqlite.org/2014/sqlite-autoconf-3080500.tar.gz
$ tar zxf sqlite-autoconf-3080500.tar.gz
$ cd sqlite-autoconf-3080500
$ ./configure --prefix=/usr/local/sqlite-3.8
$ make
$ su
Password: パスワードの入力
# make install
# echo "/usr/local/sqlite-3.8/lib" > /etc/ld.so.conf.d/sqlite.conf
# ldconfig
# pip install pycrypto
# pip install defusedxml
# pip install requests
# pip install llfuse
# pip install dugong
# wget https://github.com/rogerbinns/apsw/releases/download/3.8.5-r1/apsw-3.8.5-r1.zip
# unzip apsw-3.8.5-r1.zip
# cd apsw-3.8.5-r1
# cp -p setup.py{,.orig}
# vi setup.py
<編集後のdiff出力>====================================
--- setup.py.orig 2014-06-04 21:32:56.000000000 +0900
+++ setup.py 2014-08-14 22:43:08.417085436 +0900
@@ -19,8 +19,8 @@
## http://www.python.org/doc/2.5.2/dist/setup-config.html
##
-include_dirs=['src']
-library_dirs=[]
+include_dirs=['src','/usr/local/sqlite-3.8/include']
+library_dirs=['/usr/local/sqlite-3.8/lib']
define_macros=[]
libraries=[]
=====================================================
# python3 setup.py install
# pip list
Warning: cannot find svn location for apsw==3.8.5-r1
apsw (3.8.5-r1)
defusedxml (0.4.1)
dugong (3.2)
llfuse (0.40)
pip (1.5.6)
pycrypto (2.6.1)
requests (2.3.0)
setuptools (5.4.1)
#
# wget https://bitbucket.org/nikratio/s3ql/downloads/s3ql-2.11.tar.bz2
# tar jxf s3ql-2.11.tar.bz2
# cd s3ql-2.11
#
# python3 setup.py build_ext --include-dirs='/usr/local/sqlite-3.8/include' \
> --library-dirs='/usr/local/sqlite-3.8/lib' --inplace
# python3 runtests.py tests
(snip)
========= 550 passed, 17 skipped, 1 warnings in 161.45 seconds ===========
#
# python3 setup.py install
（snip)
Using /usr/lib64/python3.3/site-packages
Finished processing dependencies for s3ql==2.11
#
# ls -l /usr/bin/*s3ql*
-rwxr-xr-x 1 root root 294 Aug 29 23:17 /usr/bin/fsck.s3ql*
-rwxr-xr-x 1 root root 294 Aug 29 23:17 /usr/bin/mkfs.s3ql*
-rwxr-xr-x 1 root root 296 Aug 29 23:17 /usr/bin/mount.s3ql*
-rwxr-xr-x 1 root root 290 Aug 29 23:17 /usr/bin/s3qladm*
-rwxr-xr-x 1 root root 288 Aug 29 23:17 /usr/bin/s3qlcp*
-rwxr-xr-x 1 root root 292 Aug 29 23:17 /usr/bin/s3qlctrl*
-rwxr-xr-x 1 root root 292 Aug 29 23:17 /usr/bin/s3qllock*
-rwxr-xr-x 1 root root 310 Aug 29 23:17 /usr/bin/s3ql_oauth_client*
-rwxr-xr-x 1 root root 288 Aug 29 23:17 /usr/bin/s3qlrm*
-rwxr-xr-x 1 root root 292 Aug 29 23:17 /usr/bin/s3qlstat*
-rwxr-xr-x 1 root root 298 Aug 29 23:17 /usr/bin/s3ql_verify*
-rwxr-xr-x 1 root root 298 Aug 29 23:17 /usr/bin/umount.s3ql*
#
[ALL]# rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
[ALL]# rpm -Uvh http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm
Retrieving http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm
Preparing... ########################################### [100%]
1:elrepo-release ########################################### [100%]
[ALL]#
[ALL]# yum install drbd84-utils kmod-drbd84
# locate drbd.ko
/lib/modules/2.6.32-358.el6.x86_64/extra/drbd84/drbd.ko
/lib/modules/2.6.32-431.1.2.0.1.el6.x86_64/weak-updates/drbd84/drbd.ko
/lib/modules/2.6.32-431.17.1.el6.x86_64/weak-updates/drbd84/drbd.ko
/lib/modules/2.6.32-431.5.1.el6.x86_64/weak-updates/drbd84/drbd.ko
#
# rpm -e --nodeps sendmail
$ wget -O - http://www.openssl.org/source/openssl-1.0.1h.tar.gz | tar zxf -
$ cd openssl-1.0.1h/
$ ./config --prefix=/usr/local
$ make
$ su
# make install
# yum -y install pcre-devel db4-devel
$ wget http://mirror.postfix.jp/postfix-release/experimental/postfix-2.12-20140703.tar.gz ←★改行されてますがここまでが1行
$ tar zxf postfix-2.12-20140703.tar.gz
$ cd postfix-2.12-20140703
$ make makefiles shared=yes \
shlib_directory=/usr/lib64/postfix/2.12-20140703/ dynamicmaps=yes \
CCARGS="-DUSE_TLS -DUSE_SASL_AUTH -DDEF_SERVER_SASL_TYPE=\\\"dovecot\\\" \
-I/usr/local/include/openssl" \
AUXLIBS="-lssl -lcrypto -L/usr/local/lib64" \
AUXLIBS_PCRE=`pcre-config --libs`
$ make※以下、聞かれる質問には、表示されるものをそのまま選択します（Enterを押していきます）。
$ su
# make install
(snip)
Please specify the prefix for installed file names. Specify this ONLY
if you are building ready-to-install packages for distribution to OTHER
machines. See PACKAGE_README for instructions.
install_root: [/]
Please specify a directory for scratch files while installing Postfix. You
must have write permission in this directory.
tempdir: [/home/toshiaki/postfix-2.12-20140703]
Please specify the final destination directory for installed Postfix
configuration files.
config_directory: [/etc/postfix]
Please specify the final destination directory for installed Postfix
administrative commands. This directory should be in the command search
path of adminstrative users.
command_directory: [/usr/sbin]
Please specify the final destination directory for installed Postfix
daemon programs. This directory should not be in the command search path
of any users.
daemon_directory: [/usr/libexec/postfix]
Please specify the final destination directory for Postfix-writable
data files such as caches or random numbers. This directory should not
be shared with non-Postfix software.
data_directory: [/var/lib/postfix]
Please specify the final destination directory for the Postfix HTML
files. Specify "no" if you do not want to install these files.
html_directory: [no]
Please specify the owner of the Postfix queue. Specify an account with
numerical user ID and group ID values that are not used by any other
accounts on the system.
mail_owner: [postfix]Please specify the final destination pathname for the installed Postfix
mailq command. This is the Sendmail-compatible mail queue listing command.
mailq_path: [/usr/bin/mailq]
Please specify the final destination directory for the Postfix on-line
manual pages. You can no longer specify "no" here.
manpage_directory: [/usr/local/man]
Please specify the final destination pathname for the installed Postfix
newaliases command. This is the Sendmail-compatible command to build
alias databases for the Postfix local delivery agent.
newaliases_path: [/usr/bin/newaliases]
Please specify the final destination directory for Postfix queues.
queue_directory: [/var/spool/postfix]
Please specify the final destination directory for the Postfix README
files. Specify "no" if you do not want to install these files.
readme_directory: [no]
Please specify the final destination pathname for the installed Postfix
sendmail command. This is the Sendmail-compatible mail posting interface.
sendmail_path: [/usr/sbin/sendmail]
Please specify the group for mail submission and for queue management
commands. Specify a group name with a numerical group ID that is
not shared with other accounts, not even with the Postfix mail_owner
account. You can no longer specify "no" here.
setgid_group: [postdrop]
Please specify the final destination directory for Postfix shared-library
files.
shlib_directory: [/usr/lib64/postfix/2.12-20140703/]
Please specify the final destination directory for non-executable files
that are shared among multiple Postfix instances, such as postfix-files,
dynamicmaps.cf, as well as the multi-instance template files main.cf.proto
and master.cf.proto.
meta_directory: [/etc/postfix]
（snip)
Warning: you still need to edit myorigin/mydestination/mynetworks
parameter settings in /etc/postfix/main.cf.
See also http://www.postfix.org/STANDARD_CONFIGURATION_README.html
for information about dialup sites or about sites inside a firewalled
network.
BTW: Check your /etc/aliases file and be sure to set up aliases
that send mail for root and postmaster to a real person, then run
/usr/bin/newaliases.
#
# postfix start （もしくは # /usr/sbin/postfix start）
# chkconfig --add postfix
# chkconfig postfix on
# ls -lh /usr/sbin/post*
-rwxr-xr-x 1 root root 193K Jan 9 2013 /usr/sbin/postalias*
-rwxr-xr-x 1 root root 112K Jan 9 2013 /usr/sbin/postcat*
-rwxr-xr-x 1 root root 261K Jan 9 2013 /usr/sbin/postconf*
-rwxr-sr-x 1 root postdrop 168K Jan 9 2013 /usr/sbin/postdrop*
-rwxr-xr-x 1 root root 100K Jan 9 2013 /usr/sbin/postfix*
-rwxr-xr-x 1 root root 112K Jan 9 2013 /usr/sbin/postkick*
-rwxr-xr-x 1 root root 108K Jan 9 2013 /usr/sbin/postlock*
-rwxr-xr-x 1 root root 100K Jan 9 2013 /usr/sbin/postlog*
-rwxr-xr-x 1 root root 185K Jan 9 2013 /usr/sbin/postmap*
-rwxr-sr-x 1 root postdrop 189K Jan 9 2013 /usr/sbin/postqueue*
-rwxr-xr-x 1 root root 116K Jan 9 2013 /usr/sbin/postsuper*
# ls -lh /usr/sbin/post*
-rwxr-xr-x 1 root root 34K Jul 7 00:34 /usr/sbin/postalias*
-rwxr-xr-x 1 root root 29K Jul 7 00:34 /usr/sbin/postcat*
-rwxr-xr-x 1 root root 318K Jul 7 00:34 /usr/sbin/postconf*
-rwxr-sr-x 1 root postdrop 27K Jul 7 00:34 /usr/sbin/postdrop*
-rwxr-xr-x 1 root root 22K Jul 7 00:34 /usr/sbin/postfix*
-rwxr-xr-x 1 root root 16K Jul 7 00:34 /usr/sbin/postkick*
-rwxr-xr-x 1 root root 19K Jul 7 00:34 /usr/sbin/postlock*
-rwxr-xr-x 1 root root 18K Jul 7 00:34 /usr/sbin/postlog*
-rwxr-xr-x 1 root root 39K Jul 7 00:34 /usr/sbin/postmap*
-rwxr-xr-x 1 root root 52K Jul 7 00:34 /usr/sbin/postmulti*
-rwxr-sr-x 1 root postdrop 30K Jul 7 00:34 /usr/sbin/postqueue*
-rwxr-xr-x 1 root root 48K Jul 7 00:34 /usr/sbin/postsuper*
KEYMAP="jp106"
# systemctl status systemd-vconsole-setup.service
systemd-vconsole-setup.service - Setup Virtual Console
Loaded: loaded (/usr/lib/systemd/system/systemd-vconsole-setup.service; static)
Active: active (exited) since Sat 2014-06-28 16:40:14 JST; 27min ago
Docs: man:systemd-vconsole-setup.service(8)
man:vconsole.conf(5)
Main PID: 72 (code=exited, status=0/SUCCESS)
Jun 28 16:40:14 test.examp.com systemd[1]: Starting Setup Virtual Console...
Jun 28 16:40:14 test.examp.com systemd[1]: Started Setup Virtual Console.
#
# systemctl restart systemd-vconsole-setup.service
~$ locale
LANG=ja_JP.UTF-8
LANGUAGE=
LC_CTYPE="ja_JP.UTF-8"
LC_NUMERIC="ja_JP.UTF-8"
LC_TIME="ja_JP.UTF-8"
LC_COLLATE="ja_JP.UTF-8"
LC_MONETARY="ja_JP.UTF-8"
LC_MESSAGES="ja_JP.UTF-8"
LC_PAPER="ja_JP.UTF-8"
LC_NAME="ja_JP.UTF-8"
LC_ADDRESS="ja_JP.UTF-8"
LC_TELEPHONE="ja_JP.UTF-8"
LC_MEASUREMENT="ja_JP.UTF-8"
LC_IDENTIFICATION="ja_JP.UTF-8"
LC_ALL=
$
$ export LANG=C
case $TERM in
linux)
LANG=C
;;
*)
LANG=ja_JP.UTF-8
;;
esac
export LANG
# useradd -m -d /kdump kdump
# grep kdump /etc/passwd
kdump:x:502:502::/kdump:/bin/bash
#
net kdump@192.168.233.21
path /kdump
core_collector makedumpfile -c --message-level 1 -d 31
# /etc/rc.d/init.d/kdump propagate
Generating new ssh keys... done.
kdump@192.168.233.21's password: ←★パスワードを入力
/root/.ssh/kdump_id_rsa has been added to ~kdump/.ssh/authorized_keys on 192.168.233.21
#
# /etc/rc.d/init.d/kdump restart
Stopping kdump: [ OK ]
Detected change(s) the following file(s):
/etc/kdump.conf
Rebuilding /boot/initrd-2.6.32-431.1.2.0.1.el6.x86_64kdump.img
Starting kdump: [ OK ]
#
# ls -l /kdump/192.168.233.12-2014-03-24-17\:55\:07/
total 19884
-rw-rw-r-- 1 kdump kdump 85833 Mar 24 17:55 vmcore-dmesg.txt
-rw-rw-r-- 1 kdump kdump 20274689 Mar 24 17:55 vmcore.flat
#
# yum install kexec-tools
title CentOS (2.6.32-431.5.1.el6.x86_64)
root (hd0,0)
kernel /vmlinuz-2.6.32-431.5.1.el6.x86_64 <中略> crashkernel=auto
initrd /initramfs-2.6.32-431.5.1.el6.x86_64.img
# chkconfig kdump on
# /etc/rc.d/init.d/kdump start
No kdump initial ramdisk found. [WARNING]
Rebuilding /boot/initrd-2.6.32-431.1.2.0.1.el6.x86_64kdump.img
Starting kdump: [ OK ]
#
# /etc/rc.d/init.d/kdump status
Kdump is operational
#
# cat /sys/kernel/kexec_crash_loaded
1
#
# yum --enablerepo=debug install kernel-debuginfo-`uname -r` crash
# echo c > /proc/sysrq-trigger
# ll /var/crash/127.0.0.1-2014-03-17-17\:36\:44/
total 30292
-rw------- 1 root root 30929131 Mar 17 17:36 vmcore
-rw-r--r-- 1 root root 85835 Mar 17 17:36 vmcore-dmesg.txt
#
# crash /usr/lib/debug/lib/modules/2.6.32-431.1.2.0.1.el6.x86_64/vmlinux \
> /var/crash/127.0.0.1-2014-03-17-17\:36\:44/vmcore
$EscapeControlCharactersOnReceive off
PGPORT=5433後は、/etc/rc.d/init.d/postgresql-9.2 start で起動します。
[postgres@pgsql ~]$ /usr/pgsql-9.3/bin/pg_ctl start -D /var/lib/pgsql/9.3/data
[postgres@pgsql ~]$ /usr/pgsql-9.2/bin/pg_ctl start -o "-p 5433" -D /var/lib/pgsql/9.2/data
[postgres@pgsql ~]$ ps -fC postgres
UID PID PPID C STIME TTY TIME CMD
postgres 1364 1 0 18:19 pts/0 00:00:00 /usr/pgsql-9.3/bin/postgres -D /var/lib/pgsql/9.3/data
postgres 1365 1364 0 18:19 ? 00:00:00 postgres: logger process
postgres 1367 1364 0 18:19 ? 00:00:00 postgres: checkpointer process
postgres 1368 1364 0 18:19 ? 00:00:00 postgres: writer process
postgres 1369 1364 0 18:19 ? 00:00:00 postgres: wal writer process
postgres 1370 1364 0 18:19 ? 00:00:00 postgres: autovacuum launcher process
postgres 1371 1364 0 18:19 ? 00:00:00 postgres: stats collector process
postgres 1406 1 0 18:21 pts/0 00:00:00 /usr/pgsql-9.2/bin/postgres -D /var/lib/pgsql/9.2/data -p 5433
postgres 1407 1406 0 18:21 ? 00:00:00 postgres: logger process
postgres 1409 1406 0 18:21 ? 00:00:00 postgres: checkpointer process
postgres 1410 1406 0 18:21 ? 00:00:00 postgres: writer process
postgres 1411 1406 0 18:21 ? 00:00:00 postgres: wal writer process
postgres 1412 1406 0 18:21 ? 00:00:00 postgres: autovacuum launcher process
postgres 1413 1406 0 18:21 ? 00:00:00 postgres: stats collector process
[postgres@pgsql ~]$
[postgres@pgsql ~]$ psql -V
psql (PostgreSQL) 9.3.2
[postgres@pgsql ~]$
[postgres@pgsql ~]$ psql -p 5433
psql (9.3.2, server 9.2.6)
Type "help" for help.
postgres=#
[root@pgsql ~]# rpm -ivh http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
[root@pgsql ~]# yum -y install postgresql93-server
[root@pgsql ~]# su - postgres
[postgres@pgsql ~]$ vi .bash_profile
PATH=$PATH:$HOME/bin:/usr/pgsql-9.3/bin
PGDATA=/var/lib/pgsql/9.3/data
MANPATH="$MANPATH":/usr/pgsql-9.3/share/man
export PATH PGDATA MANPATH
[postgres@pgsql ~]$ source .bash_profile
[postgres@pgsql ~]$ initdb --no-locale -E UTF-8
[postgres@pgsql ~]$ pg_ctl start -D $PGDATA
server starting
[postgres@pgsql ~]$ ps -fC postgres
UID PID PPID C STIME TTY TIME CMD
postgres 1295 1 0 00:28 pts/0 00:00:00 /usr/pgsql-9.3/bin/postgres -D /var/lib/pgsql/9.3/data
postgres 1296 1295 0 00:28 ? 00:00:00 postgres: logger process
postgres 1298 1295 0 00:28 ? 00:00:00 postgres: checkpointer process
postgres 1299 1295 0 00:28 ? 00:00:00 postgres: writer process
postgres 1300 1295 0 00:28 ? 00:00:00 postgres: wal writer process
postgres 1301 1295 0 00:28 ? 00:00:00 postgres: autovacuum launcher process
postgres 1302 1295 0 00:28 ? 00:00:00 postgres: stats collector process
[postgres@pgsql ~]$
[postgres@pgsql ~]$ psql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
[postgres@pgsql ~]$
[root@pgsql ~]# chkconfig postgresql-9.3 on
slow unix - - n - - smtp
-o syslog_name=postfix-slow
# 配送制限をかけるドメインをtransportに指定
transport_maps = hash:/etc/postfix/transport
# 1コネクションでのメール制限
slow_initial_destination_concurrency = 2
slow_destination_concurrency_limit = 10
# 配送制限（ここでは10秒で指定）
slow_destination_rate_delay = 10s
gmail.com slow:
