[Owncloud] Setting up owncloud with PostgreSQL

[Saint Germain]

On Fri, 29 Jun 2012 19:41:50 -0400, Michael Gapczynski
<mtgap at owncloud.com> wrote :

> On Saturday, June 30, 2012 01:36:22 AM Saint Germain 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 ?
> > 
> > Thanks for your help.
> 
> Have you checked phpinfo() that PostgreSQL support is enabled?

Just sent the email. I have anticipated your question, good ! ;-)