the process of Yum installation PostgreSQL 9.3.x in CentOS 6.x environment
PostgreSQL is a very complex object-relational database management system (ORDBMS), and it is also the most powerful, richest and most complex free software database system at present. Some features are not even available in the commercial database. The Berkeley (BSD) database research program has now evolved into an international development project and has a very wide range of users.
The following records a brief process of Yum installation Postgres 9.3 in CentOS 6.3 environments.
1. View Installed packages
# Rpm-qa|grep Postgres
If already exist
Unloading
# RPM-E postgresql92-server-9.2.4-1pgdg.rhel6.i686
# RPM-E postgresql92-contrib-9.2.4-1pgdg.rhel6.i686
# RPM-E postgresql92-9.2.4-1pgdg.rhel6.i686
# RPM-E postgresql92-libs-9.2.4-1pgdg.rhel6.i686
2. Yum installation
Yum Install http://yum.postgresql.org/9.3/RedHat/rhel-6-x86_64/pgdg-redhat93-9.3-1.noarch.rpm
Yum Install Postgresql93-server Postgresql93-contrib
Class
Service postgresql-9.3 Initdb
Open
Service postgresql-9.3 Start or
/etc/init.d/postgresql-9.3 start
View installation Results
rpm-aq| grep postgres
Can see
[ROOT@I-87-575-VM vmuser]# rpm-aq| grep postgres
Postgresql93-libs-9.3.4-1pgdg.rhel6.x86_64
Postgresql93-contrib-9.3.4-1pgdg.rhel6.x86_64
Postgresql93-9.3.4-1pgdg.rhel6.x86_64
Postgresql93-server-9.3.4-1pgdg.rhel6.x86_64
The instructions are already installed.
3. Test
[ROOT@I-87-575-VM vmuser]# Su-postgres
-bash-4.1$ psql-l
The default password is blank, we need to change to the specified password, which is set to ' Postgres '.
-bash-4.1$ Psql
PostgreSQL database defaults to create a postgres database user as the administrator of the database, the default password is empty, we need to modify the specified password, which is set to ' Postgres '.
# ALTER USER postgres with PASSWORD ' postgres ';
# select * from Pg_shadow;
CentOS 6.x installation PostgreSQL 9.3.x error: Jade:command not found
1
[Root@pghost1 postgresql-9.3.5]#./configure--prefix=/opt/pgsql9.3.5--with-pgport=1949--with-perl--WITH-TCL-- With-python--with-openssl--with-pam--without-ldap--with-libxml--with-libxslt-- With-wal-blocksize=8--with-blocksize=8 && Gmake World
...
GMAKE[3]: Jade:command not found
GMAKE[3]: * * * [Html.index] Error 127
GMAKE[3]: Leaving directory '/ROOT/BACKUP/POSTGRESQL-9.3.5/DOC/SRC/SGML '
GMAKE[2]: * * * [ALL] Error 2
GMAKE[2]: Leaving directory '/ROOT/BACKUP/POSTGRESQL-9.3.5/DOC/SRC '
GMAKE[1]: * * * [ALL] Error 2
GMAKE[1]: Leaving directory '/root/backup/postgresql-9.3.5/doc '
Gmake: * * * [World-doc-recurse] Error 2
[Root@pghost1 postgresql-9.3.5]#
2
The internet is also said to be copy installation files when user Switching caused, mainly file ownership and permissions issues
My process should be no problem, or as follows, continue, or the same mistake
[Root@pghost1 postgresql-9.3.5]# chown-r root:root postgresql-9.3.5/
3
Obviously is the issue of configuring PG-related documents, plus--with-no-docs and--with-no-html-docs continue, and the error remains
Increase--with-no-docs
./configure--prefix=/opt/pgsql9.3.5--with-pgport=1949--with-perl--with-tcl--with-python- With-pam--without-ldap--with-libxml--with-libxslt--enable-thread-safety--with-wal-blocksize=8 8--with-no-docs && Gmake World
4
Tried a pg934 before, the problem remains, and this time the environment virtual machine is new, the problem is left to confirm later
5
Find Jade related packages and install
Yum Search Jade
[Root@pghost1 backup]# yum-y Install openjade.x86_64
6
Again configure problem still
7
Yum-y Install Jadetex.noarch
Yum-y Install Docbook-dtds.noarch
8
Continue configuration, quote the following error:
ERROR: ' collateindex.pl ' is missing on your system.
***
GMAKE[3]: * * * [BOOKINDEX.SGML] Error 1
GMAKE[3]: Leaving directory '/ROOT/BACKUP/POSTGRESQL-9.3.5/DOC/SRC/SGML '
GMAKE[2]: * * * [ALL] Error 2
GMAKE[2]: Leaving directory '/ROOT/BACKUP/POSTGRESQL-9.3.5/DOC/SRC '
GMAKE[1]: * * * [ALL] Error 2
GMAKE[1]: Leaving directory '/root/backup/postgresql-9.3.5/doc '
Gmake: * * * [World-doc-recurse] Error 2
[Root@pghost1 postgresql-9.3.5]#
9
Yum-y Install docbook*
10
continued to succeed at last, and saw the desired result:
Cc-o2-wall-wmissing-prototypes-wpointer-arith-wdeclaration-after-statement-wendif-labels- Wmissing-format-attribute-wformat-security-fno-strict-aliasing-fwrapv-fpic-shared-o pgxml.so XPATH.O XSLT_PROC.O- L.. /.. /src/port-l.. /.. /SRC/COMMON-WL,--as-needed-wl,-rpath, '/opt/pgsql9.3.5/lib ',--enable-new-dtags-lxslt-lxml2
GMAKE[2]: Leaving directory '/ROOT/BACKUP/POSTGRESQL-9.3.5/CONTRIB/XML2 '
GMAKE[1]: Leaving directory '/root/backup/postgresql-9.3.5/contrib '
PostgreSQL, contrib, and documentation successfully made. Ready to install.
[Root@pghost1 postgresql-9.3.5]#
11
Subsequent operation is normal
To sum up, it is as follows.
Yum-y Install openjade.x86_64
Yum-y Install Jadetex.noarch
Yum-y Install docbook*