PostgreSQL Guide分析和总结分析和总结.docxVIP

PostgreSQL Guide Content: Introduction PostgreSQL introduction When talking to most developers about the different database solutions to use, two major databases will usually form the answer. One would be MySQL, and the other is what this document will refer to, PostgreSQL. The advantages of one over the other is a somewhat long winded debate, however it is just to say that PostgreSQL has had a more firm grasp on true relational database structure than MySQL. Most of the standard features such as FOREIGN KEY was only just added in MySQL 5. However, whatever the case may be, this document assumes that you have selected PostgreSQL as the database to use. The first place to start is the emerge process. In the next section, the installation process through emerge will be described, as well as the basic configuration. PostgreSQL installation To begin, we must first emerge the PostgreSQL package. To do so, run the following code to firstensure that the options for it are properly set: Code Listing 1.1: Checking the PostgreSQL build options Code Listing 1.1: Checking the PostgreSQL build options # emerge -pv postgresql These are the packages that I would merge, in order: Calculating dependencies ...done! [ebuild N ] dev-db/postgresql-8.0.4 -doc -kerberos +nls +pam +perl -pg-intdatetime +python +readline (-selinux) +ssl -tcl +xml +zlib 0 kB Heres a list of what the different build options indicate: USE Flag Meaning This USE flag enables or disables the installation of documentation outside of the standard man pages. The one doc kerberos good time to disable this option is if you are low on space, or you have alternate methods of getting a hold of the documentation (online, etc.) When connecting to the database, with this option enabled, the admin has the option of using kerberos to authenticate their users/services to the database. nls If this option is enabled, PostgreSQL can utilize translated strings for non-English speaking users. If this option is enabled, and the adm