< Back to Blogs
PostgreSQL on Windows: A Primer by MichaelF on February 22, 2007 06:06PM

This paper will cover the installation and initial configuration of PostgreSQL 8.2 on Windows up to a point where a database is created and plpgsql is installed in it.  We assume an ability to walk through the install wizard in general, though screens that do require additional information will be covered (with screenshots).  Important options in the postgresql.conf and pg_hba.conf will be covered, as will database creation in PgAdmin III.

Comments RSS
  1. posted at 09:38PM 02/22/2007
  2. einhverfr said:

    It has been pointed out to me by a member of the PostgreSQL core development team that one point in the paper is out of date.  As of PostgreSQL 8.2, PostgreSQL can run under an administrative account on Windows.  It then drops priveleges in order to run in a safe and secure manner.  This is a new change and I appear to have missed it in my review of  the new version.

    Best Wishes,

    Chris Travers

    posted at 03:17PM 02/23/2007
  3. CoqBlog said:

    Depuis sa version 8, PostgreSQL , peut fonctionner nativement sous Windows. Un document couvrant l'installation

    posted at 06:54AM 02/24/2007
  4. Der Originalartikel befindet sich unter:http://people.planetpostgresql.org/dfetter/== Wöchentlicher PostgreSQL Newsletter - 25. Februar 2007 ==Der PostgreSQL Fond bei SPI sponsorte diesen Monat David Fetters Reise zur Consili in Brasilien, wo er eine

    posted at 04:26PM 02/26/2007
  5. Learner said:

    I have a problem with PostgreSQL 8.2 installation.I installed it successfully but was having login problems so I uninstalled it and tried to re-install but I've been having problems.

    Anytime I try to re-install, when I get to the Service Configuration Window, I get the message "Invalid username specified:Logon faliure:unknown user name or bad password"

    When I first installed it, I usually get a message telling me that an account will be created for me and that a password can be created if the one I entered was considered weak, but not this time.

    Being stuck to this Window makes it impossible for me to complete PostgreSQL Installation and I would greatly appreciate any help on this.

    Learner.

    posted at 07:23PM 02/26/2007
  6. 最近微软的开源软件实验室发布 PostgreSQL on Windows: A Primer ,介绍了PostgreSQL 8.2的安装和配置。 Postgres 是一个有11年历史的开源数据库软件,这款强大的object-relational数据库是许多其它开源数据库软件的强劲对手,当然也包括了微软自己的

    posted at 08:26PM 02/26/2007
  7. einhverfr said:

    Hi Learner;

    I would suggest that this could have a number of causes I can think of.  Maybe the username was not created?  Maybe the password as entered was wrong?  You should be able to use the management console to change the password of the affected account and see if that fixes it.

    A few other things to check, the username must have the right to run as a network service, and must have the right to login locally.  Check your OS's documentation about adjusting such policies.

    Finally, if you are on a company network, the password must conform to any policy requirements of the domain.

    My suggestion is to create the account and watch for error messages.  Hopefully that will help provide hints as to what is the matter.

    Best Wishes,

    Chris Travers

    posted at 09:15PM 02/26/2007
  8. posted at 09:48PM 02/26/2007
  9. Learner said:

    Thanks Chris but how do I use the management console to change the password of the affected account?

    posted at 01:36AM 02/27/2007
  10. Learner said:

    Actually I tried reinstalling again and this time when I finish set up , installation end prematurely saying user postgres already exists and cannot be created or so.

    Is there a remedy to this?

    posted at 01:44AM 02/27/2007