Ubuntu under source installation POSTGREQL PgAdmin3

First, the installation of PostgreSQL

1, the installation of relevant dependencies, under the terminal execution:

sudo apt-get install Zlib1g-dev
sudo apt-get install Libreadline-dev

2. Download the source code to compile

Source: http://www.postgresql.org/ftp/source/

CD $the _dir_of_postgresql

./configure (You can add --prefix=pgsql the path you want to install later to specify the PostgreSQL installation path)

Make
Su
Make install

3. The necessary work after installation

# PostgreSQL cannot run as root user

$ mkdir/usr/local/pgsql/data
$ chown Computer system user name/usr/local/pgsql/data
Su-Computer system user name (this step is generally not, because we do not use the Linux system, we generally do not log on directly with the root)
/usr/local/pgsql/bin/initdb-d/usr/local/pgsql/data

# Create a log file
Touch/usr/local/pgsql/data/logfile
/usr/local/pgsql/bin/postgres-d/usr/local/pgsql/data >logfile 2>&1 &

4. Create Test Database tests

# After this statement is executed, PostgreSQL returns the information "CREATED DATABASE",

# indicates database setup is complete

/usr/local/pgsql/bin/createdb Test

# Enter the test database

/usr/local/pgsql/bin/psql Test

# Enter the Build Table statement:

CREATE TABLE mytable (id varchar (), name varchar (30));

# After completion, you will get a "CREATED" message indicating the success of the establishment.

# now insert a piece of data:

INSERT into mytable values (' Author ', ' Xu yongjiu ');

# Psql returns similar to INSERT 18 1

# Query whether the insert was successful:

SELECT * from MYTABLE;

# Exit Psql:
\q

# Exit Postgres User

Exit

Second, installation Pgadmin

1. Installation dependence:

sudo apt-get install Libxml2-dev

sudo apt-get install Libxslt1-dev

sudo apt-get install Libpq-dev

sudo apt-get install Wx-common Libwxgtk2.8-dev

2. If/usr/lib has libcrypto.so, skip 2 execution 3, otherwise:

Cd/usr/lib
# Create a link, libcrypto.so.x.y.z is a version of Crypto dynamic library file name under your/usr/lib
sudo ln-s libcrypto.so.x.y.z libcrypto.so

3. Switch to your pgadmin extracted directory and execute it in turn:
sudo./configure (--prefix= Specify Installation path--with-pgsql= specify the path of PostgreSQL)
sudo make all
sudo make install

4. Running Pgadmin

Cd/usr/local/pgadmin3/bin

sudo./pgadmin3

5. Create a shortcut

Create a new Pgadmin3.desktop file below the/usr/share/applications path and enter the contents:

[Desktop Entry]
Name=pgadmin3
Comment=pgadmin3
Encoding=utf-8
Exec=/usr/local/pgadmin3/bin/pgadmin3 (Note: Here is the installation path for your pgadmin3)
ICON=/USR/LOCAL/PGADMIN3/PG.XPM (Note: pgadmin3 is not icon, this is generated by me, can be downloaded, into the xpm format, placed under the Pgadmin3 installation path)
Terminal=false
Type=application
Categories=application;development;

Complete!!!!

Ubuntu under source installation POSTGREQL PgAdmin3