PostgreSQL インストール
- インストール前に以下のインストールすると良いかも
======================================================================
Package Arch Version Repository Size
======================================================================
Installing:
postgresql-server x86_64 8.1.22-1.el5_5.1 updates 3.9 M
Installing for dependencies:
postgresql x86_64 8.1.22-1.el5_5.1 updates 2.9 M
- elmarverde% sudo yum install mod_auth_pgsql
======================================================================
Package Arch Version Repository Size
======================================================================
Installing:
mod_auth_pgsql x86_64 2.0.3-2.3.1 base 22 k
- elmarverde% su - root
パスワード:
- root% su - postgres
- postgres% initdb /var/lib/pgsql/data/
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale ja_JP.UTF-8.
The default database encoding has accordingly been set to UTF8.
fixing permissions on existing directory /var/lib/pgsql/data ... ok
creating directory /var/lib/pgsql/data/global ... ok
creating directory /var/lib/pgsql/data/pg_xlog ... ok
creating directory /var/lib/pgsql/data/pg_xlog/archive_status ... ok
creating directory /var/lib/pgsql/data/pg_clog ... ok
creating directory /var/lib/pgsql/data/pg_subtrans ... ok
creating directory /var/lib/pgsql/data/pg_twophase ... ok
creating directory /var/lib/pgsql/data/pg_multixact/members ... ok
creating directory /var/lib/pgsql/data/pg_multixact/offsets ... ok
creating directory /var/lib/pgsql/data/base ... ok
creating directory /var/lib/pgsql/data/base/1 ... ok
creating directory /var/lib/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
enabling unlimited row size for system tables ... ok
initializing dependencies ... ok
creating system views ... ok
loading pg_description ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Success. You can now start the database server using:
postmaster -D /var/lib/pgsql/data
or
pg_ctl -D /var/lib/pgsql/data -l logfile start
- postgres% exit
- root% exit
- elmarverde% sudo /etc/rc.d/init.d/postgresql start
postgresql サービスを開始中: [ OK ]
- elmarverde% sudo /sbin/chkconfig postgresql on