PostgreSQL 9.1.2 source code compilation

Just getting started with php, and then start compiling the environment, starting with PostgreSQL...

-----------------------------------------------------------

| System | CentOS 5.7.

-----------------------------------------------------------

If you encounter the dependency issue for compiling postgresql, please post it in a text box.

Yum-y install readline-devel

Refer:

PostgreSQL Download PageHttp://www.postgresql.org/ftp/source/

# Mkdir/usr/local/src/postgresql&&Cd/usr/local/src/postgresql

#Wget http://ftp.postgresql.org/pub/source/v9.1.2/postgresql-9.1.2.tar.gz

Extract

#Tar-zxvf postgresql-9.1.2.tar.gz

# Su--c "useradd-M postgres"

#Chown-R postgres: postgres postgresql-9.1.2

Configure Compilation
#./Configure -- help

#./Configure -- prefix =/opt/pgsql-- Sysconfdir =/opt/pgsql/etc

# Mkdir/Opt/pgsql/Data

# Chown postgres: postgres/opt/pgsql/data

Initialization

# Su ipvs

Bash-3.2 $/opt/pgsql/bin/initdb-D/opt/pgsql/data

[Plain]

1. The files belonging to this database system will be owned by user "stored s ".
2. This user must also own the server process.
4. The database cluster will be initialized with locale en_US.UTF-8.
5. The default database encoding has accordingly been set to UTF8.
6. The default text search configuration will be set to "english ".
8. Fixing permissions on existing directory/opt/pgsql/data... OK
9. Creating subdirectories... OK
10. Selecting default max_connections... 100
11. Selecting default shared_buffers... 32 MB
12. Creating configuration files... OK
13. Creating template1 database in/opt/pgsql/data/base/1... OK
14. Initializing pg_authid... OK
15. Initializing dependencies... OK
16. Creating system views... OK
17. Loading system objects 'descriptions... OK
18. Creating collations... OK
19. Creating conversions... OK
20. Creating dictionaries... OK
21. Setting privileges on built-in objects... OK
22. Creating information schema... OK
23. Loading PL/pgSQL server-side language... OK
24. Vacuuming database template1... OK
25. Copying template1 to template0... OK
26. Copying template1 to copying s... OK
28. WARNING: enabling "trust" authentication for local connections
29. You can change this by editing pg_hba.conf or using the-A option
30. Next time you run initdb.
32. Success. You can now start the database server using:
34. /Opt/pgsql/bin/postgres-D/opt/pgsql/data
35. Or
36. /Opt/pgsql/bin/pg_ctl-D/opt/pgsql/data-l logfile start

Add Environment Variables

# Vi/etc/profile

PATH =/opt/pgsql/bin: $ PATH

Export PATH

# Source/etc/profile

Start:

# Mkdir/opt/pgsql/logs/

# Chown postgres: postgres/opt/pgsql/logs/

# Su ipvs

Bash-3.2 $/opt/pgsql/bin/pg_ctl-D/opt/pgsql/data-l/opt/pgsql/logs/pgsql. log start

Set the startup script:

#Su-c"Cp/usr/local/src/postgresql/postgresql-9.1.2/contrib/start-scripts/linux/etc/rc. d/init. d/postgresql-9.1.2"

#Su-c "chmod a + x/etc/rc. d/init. d/postgresql-9.1.2"

#Vi/etc/rc. d/init. d/postgresql-9.1.2

1 2 3 Next Page