Welcome to the Postgres magazine

When I decided to move to OpenERP, I had to move also to supporting technologies. Python of course (on which I still have a mixed feeling...) and Postgres.

Just one sentence : I love Postgres. It is enterprise ready, robust, extensible it is SQL and now noSQL etc etc

So join me and read pgmag.org

http://pgmag.org !

Accessing postgress Meta - info ANSI catalog

A short example : to get columns...

SELECT
  columns.table_catalog,
  columns.table_schema,
  columns.table_name,
  columns.column_name
FROM
  information_schema.columns;

Open ERP - startup up issue on Linux / Ubuntu

An error such as:

INFO:dbpool:Connecting to template1
[2009-07-09 15:48:45,096] ERROR:dbpool:Unable to connect to template1: FATAL: Ident authentication failed for user "chanon".

Means you cannot connect to Postgres for security reason. Under Ubuntu, it may be worth trying " sudo -u postgres python openerp-server.py". So you start as the postgres user (will require the super user password).