Project

General

Profile

Bug #638

PostgreSQL database creation / merge fails.

Added by th0br0 over 15 years ago. Updated over 15 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Quassel Core
Target version:
-
Start date:
03/21/2009
Due date:
% Done:

0%

Estimated time:
Version:
0.4.0+
OS:
Linux

Description

Hi,
I got a fresh git clone running here.
Yet, the PostgreSQL backend doesn't work.
Regardless of whether I'm attempting to convert an SQLite database to PostgreSQL or try to initialize one, PostgreSQL query errors are reported:

2009-03-21 15:43:32 Error: Storage Schema is missing!  
2009-03-21 15:43:32 Error: unhandled Error in QSqlQuery!  
2009-03-21 15:43:32 Error:                   last Query: CREATE INDEX backlog_bufferid_idx ON backlog(bufferid, messageid DESC)  
2009-03-21 15:43:32 Error:               executed Query:   
2009-03-21 15:43:32 Error:                 bound Values:   
2009-03-21 15:43:32 Error:                 Error Number: -1  
2009-03-21 15:43:32 Error:                Error Message: ERROR:  syntax error at or near "DESC" at character 66QPSQL: Unable to create query  
2009-03-21 15:43:32 Error:               Driver Message: QPSQL: Unable to create query  
2009-03-21 15:43:32 Error:                   DB Message: ERROR:  syntax error at or near "DESC" at character 66  
2009-03-21 15:43:32 Error: Unable to setup Logging Backend!  
2009-03-21 15:43:32 Error: Selected storage backend is not available: "PostgreSQL" 

PostgreSQL version: 8.0.15
Distribution: Gentoo Hardened

I followed the howto on the wiki, permissions are set correctly. As you can see, connection and interaction to / with PostgreSQL is working fine.

History

#1 Updated by EgS over 15 years ago

  • Status changed from New to Rejected

Quassel requires Postgres Version 8.3.0+

I think we should put that into the wiki :)

Also available in: Atom PDF