[Phpwiki-talk] Install: postgresql and config file

[Jean-Christian I. <jea...@mi...>]

I'm trying to get phpwiki up and running with a postgres database and
I'm finding the documentation a bit sparse ...

Here are my questions/comments so far:

#1 Do I need to initdb with any special encoding? (I'm hoping that
phpwiki creates all the tables it needs and with the correct encoding
but I might be wrong). I want to use UTF-8, and have set config.ini to
utf-8 but I am worried that I need to initialize my DB with UTF-8
encoding too ...

In a perfect world phpwiki would create the tables using the encoding
given in config.ini regardless of what initdb did.

#2 How does one describe a DSN in the config file for a postgres DB
running on the same machine as phpwiki? The config.ini file suggests:

dbtype(dbsyntax)://username:password@protocol+hostspec/database

But what is dbtype for postgres? pgsql? postgres? postgresql? And what
is the 'protocol+hostspec' string?

Adding more examples of DSN strings to the config file would be very
useful for first time installers like myself.

#3 From the above example for a DSN I assume that I need to create the
DB myself? I didn't see anywhere in the documentation that said I needed
to create a DB ... why can't phpwiki create the DB itself?

Thanks!

-- 
Jean-Christian Imbeault
Assistant Manager
Technology Department
_____________________________________
Mizuho Securities Co, Ltd.
Tel: (03) 5208-2932 (direct)