[Owncloud] Setting up owncloud with PostgreSQL

[Saint Germain]

On 27 June 2012 13:13, Robin Appelman <icewind at owncloud.com> wrote:
> On Wednesday 27 June 2012 12:57:41 Saint Germain wrote:
>> On 27 June 2012 10:58, Denis Kot <denis.kot at gmail.com> wrote:
>> > 2012/6/27 Saint Germain <saintger at gmail.com>:
>> >> Hello,
>> >>
>> >> Using Debian Squeeze with owncloud 4.0.3, I am unable to set it up with
>> >> PostgreSQL 9.1.
>> >> Whatever the user/password/dbname I put on the set up page, I got this
>> >> error message:
>> >> can not connect to database, using pgsql. (SQLSTATE[08006] [7]
>> >> fe_sendauth: no password supplied)
>> >>
>> >> I have created a user owncloud and a owncloud database and I have
>> >> manually confirmed with psql that I can connect to it.
>> >>
>> >> I don't understand what is the problem (permission ?) and I don't have
>> >> any other error logs except the above message.
>> >>
>> >> I would really appreciate if someone can give me a hint on how to debug
>> >> this ?
>> >> Even a more meaningful error message could help.
>> >
>> > As far as I know PostgreSQL is not fully supported now. I had many
>> > problems with PostgeSQL and moved to MySQL. So even you resolve your
>> > current issue you'll have many problems in future.
>>
>> It seems that Mr Koeb has more or less managed to install it and use it:
>> http://mail.kde.org/pipermail/owncloud/2011-December/001903.html
>>
>> Mr Koeb can you confirm that you have managed to use owncloud with
>> PostgreSQL ? Otherwise as I'm new with owncloud I won't insist with
>> PostgreSQL
>>
>> Thanks !
>
> I use postgresql with ownCloud for one of the installations, and while it does
> work, it's a lot less stable and more prone to get errors then mysql because
> it's less used.
>
> It's definitely adviced atm to use mysql
>

Ok I will use MySQL then. Thanks for the warning !
I am curious though, do you know what was my issue or do you have some
idea to debug it ?
I would be willing to help debug the PostgreSQL backend.

Thanks,