Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1     - Docker manage data (Linux)

- Linux System Getting Started Tutorial: How to update outdated version of Ubuntu (Linux)

- Linux common commands MEMO (Linux)

- Ubuntu 14.04 Install WordPress on Nginx (Server)

- Teach you self-built Linux firewall free (Linux)

- CentOS7 installation hardware monitoring for Zabbix enterprise applications (Server)

- Oracle through the alarm log view and inspect the main library, physical and snapshot standby database (Database)

- Linux environment MySQL master-slave synchronization (Database)

- Install Rubinius testing Ubuntu 14.04 native threads (Linux)

- Linux server is how to do after the invasion (Linux)

- Linux, modify / retrieve the root password (Linux)

- Restore Oracle Database Cold backup and database reconstruction emca (Database)

- Use XtraBackup to MySQL database online incremental backup and recovery (Database)

- Using Ruby to build a simple HTTP service and sass environment (Server)

- JavaScript closures and the scope chain (Programming)

- Use matplotlib scientific drawing in Linux (Linux)

- Linux dmidecode command detail (Linux)

- To assign multiple IP addresses NIC on the CentOS 7 (Linux)

- ORA-12154: TNS: could not resolve the connect identifier specified solve (Database)

- Linux Getting Started tutorial: 3D effects and beautify your desktop (Linux)

 
         
  CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1
     
  Add Date : 2016-10-12      
         
       
         
  Preparation Before Installation

# Yum install readline-devel zlib-devel

Download and extract the source code, compile and install

# Wget https://ftp.postgresql.org/pub/source/v9.4.1/postgresql-9.4.1.tar.bz2
# Tar -xjvf postgresql-9.4.1.tar.bz2
# Cd postgresql-9.4.1
# ./configure
# Make
# Make install

--------------------------------------
Add User (root account can not be used to create a database cluster because when below)
# Useradd postgres
# Passwd postgres

Establish good database cluster destination folder
# Mkdir -p / mnt / data / pgsql

# Chown -R postgres / mnt / data / pgsql


Environment variable settings
# Su - postgres

$ Vi .bash_profile
# Postgres
PGDATA = / mnt / data / pgsql
PATH = / usr / local / pgsql / bin: $ PATH
export PGDATA PATH

Let environment variables to take effect
$ Source .bash_profile
--------------------------------------

Create a database cluster
$ Pg_ctl initdb
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

. Success You can now start the database server using:

    / Usr / local / pgsql / bin / postgres -D / mnt / data / pgsql
or
    / Usr / local / pgsql / bin / pg_ctl -D / mnt / data / pgsql -l logfile start

Start the database instance
After setting the PGDATA environment variable, without the -D option
$ Pg_ctl start -l /mnt/data/pgsql/pgsql.log

Close the database instance

$ Pg_ctl stop

Open remote connection
$ Cd / mnt / data / pgsql /
$ Vi pg_hba.conf
    # IPv4 local connections:
    host all all 0.0.0.0/0 trust

$ Vi postgresql.conf
listen_addresses = '*'

Configure the firewall
$ Su - root
# Vi / etc / sysconfig / iptables
-A INPUT -p tcp -m tcp --dport 80 -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 5432 -j ACCEPT
# Service iptables restart

Configuration phppgadmin
Http://phppgadmin.sourceforge.net/doku.php to download version 5.1
Extract to the site directory, rename it to pgadmin
# Cd pgadmin
# Vim conf / config.inc.php
$ Conf [ 'servers'] [0] [ 'host'] = '127.0.0.1';
$ Conf [ 'servers'] [0] [ 'port'] = 5432;
$ Conf [ 'servers'] [0] [ 'pg_dump_path'] = '/ usr / local / pgsql / bin / pg_dump';
$ Conf [ 'servers'] [0] [ 'pg_dumpall_path'] = '/ usr / local / pgsql / bin / pg_dumpall';
$ Conf [ 'extra_login_security'] = false

Once saved, the access path, enter a user name and password to access.
     
         
       
         
  More:      
 
- Why everybody ought to know LLVM (Linux)
- Hands to teach you to solve Ubuntu error message (Linux)
- How to Install Suricata IDS on a Linux system (Server)
- CentOS 6.5_x64 install Oracle 11g R2 (Database)
- Nginx + Tomcat static and dynamic load balancing and separation configuration essentials under Linux (Server)
- ORA-08102 errors (Database)
- MySQL simple operation notes under Linux (Database)
- iTerm - let your command line can also be colorful (Linux)
- To learn from scratch OpenWrt perfect tutorial (Linux)
- Lua study notes under ubuntu (Linux)
- RedHat Linux 9.0 under P4VP-MX motherboard graphics resolution of problems (Linux)
- Java multi-threaded communications pipeline flow (Programming)
- How to use the command line ftp upload and download files (Linux)
- Linux server data backup (Server)
- Using PPA to install the lightweight theme software HotShots 2.1.0 under Ubuntu (Linux)
- Python3 multi-thread download codes (Programming)
- Use Oracle Data Guard to complete cross-platform database migration cases (Database)
- Live Wallpaper for Linux release adds dynamic background (Linux)
- Fedora 22 Server how to upgrade to Fedora 23 Beta Server (Linux)
- VirtualBox snapshots (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.