Re: Locallhost Windows installation

From: "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk>
To: "'System Consult'" <systemconsult(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Locallhost Windows installation
Date: 2006-05-09 09:54:41
Message-ID: 20060509095438.B2DC39F931D@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You should ideally install it as a Windows service. You can restrict access
to the server using the pg_hba.conf to the local machine only so other
network machines cannot connect. The windows service means that PostgreSQL
can be controlled automatically at startup, rather than have to be started
manually.

You define the data directory in the MSI installer (although I believe this
is my default under C:\Program Files\PostgreSQL\Data.)

To use the database, you need a management program, such as PgAdmin III -
this ships with the MSI installer, if you install this at the same time as
you install Postgres, it'll add a connection to PgAdmin for the local
server.

The latest version manual can be found on the documentation website -
that'll give you any information you need regarding config files etc.

Andy

_____

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of System Consult
Sent: 09 May 2006 10:47 am
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Locallhost Windows installation

Im a new user, having read so much about the database.

i installed the binary version successfuly on windows. I did not install as
a service, as all access have to be through the local host, via a
program(java). Now how do i create the database at a specified directory and
start using this.

kind and urgent assistance required

!DSPAM:14,4460656534491115751839!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-05-09 11:42:18 Re: Locallhost Windows installation
Previous Message Gary Stainburn 2006-05-09 09:50:19 Re: RFC - multi database/application user authentification