akonadi server isn't work with postgresql-server-9.3.0. Errors like this: xxx@devdb ~/temp/2 $ akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.7.3", "/usr/bin", "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin", "/usr/lib/postgresql/9.0/bin", "/usr/lib/postgresql/9.1/bin") Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) search paths: ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.7.3") Error during executing query "INSERT INTO MimeTypeTable (name) VALUES (:0) RETURNING id" : "ERROR: duplicate key value violates unique constraint "mimetypetable_name_key" ПОДРОБНОСТИ: Key (name)=(\x6170706c69636174696f6e2f782d766e642e616b6f6e6164692e63616c656e6461722e746f646f) already exists. (23505) QPSQL: Unable to create query" search paths: ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") search paths: ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") search paths: ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") search paths: ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled Error during executing query "SELECT id, name FROM FlagTable WHERE ( name = ( :0 ) )" : "ERROR: invalid input syntax for type bytea СТРОКА 1: EXECUTE qpsqlpstmt_48 ('\SEEN') etc...
Was it working previously with an older version, or it this the first time you are using akonadi?
With postgresql-server-9.2.4 was all fine.
By chance, what version of qtsql are you running? This could be solved by the recently released but yet-to-be-version-bumped akonadi-server-1.10.3.
You could try this patch instead of waiting for 1.10.3: https://bugs.kde.org/show_bug.cgi?id=252120#c9
Uncomment line standard_conforming_strings = on in postgresql.conf seems solved my problem.
Thanks you all. This is fixed in cvs now. Please sync in some hours to get the changes. + + 09 Oct 2013; Johannes Huber <johu@gentoo.org> +akonadi-server-1.10.3.ebuild, + -akonadi-server-1.10.2-r1.ebuild, + -files/akonadi-server-1.10.2-datastore_query_fix.patch: + Version bump fixes bug #484572. Remove old. +