Store for PostgreSQL for Dummies (Windows)

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

I just did some editing of the Wiki page, my edits are marked by using
italic characters,
please feel free to ask if anything I wrote only leaves question marks
and please feel free to
edit as you like, my texts are more hints as to what I believe would be
the answers to your questions.

Hth,
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

I guess that should be for Dummies and Bad Typists.  The page has been
renamed with the proper spelling of 'PostgreSQL' (thanks Malte):

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

Dave

Dave Stevenson wrote: