`
uu4u
  • 浏览: 39077 次
  • 性别: Icon_minigender_1
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

[转]PostgreSQL RPM Installation

阅读更多

转:http://wiki.openscg.com/index.php/PostgreSQL_RPM_Installation

 

OpenSCG provides PostgreSQL 9.0 RPM packages for an easy installation experience on Redhat, Fedora, CentOS, OpenSUSE and similar systems. This tutorial explain how to install and configure PostgreSQL using OpenSCG's rpm packages. 

 

Requirements

Appropriate 32 or 64 bit PostgreSQL 9.0 RPM package from OpenSCG.

Installation Steps

The installation of PostgreSQL 9.0 server is very easy. To install:

  • Download and save RPM package.
[user@fedorax64 ~]ls -l postgres-9.0.3-1.x86_64.openscg.rpm 
-rw-r--r--. 1 user user 16389304 Feb  3 12:02 postgres-9.0.3-1.x86_64.openscg.rpm
  • Switch to root user.
[user@fedorax64 ~]su
Password: 
[root@fedorax64 user]#
  • Install the RPM package
[root@fedorax64 user]# rpm -ihv ./postgres-9.0.3-1.x86_64.openscg.rpm 
Preparing...                ########################################### [100%]
   1:postgres-9.0               ########################################### [100%]

PostgreSQL is cleanly installed to the "/opt/postgres/9.0" directory without changing any other shared libraries on your system. All the libraries that PostgreSQL uses are in the "/opt/postgres/9.0/lib" directory to minimize the chances of conflicts and other incompatibilities.

Configure and initializing PostgreSQL Server

OpenSCG's server control script makes it very easy to configure the PostgreSQL server. The 'start' command will attempt to initialize the server on its first usage (technically in the absence of data directory).

  • Enter following command in your shell prompt (as root user):
[root@fedorax64 user]# /etc/init.d/postgres-9.0-openscg start
  • You will be prompted to provide database server port, superuser password and server startup options. You can either press <ENTER> for default values, or you can provide your own customized inputs. Following the inputs, the database cluster will be initialized and server will be started.
[root@fedorax64 user]# /etc/init.d/postgres-9.0-openscg start
PostgreSQL 9.0 Configuration
---------------------------------
This will initialize PostgreSQL database cluster. The following
questions will determine the database server port, superuser password
 and to start server on system boot. Press <ENTER> to accept defaults.

Specify PostgreSQL server port [5432]:

Specify superuser password [password]:
Do you want PostgreSQL server to be started on boot (y/n) [y]:

useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
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 en_US.UTF-8.
The default text search configuration will be set to "english".

fixing permissions on existing directory /opt/postgres/9.0/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 24MB
creating configuration files ... ok
creating template1 database in /opt/postgres/9.0/data/base/1 ... ok
initializing pg_authid ... ok
setting password ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

    /opt/postgres/9.0/bin/postgres -D /opt/postgres/9.0/data
or
    /opt/postgres/9.0/bin/pg_ctl -D /opt/postgres/9.0/data -l logfile start

Configuring PostgreSQL server startup scripts
Starting PostgreSQL 9.0
waiting for server to start.... done
server started
PostgreSQL 9.0 started successfully
To load this postgres into your environment, source the env file:
/opt/postgres/9.0/pg90-openscg.env
  • The server can now be controlled by either using service command and/or by calling the script directly:
[root@fedorax64 user]# service postgres-9.0-openscg status
pg_ctl: server is running (PID: 3291)
/opt/postgres/9.0/bin/postgres "-D" "/opt/postgres/9.0/data"
[root@fedorax64 user]# /etc/init.d/postgres-9.0-openscg status
pg_ctl: server is running (PID: 3291)
/opt/postgres/9.0/bin/postgres "-D" "/opt/postgres/9.0/data"

The server is controlled by postgres operating system user, which will be created (as a locked account) by the configuration script if it does not already exists.

Using the database

After installation, using the database is simple:

/opt/PostgreSQL/9.0/bin/psql -U postgres -d postgres
Password: 
psql (9.0.3)
Type "help" for help.

postgres=#

 

Setting the Environment


The OpenSCG's RPMs do not do anything to your system environment in order to prevent conflicts with other software. If you wish to load the environment for this install, you can use the included env file:

[user@fedorax64 ~]$ . /opt/postgres/9.0/pg90-openscg.env 
[user@fedorax64 ~]$ psql
Password: 
psql (9.0.3)
Type "help" for help.

postgres=#

This will load:

* PGHOME
* PGDATA
* PATH
* LD_LIBRARY_PATH
* PGUSER
* PGDATABASE
* PGPORT

Default database


The default database created at initialization time (as with most other PostgreSQL packages) is:

   postgres

Default username


The default superuser created at initialization time (as with most other PostgreSQL packages) is:

   postgres

Default password


The default password (unless you set it at initialization time) is:

   password

Change the default password


To change the default password, you first need to login to the database with your current password:

/opt/PostgreSQL/9.0/bin/psql -U postgres -d postgres
Password: 
psql (9.0.3)
Type "help" for help.

postgres=#

Now, change the password for the postgres user:

postgres=# ALTER USER postgres WITH PASSWORD 'newpasswordgoeshere';
ALTER ROLE
postgres=#

Now your password is changed.

Forgot my password!


If you've forgotten your password, that's no problem. Here's the reset process:

  • Become the root or postgres user. (Note: postgres might be locked, in which case you must use root account - or unlock postgres account)
[user@fedorax64 ~]su
Password: 
[root@fedorax64 user]#
  • Edit the pg_hba.conf (host based access) file using your favorite editor
[root@fedorax64 user]# vi /opt/postgres/9.0/data/pg_hba.conf
  • Change highlighted line
# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5

by changing connection method from md5 to trust:

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
  • Save your changes
  • Command postgres to re-read it's config file (either as root or postgres user)
[root@fedorax64 user]# /etc/init.d/postgres-9.0-openscg reload
Reloading PostgreSQL 9.0
server signaled
  • Switch to normal user and login to the database (you will not be prompted for password).
[root@fedorax64 user]# exit
exit
[user@fedorax64 ~]$ . /opt/postgres/9.0/pg90-openscg.env 
[user@fedorax64 ~]$ psql
psql (9.0.3)
Type "help" for help.

postgres=#
  • Edit the pg_hba.conf (host based access) file and change trust back to md5 and reload the server.

Uninstalling PostgreSQL Server

The uninstallation of PostgreSQL server can be performed as follows:

  • Switch to root user.
[user@fedorax64 ~]su
Password: 
[root@fedorax64 user]#
  • Uninstall the RPM package
[root@fedorax64 user]# rpm -e postgres-9.0
Attempting to stop server...
Stopping PostgreSQL 9.0
waiting for server to shut down.... done
server stopped
Attempting to update server startup status...
Uninstallation complete.

Note that the data folder is not deleted after uninstallation.

Reporting Bugs/Suggestions

If you have any questions related to rpm installation, or you would like to report any bugs and/or suggestions in OpenSCG's RPM packaging, feel free to join OpenSCG mailing list to discuss.

 

分享到:
评论

相关推荐

    10.Linux-centos7安装jdk&mysql&redis

    sudo yum-config-manager --add-repo https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm ``` 3. **安装JDK**: 使用`yum`命令安装JDK,例如安装JDK 8: ``...

    GPDB安装文档

    GreenPlum Database是一款基于PostgreSQL开发的大规模并行处理(MPP)数据仓库系统,主要用于高效地存储和处理大量数据。GPDB因其强大的数据分析能力,在大数据分析领域被广泛应用。 #### 二、安装前期环境要求 在...

    cnetos7安装zabbix4.0

    - **数据库要求**:支持 MySQL、PostgreSQL 等多种数据库类型。 - **前端要求**:支持 PHP 5.4 或更高版本,同时需要 Apache 或 Nginx 等 Web 服务器。 #### 三、环境配置 为了确保 Zabbix 4.0 在 CentOS 7.4 上...

    在CentOS中部署多节点Citus集群的详细步骤

    ### 在CentOS中部署多节点Citus集群的详细步骤 #### 前言 本文将详细介绍如何在CentOS系统上部署一...- [Citus Data Official Documentation](https://docs.citusdata.com/en/v7.2/installation/production_rhel.html)

    最新mysql ocp 认证 1Z0-883 题库

    但这个选项描述的是PostgreSQL的情况,并不适用于MySQL。选项C指出需要先运行mysql_secure_installation脚本来提高新安装实例的安全性,这在安装MySQL后是推荐的安全实践。 因此,问题的正确答案是B和C,这表明在...

    centos配置redmine

    yum -y install zip unzip libyaml-devel zlib-devel curl-devel openssl-devel httpd-devel apr-devel apr-util-devel mysql-devel gcc ruby-devel gcc-c++ make postgresql-devel ImageMagick-devel sqlite-devel ...

    svn 和各种数据库的安装图解大全

    5. **安全设置**:首次安装后,MySQL会提供一个安全脚本,执行`mysql_secure_installation`,可以删除匿名用户、禁止远程root登录等。 6. **客户端工具**:安装MySQL客户端工具,如MySQL Workbench,用于管理数据库...

    MYSQL

    4.6.1 Linux RPM注意事项 4.6.2 构造客户程序 4.6.3 系统特定的问题 4.6.3.1 Linux 注意事项 4.6.3.2 HP-UX 注意事项 4.7 安装 MySQL源代码分发 4.7.1 快速安装概述 4.7.2 运用补丁...

    MySQL中文参考手册

    o 4.15 安装后期(post-installation)的设置与测试 + 4.15.1 运行mysql_install_db 的问题 + 4.15.2 启动 MySQL 服务器的问题 + 4.15.3 自动启动和停止 MySQL + 4.15.4 选项文件 o 4.16 升级和降级...

    MySQL中文参考手册.chm

    4.13 OS/2 注意事项 4.14 TcX 二进制代码 4.15 安装后期(post-installation)的设置与测试 4.15.1 运行mysql_install_db 的问题 4.15.2 启动 MySQL 服务器的问题 4.15.3 自动启动和停止...

Global site tag (gtag.js) - Google Analytics