[Owncloud] Setting up owncloud with PostgreSQL

[Saint Germain]

On Sat, 30 Jun 2012 01:36:22 +0200, Saint Germain <saintger at gmail.com>
wrote :

> On Fri, 29 Jun 2012 19:06:43 -0400, Michael Gapczynski
> <mtgap at owncloud.com> wrote :
> 
> > On Saturday, June 30, 2012 01:00:06 AM Saint Germain wrote:
> > > On Sat, 30 Jun 2012 00:02:00 +0200, eMerzh <merzhin at gmail.com>
> > > wrote :
> > > > I'm not in front of my computer right now...so i'll have to look
> > > > deeper but as safe check :
> > > > 1) do you have change the listen address of PG?
> > > > 2) when you try with psql do you correctly add the -h option?
> > > > 3) is your DB host correct ?
> > > > 
> > > > Normally the current oc installation ask for a DB and a user but
> > > > it create another DB and user with a random password ..
> > > 
> > > Hello !
> > > 
> > > 1) I have used the default installation of PostgreSQL and haven't
> > > changed anything. So it's listening on port 5432.
> > > 
> > > 2) Using:
> > > psql -U owncloud -d owncloud -h localhost
> > > I can connect without problem
> > > 
> > > 3) DB host is "localhost"
> > > 
> > > I have given the user owncloud all superuser privileges (including
> > > create users and create databases).
> > > 
> > > Thanks for your help !
> > 
> > Are you sure PHP can connect to PostgreSQL? It should be in your
> > php.ini: extension="pgsql.so"
> > 
> 
> No it was not in my /etc/php5/cli/php.ini or in
> my /etc/php5/apache2/php.ini.
> I tried adding that to both and restarted apache2, but no improvement.
> 
> On the other hand, no extension=mysql.so is written, but it works
> perfectly with MySQL ?
> 

Oh and I checked with phpinfo() and pdo_pgsql and pgsql do appear (even
without the extension line in php.ini).