Puas tau xav teeb tsa PostgreSql server nrog qee qhov kev xaiv xaiv? Xav tau los teeb tsa PostgreSQL server los ntawm qhov chaws hloov chaw ua ntej teeb tsa pob? Kab lus no qhia koj los ntawm cov txheej txheem teeb tsa luv kom tau txais PostgreSql server thiab ua haujlwm!
Cov kauj ruam
Kauj Ruam 1. Tau txais qhov chaws los ntawm PostgreSQL lub vev xaib [1]
Kauj ruam 2. Unpack the source code package
Siv cov lus txib nram qab no bash/console:
gunzip postgresql-8.3.3.tar.gz
tar xf postgresql-8.3.3.tar
- postgresql-8.3.3 yog lub npe tam sim no. Cov ntawv yav tom ntej yuav txawv hauv 8.3.3 ib feem.
-
Cov npe hu ua postgresql-8.3.3 yuav raug tsim nyob rau hauv cov npe tam sim no (ib qho uas koj tau ua tiav tsab ntawv saum toj no los ntawm).
Nruab PostgreSQL Siv Tus Txheej Txheem Code Kauj Ruam 2 Bullet 2
Kauj Ruam 3. Hloov cov npe tam sim no mus rau ib qho tshiab uas tsim (postgresql-8.3.3)
Kauj Ruam 4. Kho lub hauv paus ntoo rau koj qhov system thiab xaiv cov kev teeb tsa uas koj xav tau:
-
Default Configuration: khiav qhov hais kom ua
./configure
ntawm koj lub bash/console
- Custom Configuration (qhov no yog rau cov neeg siv qib siab nkaus xwb): koj tuaj yeem teeb tsa ntau qhov kev teeb tsa kev cai siv cov kab hais kom ua xaiv nyob hauv PostgreSQL cov ntaub ntawv [2]
Kauj Ruam 5. Pib txheej txheem tsim los ntawm kev ua kab hais kom ua
ua gmak
hauv koj lub console/bash.
Qhov no yuav siv sijhawm li ob peb feeb nyob ntawm koj lub khoos phis tawj. Kab kawg tso tawm yuav tsum yog:
Txhua yam ntawm PostgreSQL tau ua tiav. Npaj rau nruab.
Kauj Ruam 6. Nruab PostgreSql cov ntaub ntawv los ntawm kev ua haujlwm bash/console hais kom ua:
gmake nruab
uas yuav teeb tsa cov ntaub ntawv rau/usr/local/pgsql tshwj tsis yog koj siv qhov --prefix = PREFIX hais kom ua kab xaiv, nyob rau hauv rooj plaub twg cov ntaub ntawv yuav raug teeb tsa rau txoj hauv kev teev tseg los ntawm PREFIX
Kauj Ruam 7. Tsim tus lej super-user rau PostgreSQL los ntawm kev ua cov lus txib hauv qab no hauv bash console:
adduser postgres
Kauj Ruam 8. Tsim cov npe los tuav PostgreSQL cov ntaub ntawv ntoo los ntawm kev ua cov lus txib hauv qab no hauv bash console:
mkdir/p01/pgsql/cov ntaub ntawv
chown postgres/p01/pgsql/cov ntaub ntawv
Kauj Ruam 9. Tsim PostgreSQL pawg los ntawm kev ua:
su - postgres
/usr/local/pgsql/bin/initdb -D/p01/pgsql/cov ntaub ntawv
Kauj ruam 10. Pib li PostgreSQL server (tus txheej txheem xa ntawv) los ntawm kev ua:
/usr/local/pgsql/bin/postmaster -D/p01/pgsql/data> logfile 2> & 1 &
Kauj Ruam 11. Tsim PostgreSQL database hauv pawg los ntawm kev ua:
/usr/local/pgsql/bin/createdb xeem
Kauj Ruam 12. Nkag mus-rau hauv lub database siv psql hais kom ua:
/usr/local/pgsql/bin/psql xeem
Txoj Kev 1 ntawm 1: Ua tiav Cov Lus Qhia
Nov yog daim ntawv teev tag nrho cov lus txib kom ua tiav uas tau piav qhia hauv kab lus no txhawm rau teeb tsa server. Qhov no tuaj yeem raug cawm mus rau hauv tsab ntawv kom ua tiav tom qab.
./configure
ua gmak
su
gmake nruab
adduser postgres cov
mkdir/usr/local/pgsql/cov ntaub ntawv
chown postgres/usr/local/pgsql/cov ntaub ntawv
su - postgres
/usr/local/pgsql/bin/initdb -D/usr/local/pgsql/cov ntaub ntawv
/usr/local/pgsql/bin/postgres -D/usr/local/pgsql/data> logfile 2> & 1 &
/usr/local/pgsql/bin/createdb xeem
/usr/local/pgsql/bin/psql xeem
