Zaurus ÖÐÎÄÂÛ̳

[badog]

ÓõÄÈËÉÙ,²»·­ÒëÁË:
¼ò½é
http://www.postgresql.org/
PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

ÏÂÔØ
http://mail.pdaxrom.org/contrib/desertrat/postgresql-client_8.1.3_armv5tel.ipk
this package provides the psql command line client. If you wish to use SSL connections you will need to install openssl.
¹¤¾ß:
http://mail.pdaxrom.org/contrib/desertrat/postgresql-tools_8.1.3_armv5tel.ipk
this package provides tools for commonly performed tasks. These are clusterdb, createdb, createlang, createuser, dropdb, droplang, dropuser, pg_dump, pg_dumpall, pg_restore, reindexdb, vacuumdb. If you wish to use SSL connections you will need to install openssl.
·þÎñÆ÷²¿·Ö:
http://mail.pdaxrom.org/contrib/desertrat/postgresql-server_8.1.3_armv5tel.ipk
this package contains the server. See notes below for quick start instructions. If you wish to use SSL connections you will need to install openssl.
À©Õ¹:
http://mail.pdaxrom.org/contrib/desertrat/postgresql-devel_8.1.3_armv5tel.ipk
this contains the header and static library files.

notes
All the postgresql components are installed in
/usr/local/postgresql. For convenience you may want to edit /etc/profile and add /usr/local/postgresql/bin to the PATH.

ÈçºÎ¿ªÊ¼

1) create a new user to handle the database, in this example
the user will be 'postgres' and its home directory will be
'/mnt/hd/store/postgres'. Make sure there is enough free space in
that partition to store your data.
CODEadduser -D -h /mnt/hd/store/postgres postgres
2) login as the newly created user
CODEsu - postgres

3) create a directory for your database
CODEmkdir data

4) tell postgresql to create your database cluster
CODEinitdb -D ~/data/

5) to start postgresql server
CODEpg_ctl -D /mnt/hd/store/postgres/data -l /dev/null start

6) to stop postgresql server
CODEpg_ctl -D /mnt/hd/store/postgres/data stop

7) read manual for full details

http://www.postgresql.org/docs/8.1/static/index.html

For extra convenience you may want to create these aliases for starting/stopping the postgresql server:

CODEalias pgstart='su - postgres -c '\''pg_ctl -D /mnt/hd/store/postgres/data -l /dev/null start'\'''
alias pgstop='su - postgres -c '\''pg_ctl -D /mnt/hd/store/postgres/data stop'\'''