http://www.abetake.com/mediawiki/index.php?action=history&feed=atom&title=PostgreSQL_11.2%28RPM%29
PostgreSQL 11.2(RPM) - 版の履歴
2026-05-30T22:03:22Z
このウィキのこのページに関する変更履歴
MediaWiki 1.39.3
http://www.abetake.com/mediawiki/index.php?title=PostgreSQL_11.2(RPM)&diff=18&oldid=prev
T.Abe: ページの作成:「==インストール== ==='''本家のリポジトリを追加する'''=== <syntaxhighlight lang="bash"> [root@XXXXX ~]# su - rpmdevel [rpmdevel@XXXXX ~]$ cd /home/rpmdevel/src [rpmdevel@XXXXX ~]$ wget https://yum.postgresql.org/11/redhat/rhel-6-i386/pgdg-centos11-11-2.noarch.rpm [rpmdevel@XXXXX ~]$ sudo rpm -ivh /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm 警告: /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm: ヘッダ V4 DSA/SHA1 Signature, key ID *…」
2023-05-11T00:18:30Z
<p>ページの作成:「==インストール== ==='''本家のリポジトリを追加する'''=== <syntaxhighlight lang="bash"> [root@XXXXX ~]# su - rpmdevel [rpmdevel@XXXXX ~]$ cd /home/rpmdevel/src [rpmdevel@XXXXX ~]$ wget https://yum.postgresql.org/11/redhat/rhel-6-i386/pgdg-centos11-11-2.noarch.rpm [rpmdevel@XXXXX ~]$ sudo rpm -ivh /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm 警告: /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm: ヘッダ V4 DSA/SHA1 Signature, key ID *…」</p>
<p><b>新規ページ</b></p><div>==インストール==<br />
==='''本家のリポジトリを追加する'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# su - rpmdevel<br />
[rpmdevel@XXXXX ~]$ cd /home/rpmdevel/src<br />
[rpmdevel@XXXXX ~]$ wget https://yum.postgresql.org/11/redhat/rhel-6-i386/pgdg-centos11-11-2.noarch.rpm<br />
<br />
[rpmdevel@XXXXX ~]$ sudo rpm -ivh /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm<br />
警告: /home/rpmdevel/src/pgdg-centos11-11-2.noarch.rpm: ヘッダ V4 DSA/SHA1 Signature, key ID ********: NOKEY<br />
準備中... ########################################### [100%]<br />
1:pgdg-centos11 ########################################### [100%]<br />
</syntaxhighlight ><br />
<br><br />
<br />
==='''リポジトリの確認'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# yum list | grep postgresql<br />
<br />
postgresql11.i686 11.2-2PGDG.rhel6 @pgdg11<br />
postgresql11-devel.i686 11.2-2PGDG.rhel6 @pgdg11<br />
postgresql11-libs.i686 11.2-2PGDG.rhel6 @pgdg11<br />
postgresql11-server.i686 11.2-2PGDG.rhel6 @pgdg11<br />
bacula-director-postgresql.i686 5.0.0-13.el6 base<br />
bacula-storage-postgresql.i686 5.0.0-13.el6 base<br />
freeradius-postgresql.i686 2.2.6-7.el6_9 base<br />
pcp-pmda-postgresql.i686 3.10.9-9.el6 base<br />
postgresql.i686 8.4.20-8.el6_9 base<br />
postgresql-contrib.i686 8.4.20-8.el6_9 base<br />
postgresql-devel.i686 8.4.20-8.el6_9 base<br />
postgresql-docs.i686 8.4.20-8.el6_9 base<br />
postgresql-jdbc.noarch 42.2.5-1.rhel6.1 pgdg11<br />
postgresql-jdbc-javadoc.noarch 42.2.5-1.rhel6.1 pgdg11<br />
postgresql-libs.i686 8.4.20-8.el6_9 base<br />
postgresql-odbc.i686 08.04.0200-1.el6 base<br />
postgresql-plperl.i686 8.4.20-8.el6_9 base<br />
postgresql-plpython.i686 8.4.20-8.el6_9 base<br />
postgresql-pltcl.i686 8.4.20-8.el6_9 base<br />
postgresql-server.i686 8.4.20-8.el6_9 base<br />
postgresql-test.i686 8.4.20-8.el6_9 base<br />
postgresql-unit94.i686 2.0-1.rhel6 pgdg94<br />
postgresql-unit94-debuginfo.i686 2.0-1.rhel6 pgdg94<br />
postgresql-unit96.i686 2.0-1.rhel6 pgdg96<br />
postgresql-unit96-debuginfo.i686 2.0-1.rhel6 pgdg96<br />
postgresql10.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-contrib.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-debuginfo.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-devel.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-docs.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-libs.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-odbc.i686 11.00.0000-1PGDG.rhel6 pgdg10<br />
postgresql10-plperl.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-plpython.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-pltcl.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-server.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql10-tcl.i686 2.4.0-1.rhel6 pgdg10<br />
postgresql10-tcl-debuginfo.i686 2.3.1-1.rhel6 pgdg10<br />
postgresql10-test.i686 10.7-2PGDG.rhel6 pgdg10<br />
postgresql11-contrib.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-debuginfo.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-docs.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-odbc.i686 11.00.0000-1PGDG.rhel6 pgdg11<br />
postgresql11-plperl.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-plpython.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-pltcl.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql11-tcl.i686 2.4.0-2.rhel6.1 pgdg11<br />
postgresql11-test.i686 11.2-2PGDG.rhel6 pgdg11<br />
postgresql94.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-contrib.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-debuginfo.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-devel.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-docs.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-jdbc.i686 9.3.1101-1PGDG.rhel6 pgdg94<br />
postgresql94-jdbc.noarch 9.4.1207-1.rhel6 pgdg95<br />
postgresql94-jdbc-debuginfo.i686 9.3.1101-1PGDG.rhel6 pgdg94<br />
postgresql94-jdbc-javadoc.noarch 9.4.1207-1.rhel6 pgdg95<br />
postgresql94-libs.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-odbc.i686 11.00.0000-1PGDG.rhel6 pgdg94<br />
postgresql94-odbc-debuginfo.i686 09.03.0400-1PGDG.rhel6 pgdg94<br />
postgresql94-plperl.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-plpython.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-pltcl.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-server.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql94-tcl.i686 2.4.0-1.rhel6 pgdg94<br />
postgresql94-tcl-debuginfo.i686 2.3.1-1.rhel6 pgdg94<br />
postgresql94-test.i686 9.4.21-1PGDG.rhel6 pgdg94<br />
postgresql95.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-contrib.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-debuginfo.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-devel.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-docs.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-libs.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-odbc.i686 11.00.0000-1PGDG.rhel6 pgdg95<br />
postgresql95-odbc-debuginfo.i686 09.03.0400-1PGDG.rhel6 pgdg95<br />
postgresql95-plperl.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-plpython.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-pltcl.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-server.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql95-tcl.i686 2.4.0-1.rhel6 pgdg95<br />
postgresql95-tcl-debuginfo.i686 2.3.1-1.rhel6 pgdg95<br />
postgresql95-test.i686 9.5.16-1PGDG.rhel6 pgdg95<br />
postgresql96.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-contrib.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-debuginfo.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-devel.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-docs.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-libs.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-odbc.i686 11.00.0000-1PGDG.rhel6 pgdg96<br />
postgresql96-plperl.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-plpython.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-pltcl.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-server.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql96-tcl.i686 2.4.0-1.rhel6 pgdg96<br />
postgresql96-tcl-debuginfo.i686 2.3.1-1.rhel6 pgdg96<br />
postgresql96-test.i686 9.6.12-1PGDG.rhel6 pgdg96<br />
postgresql_anonymizer10.noarch 0.2.1-1.rhel6 pgdg10<br />
postgresql_anonymizer11.noarch 0.2.1-1.rhel6 pgdg11<br />
postgresql_anonymizer95.noarch 0.2.1-1.rhel6 pgdg95<br />
postgresql_anonymizer96.noarch 0.2.1-1.rhel6 pgdg96<br />
qt-postgresql.i686 1:4.6.2-28.el6_5 base<br />
</syntaxhighlight ><br />
<br><br />
<br />
==='''インストール'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# yum install postgresql11-server postgresql11-devel<br />
</syntaxhighlight ><br />
<br><br />
<br />
=='''確認'''==<br />
*postgres ユーザー<br><br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# id postgres<br />
uid=26(postgres) gid=26(postgres) 所属グループ=26(postgres)<br />
</syntaxhighlight ><br />
<br><br />
<br />
*バージョン<br><br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# psql --version<br />
psql (PostgreSQL) 11.2<br />
</syntaxhighlight ><br />
<br><br />
<br />
*chkconfig<br><br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# chkconfig --list | grep postgresql<br />
postgresql-11 0:off 1:off 2:off 3:off 4:off 5:off 6:off<br />
</syntaxhighlight ><br />
<br><br />
=='''起動'''==<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# /etc/rc.d/init.d/postgresql-11 start<br />
/var/lib/pgsql/11/data is missing. Use "service postgresql-11 initdb" to initialize the cluster first.<br />
[失敗]<br />
</syntaxhighlight ><br />
失敗するので指示の通り、<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# service postgresql-11 initdb -E EUC_JP --no-locale<br />
データベースを初期化中: [ OK ]<br />
</syntaxhighlight ><br />
再度、<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# /etc/rc.d/init.d/postgresql-11 start<br />
postgresql-11 サービスを開始中: [ OK ]<br />
</syntaxhighlight ><br />
<br><br />
<br />
=='''設定'''==<br />
==='''bash_profile'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# su - postgres<br />
[rpmdevel@XXXXX ~]$ vi .bash_profile<br />
<br />
[ -f /etc/profile ] && source /etc/profile<br />
PGDATA=/var/lib/pgsql/11/data<br />
export PGDATA<br />
<br />
↓修正<br />
<br />
[ -f /etc/profile ] && source /etc/profile<br />
PGHOME=/usr/pgsql-11<br />
PGDATA=/var/lib/pgsql/11/data<br />
PATH=$PATH:$PGHOME/bin<br />
export PGHOME PGDATA PGLIB<br />
</syntaxhighlight ><br />
<br><br />
<br />
==='''自動起動'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# chkconfig postgresql-11 on<br />
</syntaxhighlight ><br />
<br><br />
<br />
==='''シンボリックリンクの作成'''===<br />
<syntaxhighlight lang="bash"><br />
[root@XXXXX ~]# ln -s /usr/pgsql-11 /usr/pgsql<br />
</syntaxhighlight></div>
T.Abe