Support PostgreSQL as back-end storage option

[GoogleCodeExporter]

I propose to include Postgresql as a supported back-end storage option for
elmah. Postgres is a really mature and advanced database with a solid user
and developer community. Elmah with its excellent and simple error logging
now would be available "out of the box" to anyone using psql for their
projects.

I have attached a proposed basic implementation of PsqlErrorLog, as well as
a basic script to create the database table.

Note that this implementation requires a reference to Npgsql (a recommended
.Net data provider for Postgresql). I am not sure if I should include the
dlls in here, but you can get more info on Npgsql here:
http://pgfoundry.org/projects/npgsql/

Original issue reported on code.google.com by lai...@gmail.com on 29 Sep 2009 at 3:15

Attachments:

• PgsqlErrorLog.cs
• PgSQL.sql

[GoogleCodeExporter]

I have created a branch for this issue:
http://elmah.googlecode.com/svn/branches/issue-136

You can commit, integrate and test your contribution there directly.

When tested and ready, merge to release branch for 1.2 (RB-1.2):
http://elmah.googlecode.com/svn/branches/RB-1.2

Original comment by azizatif on 29 Sep 2009 at 6:20

• Changed title: Support PostgreSQL as back-end storage option
• Changed state: Accepted
• Added labels: Component-Persistence, Milestone-Release1.2

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Implemented in r685 and r689.

Original comment by azizatif on 10 Dec 2009 at 11:37

• Changed state: Fixed