Antw: Store for PostgreSQL for Dummies (Windows)

First I would suggest renaming the page to the appropriate name
PostgreSQL for Windows, you've got a typo in the title.. (you only want
to list there how to setup PostgreSQL on windows,
not Store on Windows, correct?) I'll try to answer later with some, more
useful information,
currently I don't have the resources available.

Best regards,
Malte Zacharias

>>> Dave Stevenson <[hidden email]> 23.08.06 6.39 Uhr >>>
I'm having a bit of trouble setting up a personal Store repository using

PostgreSQL on my Windows box.  In particular, I find gaps in the docs
and tips on the web.  I'd like to get help from the vwnc community and
update this wiki page with your input:

        http://wiki.cs.uiuc.edu/VisualWorks/PosgtreSQL+for+Windows

Below is what I've got on that page so far, so please send me feedback
until this is polished and clear for the db-challenged (like me).

Thanks,

Dave


PosgtreSQL for Windows

back to PostgreSQL Administration

These instructions describe installing version 8.1.4 of a PostgreSQL
server on Windows, and connecting to it from VisualWorks 7.4.1. If you
only want to set up the client, see:

     * $VISUALWORKSdocSourceCodeMgmtGuide.pdf (chapter 5, section
"Connecting to the database").

Download PostgreSQL for Windows (and read the README file) here, and
unzip the downloaded archive to a temp directory.

While the PostgreSQL Windows Installer Walkthrough has tips and
screenshots, it does not say how to start the installer. Two .msi files
are included in the download, double-click the smaller one:

     * postgresql-8.1.msi

Follow the instructions in the walkthrough, but supplement them with
these instructions as well. On the "Installation options" screen, which
options will I need for a simple local repository?

     * psql could be useful
     * pgAdmin III could be useful
     * what else should be installed?
     * what can be left out for the simple store user?

Service configuration:

     * I haven't a clue...

Initialise database cluster

     * do we need to set the encoding to UTF8?
     * is postgres ok for superuser, or do we need BERN or something
else?

Precedural languages:

     * sounds vaguely familiar... primitive, but familiar. I presume we
don't need these?

Contrib modules

     * do we need any of these?

Enable PostGIS

     * I presume we don't need this?

Now, did we create a store database, or just some default database? Once

we decide what database to use, we set up the store tables, right? Now
we follow the procedures in chapter 3 of
$VISUALWORKSdocSourceCodeMgmtGuide.pdf, section "PostgreSQL setup".
However, this seems to assume the server is running on linux. Do we need

to change anything here for win?

Now that we've got the Store schema set up, we need to connect to it
from VW. Assuming we gave concrete examples of user and database names
throughout the installation, what do we put in our store connection
dialog now?

back to PostgreSQL Administration