X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CB8D49FA226 for ; Tue, 9 May 2006 06:54:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34498-08 for ; Tue, 9 May 2006 06:54:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id B2DC39F931D for ; Tue, 9 May 2006 06:54:37 -0300 (ADT) Received: from [213.146.143.243] (port=1535 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FdOvL-0001kq-5M; Tue, 09 May 2006 10:54:35 +0100 Reply-To: From: "Andy Shellam" To: "'System Consult'" Cc: Subject: Re: Locallhost Windows installation Date: Tue, 9 May 2006 10:54:41 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C67356.F9DE6080" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: Thread-Index: AcZzTbVqm+96TtVpR6yxqnFUgp6gHwAAGtyw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Message-Id: <20060509095438.B2DC39F931D@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/82 X-Sequence-Number: 21614 This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C67356.F9DE6080 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of System Consult Sent: 09 May 2006 10:47 am To: pgsql-admin@postgresql.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! ------=_NextPart_000_0003_01C67356.F9DE6080 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of System Consult
Sent: 09 May 2006 10:47 = am
To: pgsql-admin@postgresql.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!

------=_NextPart_000_0003_01C67356.F9DE6080--