ºìÁªLinuxÃÅ»§
Linux°ïÖú
µ±Ç°Î»ÖÃ: ºìÁªLinuxÃÅ»§ > Ubuntu

ubuntuϱàÒë°²×°postgresql 8.2.5

·¢²¼Ê±¼ä:2007-11-27 01:27:00À´Ô´:ºìÁª×÷Õß:Promises
²éÁËһЩ×ÊÁÏ£¬¿ÉÊǺܶ඼²»ÊǺܺÃÓ㬻¹ÊÇ×Ô¼º×ܽáһϰɡ£
ÅäÖñàÒë»·¾³
°²×°libreadline5-dev°ü¿ÉÒÔ½â¾öÕÒ²»µ½readlineµÄÎÊÌ⣺
sudo apt-get install libreadline5-dev

°²×°zlib1g-dev°ü¿ÉÒÔ½â¾öÕÒ²»µ½zlibµÄÎÊÌ⣺
sudo apt-get install zlib1g-dev

ÒÔÉÏÒѾ­ÅäÖúÃÁ˱àÒëpostgresqlµÄ»·¾³¡£
ÒÀ´ÎÖ´ÐÐÒÔÏÂÃüÁ
./configure
sudo gmake
Èç¹ûÄãûÓа²×°gmake ¿ÉÒÔÓÃsudo makeÀ´Ö´ÐÐ

sudo gmake install
ͬÉÏ£¬Èç¹ûûÓÐgmakeµÄ»°£¬ÓÃsudo make installÀ´Ö´ÐÐ
adduser postgres
Ìí¼ÓÒ»¸öÓû§ Ãû×ÖΪ£ºpostgres
mkdir /usr/local/pgsql/data
½¨Á¢Ò»¸ö´æ´¢Êý¾Ý¿âÎļþµÄ Ŀ¼
chown postgres /usr/local/pgsql/data
¸ü¸ÄÕâ¸öĿ¼µÄȨÏÞΪpostgresÒ²¾ÍÊÇÎÒÃǸոս¨Á¢µÄÓû§£¬×¨ÃÅÓÃÀ´²Ù×÷Êý¾Ý¿â
su - postgres
ÒÔpostgresÓû§µÇ¼
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
°ó¶¨Êý¾ÝĿ¼

½Ó×ÅÆÁÄ»Ìáʾ£º
Success. You can now start the database server using:

/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
ÉèÖóɹ¦£¬Äã¿ÉÒÔÓÃ

/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data Æô¶¯Êý¾Ý¿â
Ò²¿ÉÒÔÓÃ
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
ºóÃæ -l logfile ÉèÖÃlogÎļþµÄ´æ·ÅλÖã¬×÷·þÎñÆ÷µÄ»° £¬ÈÕÖ¾ÊǺÜÖØÒªµÄ¡£
Æô¶¯Êý¾Ý¿â£º
ÎÒÑ¡Óãº/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
µ½ÕâÀïÄãµÄÃû×ÖΪpostgresµÄÊý¾Ý¿âÒѾ­Æô¶¯ÁË¡£
°²×°clientÈí¼þ
ÓÃÃüÁî²Ù×÷Êý¾Ý¿â»¹ÊDz»·½±ã£¬ÎÒÃÇÐèÒª°²×°pgAdmin À´²Ù×÷Êý¾Ý¿â
sudo apt-get install pgadmin3
°²×°ºÃÖ®ºó
ÔÚ·þÎñÆ÷ÅäÖô°¿ÚÊäÈëÒÔϵÄÐÅÏ¢¾Í¿ÉÒԵǼÄãµÄÊý¾Ý¿âÁË¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ