Search:  
Gentoo Wiki

HOWTO_Configure_Postgresql


Image:Gentoo_tux.png

Base Install

  1. What is Gentoo?
  2. About
  3. Preparation
  4. Partitioning
  5. Configuring
  6. Stage Progression
  7. Kernel
  8. Bootloader
  9. Test
  10. Converting from or to a non-Gentoo distribution
  11. Troubleshooting
  12. Maintaining

Configuration

Base Extras

Server

Desktop

Other Articles

edit

Contents

About

In almost all programs data storing is an important part of your program. For instance you don't want to configure your Linux kernel every time you boot your system. Now your Linux kernel configuration is stored in clear text and in 1 file on your hard drive so you don't have to worry about it but saving data in clear text and in one file has its limitations. Imagine a bank with thousands of customers and with hundreds of product information to store for each customer. Storing that into one file would simply not fit on the file system and search it for one customer would take forever. To solve this problem database programs were made. The language that most of the database programs use is called SQL.

Now if you have a web application or an application which (potentially) has a lot of information you might want to consider putting the data into a database. That would save you lots of time because you don't have to bother how it is stored or how to search through all the data. Just feed your SQL-statement to the database program and the database program will return the desired information. Now it shouldn't surprise you that many database systems exists today, just summarizing a few: SQLite, mysql or Oracle and many more. Which program works best for you is a matter of checking supported options and testing it. For a small overview of supported options check this page. For the testing part: If you write your SQL statements according to the SQL 92 standard (if you don't need all the fancy new SQL features) almost all database programs will work. And you can simply change the database and update your database connectors and rerun your program without changing your SQL statements.

This tutorial will show you how to install and configure PostgreSQL in Gentoo. PostgreSQL is one of the most powerful open source database programs; the project attempts to implement many high-end features expected out of enterprise database solutions as well as the full the SQL 92 standard, making it a powerful and highly scalable database solution for any configuration (even at home). Please consult the PostgreSQL documentation for any additional information you want since this tutorial only concerns itself with how to install/config and use PostgreSQL.

Subpages

See also

Credits

I have invested quite some time in writing this article and I hope it has and will service you in the future. I started out intending to just merge two PostgreSQL articles which covered more or less the same matter but ended up (re)writing most of the code and adding whole sections as I went along. I would like to thank all people who have contributed in the past to PostgreSQL articles and if your section was somehow forgotten I'm very sorry correct it by adding it. I also would like to ask YOU as reader to keep this article up to date: When new options become available please don't hesitate to add them or if sections become obsolete please remove them. The same is true for language/grammar/spelling and punctuation errors (I know it needs some improvement). Rest me nothing more then to sign off.

--DouweQuerty 15:47, 8 May 2007 (UTC)

Retrieved from "http://www.gentoo-wiki.info/PostgreSQL"

Last modified: Sat, 06 Sep 2008 15:48:00 +0000 Hits: 29,331