The hardest part about building and installing PostgreSQL on Mac OS X is deciding what configuration options to use. $ echo 'export TZ=:/etc/localtime' > ~/.bash_profile The environ man page describes TZ and other common environment variables. Set the TZ timezone environment variable. For XML support, you'll need to add a newer version of the libxml2 libraries to your system. Preparing for InstallationĮverything you need to compile and deploy PostgreSQL is already installed on Mac OS X 10.5 (assuming you've installed the optional Developer Tools). PostgreSQL is an excellent relational database management system for professional deployment and is also a sophisticated, inexpensive (free!) database for learning SQL, database administration, and database access from a variety of programming languages. PostgreSQL is widely regarded as the most advanced open-source database server with high compliance with SQL:2003, inner and outer joins, views, subselects, foreign keys, triggers, secure connections, and having advanced transactional safety. Development left Berkeley in that year to be managed by a world-wide group of open-source developers. The Berkeley Postgres code was resurrected in 1995 as "Postgres95," and renamed "PostgreSQL" in 1996. During the financial upheavals of the late 1990s, Illustra was bought by Informix, which was in turn bought by IBM. Development continued at Berkeley from 1986 to 1994 under the project name "Postgres." In 1994, Illustra Information Technologies used the Postgres code to develop their successful multimedia database. In 1985, the Ingres Corporation used the code to produce one of the first commercially successful relational database servers. PostgreSQL is an object-relational database management system descended from the database project Ingres (named after the famous painter), developed at UC Berkeley from 1977 to 1985.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |