Home‎ > ‎

rackspace-database

番外編1

Contents

  1. 1 rackspace cloud serverを試してみる
  2. 2 きっかけ
  3. 3 登録
  4. 4 パスワード間違い気づく
  5. 5 構成選んで作成
  6. 6 中身
  7. 7 時間と値段


rackspace cloud serverを試してみる

情報は
Rackspace Cloud ServersがAmazon EC2よりも優れている点 | cloudrop
Rackspace Cloud Computing & Hosting |  Rackspace a Top Cloud Provider - InfiBase did the research
Rackspace / Cloud Server 導入記
Xen対応VPS Prgmr.comとRackspace Cloudの簡単な比較 - MacBook(仮)モウ想記

ちなみに今借りてるlinode
$ uname -a
Linux li55-215 2.6.18.8-linode16 #1 SMP Mon Jan 12 09:50:18 EST 2009 i686 i686 i386 GNU/Linux

$ uptime
 03:45:57 up 229 days, 12:51,  1 user,  load average: 0.00, 0.00, 0.00

$ time touch
touch: missing file operand
詳しくは `touch --help' を実行して下さい.

real    0m0.045s
user    0m0.001s
sys     0m0.000s

$ psql --version
psql (PostgreSQL) 8.1.11
contains support for command-line editing

$ mysql --version
mysql  Ver 14.14 Distrib 5.1.32, for redhat-linux-gnu (i686) using readline 5.1

きっかけ


VPSプランってどうよ？6
http://pc11.2ch.net/test/read.cgi/hosting/1242236775/
909 名無しさん＠お腹いっぱい。 sage 2009/10/20(火) 09:21:32 0
Rackspace Cloud Computing & Hosting | Rackspace a Top Cloud Provider - InfiBase did the research
http://www.rackspacecloud.com/blog/2009/08/05/rackspace-a-top-cloud-provider-infibase-did-the-research/
これみてrackspace cloud使ってみようかと思った

922 名無しさん＠お腹いっぱい。 sage 2009/10/21(水) 00:17:45 0
>>909
MｙSQLが使えない。
925 名無しさん＠お腹いっぱい。 sage 2009/10/21(水) 01:42:01 0
>>922
RDBMSが使えるクラウドなんてあるのか？ 
そんなばかなってことで試してみる

登録

名前、住所、クレカから何から情報聞かれる

言葉の意味は分からんがぐぐってこのへんのクーポンで申し込んでみた
http://www.webmastersgossip.com/f51/
申し込んだ側が得になるのか申し込まれた側が得になるのかそれすらよくわかってない

早速アカウントとパスワードが発行されたがログインが出来ない。
まずusernameを再送してもらう
usernameは合ってる

次に、パスワードの再送を依頼しようとするが、
合ってるusername入れても

The username you entered is invalid
ってエラーが出る。
ここの欄に登録用メールアドレス入れてenterしてみたら、tomcatの500エラーのスタックトレース画面が出た

いったんここまで。時間がたてば反映されるかな。(2009-10-23 10:28)

パスワード間違い気づく

入力したパスワードが間違ってた！ログインできた！
再発行できなかったのがちょっと不安だけど気にせず進む

ログインできたもののなにからして言いかよく分からない
APIキーってなんだろう…

いったんあとで(2009-10-23 10:35)

構成選んで作成



 256 MB $0.015 10 GB
とりあえずこれでいいだろう常識的に考えて

OS　メモリ　HDDの構成を選んで5分ぐらいでインスタンスが立ち上がった

ここでうわさのrootとrootのパスワードがじかでメールで送られてくる！
さすがに速攻かえる
というかrootがsshでパスワードログインできる時点でどうなんだｗ

中身

# cat /etc/redhat-release
CentOS release 5.3 (Final)

# rpm -qa|sort
MAKEDEV-3.23-1.2
SysVinit-2.86-15.el5
acl-2.2.39-3.el5
acpid-1.0.4-7.el5
amtu-1.0.6-1.el5
anacron-2.3-45.el5.centos
at-3.1.8-82.fc6
attr-2.4.32-1.1
audit-1.7.7-6.el5
audit-libs-1.7.7-6.el5
audit-libs-1.7.7-6.el5
audit-libs-python-1.7.7-6.el5
authconfig-5.3.21-5.el5
autofs-5.0.1-0.rc2.102
basesystem-8.0-5.1.1.el5.centos
bash-3.2-24.el5
bc-1.06-21
bind-libs-9.3.4-10.P1.el5
bind-utils-9.3.4-10.P1.el5
binutils-2.17.50.0.6-9.el5
bzip2-1.0.3-4.el5_2
bzip2-libs-1.0.3-4.el5_2
cairo-1.2.4-5.el5
centos-release-5-3.el5.centos.1
centos-release-notes-5.3-3
checkpolicy-1.33.1-4.el5
chkconfig-1.3.30.1-2
conman-0.1.9.2-8.el5
coreutils-5.97-19.el5
cpio-2.6-20
cracklib-2.8.9-3.3
cracklib-2.8.9-3.3
cracklib-dicts-2.8.9-3.3
crash-4.0-7.2.3.el5.centos
crontabs-1.10-8
cryptsetup-luks-1.0.3-4.el5
cryptsetup-luks-1.0.3-4.el5
cups-libs-1.3.7-8.el5
curl-7.15.5-2.el5
cyrus-sasl-2.1.22-4
cyrus-sasl-lib-2.1.22-4
cyrus-sasl-lib-2.1.22-4
cyrus-sasl-plain-2.1.22-4
cyrus-sasl-plain-2.1.22-4
db4-4.3.29-9.fc6
db4-4.3.29-9.fc6
dbus-1.1.2-12.el5
dbus-glib-0.73-8.el5
dbus-libs-1.1.2-12.el5
dbus-python-0.70-7.el5
desktop-file-utils-0.10-7
device-mapper-1.02.28-2.el5
device-mapper-1.02.28-2.el5
device-mapper-event-1.02.28-2.el5
device-mapper-multipath-0.4.7-23.el5
dhclient-3.0.5-18.el5
dhcpv6-client-1.0.10-16.el5
diffutils-2.8.1-15.2.3.el5
dmidecode-2.7-1.28.2.el5
dmraid-1.0.0.rc13-33.el5
dosfstools-2.11-7.el5
dump-0.4b41-2.fc6
e2fsprogs-1.39-20.el5
e2fsprogs-libs-1.39-20.el5
e2fsprogs-libs-1.39-20.el5
ecryptfs-utils-56-8.el5
ecryptfs-utils-56-8.el5
ed-0.2-39.el5_2
elfutils-libelf-0.137-3.el5
ethtool-6-2.el5
expat-1.95.8-8.2.1
expat-1.95.8-8.2.1
file-4.17-15
filesystem-2.4.0-2.el5.centos
findutils-4.2.27-5.el5
finger-0.17-32.2.1.1
fipscheck-1.0.3-1.el5
fipscheck-1.0.3-1.el5
fontconfig-2.4.1-7.el5
freetype-2.2.1-20.el5_2
ftp-0.17-35.el5
gamin-0.1.7-8.el5
gamin-python-0.1.7-8.el5
gawk-3.1.5-14.el5
gdbm-1.8.0-26.2.1
gettext-0.14.6-4.el5
glib2-2.12.3-2.fc6
glibc-2.5-34
glibc-2.5-34
glibc-common-2.5-34
gnupg-1.4.5-14
gnutls-1.4.1-3.el5_2.1
grep-2.5.1-54.2.el5
groff-1.18.1.1-11.1
gzip-1.3.5-10.el5.centos
hal-0.5.8.1-38.el5
hdparm-6.6-2
hesiod-3.1.0-8
htmlview-4.0.0-2.el5
hwdata-0.213.11-1.el5
info-4.8-14.el5
initscripts-8.45.25-1.el5.centos
iproute-2.6.18-9.el5
ipsec-tools-0.6.5-13.el5
iptables-1.3.5-4.el5
iptables-ipv6-1.3.5-4.el5
iptstate-1.4-1.1.2.2
iputils-20020927-45.el5
irqbalance-0.55-10.el5
jwhois-3.2.3-8.el5
kbd-1.12-21.el5
keyutils-libs-1.2-1.el5
keyutils-libs-1.2-1.el5
kpartx-0.4.7-23.el5
krb5-libs-1.6.1-31.el5
krb5-libs-1.6.1-31.el5
krb5-workstation-1.6.1-31.el5
ksh-20080202-2.el5
kudzu-1.2.57.1.21-1.el5.centos
less-394-5.el5
lftp-3.5.1-2.fc6
libICE-1.0.1-2.1
libICE-1.0.1-2.1
libSM-1.0.1-3.1
libSM-1.0.1-3.1
libX11-1.0.3-9.el5
libX11-1.0.3-9.el5
libXau-1.0.1-3.1
libXau-1.0.1-3.1
libXdmcp-1.0.1-2.1
libXdmcp-1.0.1-2.1
libXext-1.0.1-2.1
libXext-1.0.1-2.1
libXft-2.1.10-1.1
libXi-1.0.1-3.1
libXi-1.0.1-3.1
libXrender-0.9.1-3.1
libXt-1.0.2-3.1.fc6
libXt-1.0.2-3.1.fc6
libXxf86vm-1.0.1-3.1
libXxf86vm-1.0.1-3.1
libacl-2.2.39-3.el5
libaio-0.3.106-3.2
libaio-0.3.106-3.2
libattr-2.4.32-1.1
libcap-1.10-26
libdaemon-0.10-5.el5
libdrm-2.0.2-1.1
libdrm-2.0.2-1.1
libgcc-4.1.2-44.el5
libgcc-4.1.2-44.el5
libgcrypt-1.2.4-1.el5
libgcrypt-1.2.4-1.el5
libgpg-error-1.4-2
libgpg-error-1.4-2
libhugetlbfs-1.3-3.el5
libhugetlbfs-1.3-3.el5
libidn-0.6.5-1.1
libjpeg-6b-37
libpng-1.2.10-7.1.el5_0.1
libselinux-1.33.4-5.1.el5
libselinux-1.33.4-5.1.el5
libselinux-python-1.33.4-5.1.el5
libselinux-utils-1.33.4-5.1.el5
libsemanage-1.9.1-3.el5
libsepol-1.15.2-1.el5
libsepol-1.15.2-1.el5
libstdc++-4.1.2-44.el5
libstdc++-4.1.2-44.el5
libsysfs-2.0.0-6
libtermcap-2.0.8-46.1
libtermcap-2.0.8-46.1
libtiff-3.8.2-7.el5_2.2
libusb-0.1.12-5.1
libuser-0.54.7-2.el5.5
libutempter-1.1.4-4.el5
libutempter-1.1.4-4.el5
libvolume_id-095-14.19.el5
libxml2-2.6.26-2.1.2.7
libxml2-python-2.6.26-2.1.2.7
logrotate-3.7.4-9
logwatch-7.3-6.el5
lsof-4.78-3
m2crypto-0.16-6.el5.3
m4-1.4.5-3.el5.1
mailcap-2.1.23-1.fc6
mailx-8.1.1-44.2.2
make-3.81-3.el5
man-1.6d-1.1
man-pages-2.39-12.el5
mcstrans-0.2.11-3.el5
mesa-libGL-6.5.1-7.7.el5
mesa-libGL-6.5.1-7.7.el5
mgetty-1.1.33-9.fc6
microcode_ctl-1.17-1.47.el5
mingetty-1.07-5.2.2
mktemp-1.5-23.2.2
mlocate-0.15-1.el5.1
module-init-tools-3.3-0.pre3.1.42.el5
mtools-3.9.10-2.fc6
mtr-0.71-3.1
nano-1.3.12-1.1
nash-5.1.19.6-44
nc-1.84-10.fc6
ncurses-5.5-24.20060715
ncurses-5.5-24.20060715
net-tools-1.60-78.el5
newt-0.52.2-12.el5
nscd-2.5-34
nspr-4.7.3-2.el5
nspr-4.7.3-2.el5
nss-3.12.2.0-2.el5.centos
nss-3.12.2.0-2.el5.centos
nss-tools-3.12.2.0-2.el5.centos
nss_db-2.2-35.3
nss_db-2.2-35.3
nss_ldap-253-17.el5
nss_ldap-253-17.el5
ntsysv-1.3.30.1-2
numactl-0.9.8-7.el5
numactl-0.9.8-7.el5
oddjob-0.27-9.el5
oddjob-libs-0.27-9.el5
openldap-2.3.43-3.el5
openldap-2.3.43-3.el5
openssh-4.3p2-29.el5
openssh-clients-4.3p2-29.el5
openssh-server-4.3p2-29.el5
openssl-0.9.8e-7.el5
openssl-0.9.8e-7.el5
pam-0.99.6.2-4.el5
pam-0.99.6.2-4.el5
pam_ccreds-3-5
pam_ccreds-3-5
pam_krb5-2.2.14-10
pam_krb5-2.2.14-10
pam_passwdqc-1.0.2-1.2.2
pam_passwdqc-1.0.2-1.2.2
pam_pkcs11-0.5.3-23
pam_pkcs11-0.5.3-23
pam_smb-1.1.7-7.2.1
pam_smb-1.1.7-7.2.1
pango-1.14.9-3.el5.centos
paps-0.6.6-18.el5
parted-1.8.1-23.el5
parted-1.8.1-23.el5
passwd-0.73-1
patch-2.5.4-29.2.3.el5
pax-3.4-1.2.2
pciutils-2.2.3-5
pcre-6.6-2.el5_1.7
perl-5.8.8-18.el5
perl-String-CRC32-1.4-2.fc6
pinfo-0.6.9-1.fc6
pkinit-nss-0.7.6-1.el5
pm-utils-0.99.3-10.el5.centos
policycoreutils-1.33.12-14.2.el5
popt-1.10.2.3-9.el5
portmap-4.0-65.2.2.1
prelink-0.4.0-2.el5
procmail-3.22-17.1.el5.centos
procps-3.2.7-11.1.el5
psacct-6.3.2-44.el5
psmisc-22.2-6
pygobject2-2.12.1-5.el5
python-2.4.3-24.el5
python-elementtree-1.2.6-5
python-iniparse-0.2.3-4.el5
python-sqlite-1.1.7-1.2.1
python-urlgrabber-3.1.0-5.el5
quota-3.13-1.2.5.el5
rdate-1.4-8.el5
rdist-6.1.5-44
readahead-1.3-7.el5
readline-5.1-1.1
readline-5.1-1.1
redhat-menus-6.7.8-3.el5
rhpl-0.194.1-1
rmt-0.4b41-2.fc6
rng-utils-2.0-1.14.1.fc6
rootfiles-8.1-1.1.1
rpm-4.4.2.3-9.el5
rpm-libs-4.4.2.3-9.el5
rpm-python-4.4.2.3-9.el5
rsh-0.17-38.el5
rsync-2.6.8-3.1
sed-4.1.5-5.fc6
selinux-policy-2.4.6-203.el5
selinux-policy-targeted-2.4.6-203.el5
setarch-2.0-1.1
setools-3.0-3.el5
setserial-2.17-19.2.2
setup-2.5.58-4.el5
setuptool-1.19.2-1.el5.centos
shadow-utils-4.0.17-14.el5
slang-2.0.6-4.el5
sos-1.7-9.16.el5
specspo-13-1.el5.centos
sqlite-3.3.6-2
stunnel-4.15-2.el5.1
sudo-1.6.9p17-3.el5
symlinks-1.2-24.2.2
sysfsutils-2.0.0-6
sysklogd-1.4.1-44.el5
syslinux-3.11-4
system-config-network-tui-1.3.99.12-1.el5
system-config-securitylevel-tui-1.6.29.1-2.1.el5
talk-0.17-29.2.2
tar-1.15.1-23.0.1.el5
tcl-8.4.13-3.fc6
tcp_wrappers-7.6-40.6.el5
tcp_wrappers-7.6-40.6.el5
tcpdump-3.9.4-14.el5
tcsh-6.14-14.el5
telnet-0.17-39.el5
termcap-5.5-1.20060701.1
time-1.7-27.2.2
tmpwatch-2.9.7-1.1.el5.2
traceroute-2.0.1-5.el5
tree-1.5.0-4
tzdata-2008i-1.el5
udev-095-14.19.el5
udftools-1.0.0b3-0.1.el5
unzip-5.52-3.el5
usermode-1.88-3.el5.2
util-linux-2.13-0.50.el5
vim-minimal-7.0.109-4.el5_2.4z
vixie-cron-4.1-76.el5
wget-1.10.2-7.el5
which-2.16-7
wireless-tools-28-2.el5
words-3.0-9.1
xorg-x11-filesystem-7.1-2.fc6
yp-tools-2.9-0.1
ypbind-1.19-11.el5
yum-3.2.19-18.el5.centos
yum-fastestmirror-1.1.16-13.el5.centos
yum-metadata-parser-1.1.2-2.el5
yum-updatesd-0.9-2.el5
zip-2.31-2.el5
zlib-1.2.3-3
zlib-1.2.3-3

# chkconfig --list
acpid           0:off   1:off   2:on    3:on    4:on    5:on    6:off
anacron         0:off   1:off   2:on    3:on    4:on    5:on    6:off
atd             0:off   1:off   2:off   3:on    4:on    5:on    6:off
auditd          0:off   1:off   2:on    3:on    4:on    5:on    6:off
autofs          0:off   1:off   2:off   3:on    4:on    5:on    6:off
conman          0:off   1:off   2:off   3:off   4:off   5:off   6:off
crond           0:off   1:off   2:on    3:on    4:on    5:on    6:off
haldaemon       0:off   1:off   2:off   3:on    4:on    5:on    6:off
ip6tables       0:off   1:off   2:on    3:on    4:on    5:on    6:off
iptables        0:off   1:off   2:on    3:on    4:on    5:on    6:off
irqbalance      0:off   1:off   2:on    3:on    4:on    5:on    6:off
kudzu           0:off   1:off   2:off   3:on    4:on    5:on    6:off
mcstrans        0:off   1:off   2:on    3:on    4:on    5:on    6:off
messagebus      0:off   1:off   2:off   3:on    4:on    5:on    6:off
microcode_ctl   0:off   1:off   2:on    3:on    4:on    5:on    6:off
multipathd      0:off   1:off   2:off   3:off   4:off   5:off   6:off
netconsole      0:off   1:off   2:off   3:off   4:off   5:off   6:off
netfs           0:off   1:off   2:off   3:on    4:on    5:on    6:off
netplugd        0:off   1:off   2:off   3:off   4:off   5:off   6:off
network         0:off   1:off   2:on    3:on    4:on    5:on    6:off
nscd            0:off   1:off   2:off   3:off   4:off   5:off   6:off
oddjobd         0:off   1:off   2:off   3:off   4:off   5:off   6:off
portmap         0:off   1:off   2:off   3:on    4:on    5:on    6:off
psacct          0:off   1:off   2:off   3:off   4:off   5:off   6:off
rdisc           0:off   1:off   2:off   3:off   4:off   5:off   6:off
readahead_early 0:off   1:off   2:on    3:on    4:on    5:on    6:off
readahead_later 0:off   1:off   2:off   3:off   4:off   5:on    6:off
restorecond     0:off   1:off   2:on    3:on    4:on    5:on    6:off
saslauthd       0:off   1:off   2:off   3:off   4:off   5:off   6:off
sshd            0:off   1:off   2:on    3:on    4:on    5:on    6:off
syslog          0:off   1:off   2:on    3:on    4:on    5:on    6:off
ypbind          0:off   1:off   2:off   3:off   4:off   5:off   6:off
yum-updatesd    0:off   1:off   2:on    3:on    4:on    5:on    6:off

# uname -a
Linux rackspacedatabase 2.6.24-24-xen #1 SMP Tue Aug 18 18:15:39 UTC 2009 x86_64 x86_64 x86_64 GNU/Linux

# uptime
 10:59:29 up 17 min,  1 user,  load average: 0.00, 0.00, 0.00

# time touch
touch: missing file operand
詳しくは `touch --help' を実行して下さい.

real    0m0.052s
user    0m0.000s
sys     0m0.000s

ちなみに、日本語表示と日本時間には速攻変えてる

$ ping 174.143.154.232
PING 174.143.154.232 (174.143.154.232) 56(84) bytes of data.
64 bytes from 174.143.154.232: icmp_seq=1 ttl=128 time=79.5 ms
64 bytes from 174.143.154.232: icmp_seq=2 ttl=128 time=97.6 ms
64 bytes from 174.143.154.232: icmp_seq=3 ttl=128 time=100 ms
64 bytes from 174.143.154.232: icmp_seq=4 ttl=128 time=77.4 ms
64 bytes from 174.143.154.232: icmp_seq=5 ttl=128 time=83.4 ms
64 bytes from 174.143.154.232: icmp_seq=6 ttl=128 time=132 ms
64 bytes from 174.143.154.232: icmp_seq=7 ttl=128 time=11.8 ms

--- 174.143.154.232 ping statistics ---
7 packets transmitted, 7 received, 0% packet loss, time 6004ms
rtt min/avg/max/mdev = 11.883/83.178/132.310/33.889 ms
$ traceroute 174.143.154.232
traceroute to 174.143.154.232 (174.143.154.232), 30 hops max, 40 byte packets
 1  192.168.26.2 (192.168.26.2)  0.170 ms  0.207 ms  1.114 ms
 2  * * *
 3  * * *
 4  * * *
 5  * * *
 6  * * *
 7  * * *
 8  * * *
 9  * * *
10  * * *
11  * * *
12  * * *
13  * * *
14  * * *
15  * * *
16  * * *
17  * * *
18  * * *
19  * * *
20  * * *
21  * * *
22  * * *
23  * * *
24  * * *
25  * * *
26  * * *
27  * * *
28  * * *
29  * * *
30  * * *

tracerouteはとどかない

# yum install mysql-server

Dependencies Resolved

==========================================================================================
 Package                  Arch             Version                   Repository      Size
==========================================================================================
Installing:
 mysql-server             x86_64           5.0.77-3.el5              base           9.8 M
Installing for dependencies:
 mysql                    x86_64           5.0.77-3.el5              base           4.8 M
 perl-DBD-MySQL           x86_64           3.0007-2.el5              base           148 k
 perl-DBI                 x86_64           1.52-2.el5                base           600 k

Transaction Summary
==========================================================================================
Install      4 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 15 M
Is this ok [y/N]: y

当然入るぞ

# yum install postgresql
Dependencies Resolved

==========================================================================================
 Package                  Arch            Version                     Repository     Size
==========================================================================================
Installing:
 postgresql               x86_64          8.1.11-1.el5_1.1            base          2.9 M
Installing for dependencies:
 postgresql-libs          x86_64          8.1.11-1.el5_1.1            base          195 k

Transaction Summary
==========================================================================================
Install      2 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 3.1 M
Is this ok [y/N]: y

こっちも当然入る

# psql --version
psql (PostgreSQL) 8.1.11
contains support for command-line editing

# mysql --version
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1

# service mysqld start
MySQL データベースを初期化中:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h rackspacedatabase password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                           [  OK  ]
MySQL を起動中:                                            [  OK  ]

# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database foo
    -> ;
Query OK, 1 row affected (0.03 sec)

mysql> use foo;
Database changed

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| foo                |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

はい。

# yum install postgresql-server
Dependencies Resolved

==========================================================================================
 Package                    Arch            Version                   Repository     Size
==========================================================================================
Installing:
 postgresql-server          x86_64          8.1.11-1.el5_1.1          base          3.9 M

Transaction Summary
==========================================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 3.9 M
Is this ok [y/N]: y

足りてなかった
# service postgresql start
データベースを初期化中:                                    [  OK  ]
postgresql サービスを開始中:                               [  OK  ]

# su - postgres -c psql
Welcome to psql 8.1.11, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# create database foo;
CREATE DATABASE
postgres=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 foo       | postgres | UTF8
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(4 rows)

はい。OK。

# top

top - 11:14:43 up 32 min,  1 user,  load average: 0.00, 0.02, 0.00
Tasks:  79 total,   1 running,  78 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.0%us,  0.0%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.1%st
Mem:    262364k total,   256804k used,     5560k free,     6720k buffers
Swap:   524280k total,        0k used,   524280k free,   162292k cached

はい。撤収！

時間と値段

Total Uptime uses the following format: Days Hours:Minutes:Second
1 Servers
(Showing 1 to 1)
 Server Name Disk Space (GB) Bandwidth In (GB) Bandwidth Out (GB) Total Uptime Running Charges
 rackspacedatabase 10 0.00 0.00 0 Day(s) 00:39:49 $0.01

Comments