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!
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 |