PostgreSQL

From GregariusWiki

Jump to: navigation, search

PostgreSQL is a highly scalable, SQL compliant, open source object-relational database management system. Gregarius uses it to store your feeds, their articles and configuration information. Support for PostgreSQL databases is available only in the development versions of Gregarius. Gregarius also supports other databases like MySQL and SQLite. Currently initial PostgreSQL support is targeted for 0.5.5.

Contents

[edit] External Links

[edit] Download

The branch of Gregarius that supports PostgreSQL can be downloaded directly from the Subversion repository: 

 svn co http://svn.gregarius.net/svn/branches/postgresql

See more information on getting Gregarius Source Code.

[edit] Installation

First you will need to read the Installation page.

When it talks about importing the schema manually switch back here and follow along to create the database manually:

  • Start psql as a user that can create users and databases (often postgres): 
$ psql -U postgres -d template1
  • Create a user to own the Gregarius database 
template1=# create user gregarius with password 'supersecret';
  • Create a database for Gregarius 
template1=# create database gregarius with owner=gregarius;
  • Exit psql and reconnect as the new user 
template1=# \q
$ psql -U gregarius -d gregarius
  • Create all the Gregarius objects using the dbstruct.pgsql.sql file 
template1=# \i dbstruct.pgsql.sql
  • Finally create your dbinit.php file as a copy of dbinit.php.sample and edit it with the correct database values.
  • Fire up your web browser and enjoy

[edit] Bug Reports

Please remember that this is a development branch of Gregarius and inherently unstable and some functionality may not even work. That being said, please forward any and all bug reports in one of the following ways:

Retrieved from "http://wiki.gregarius.net/index.php/PostgreSQL"
Personal tools
Advertisement