PGDATA on Windows

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: PGDATA on Windows
Date: 2015-06-16 14:15:01
Message-ID: 4E154FB60786D74BB4DFDC97BF991CAC07078F12@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

1. For 9.4.3 on Windows Server 2008 the installer has installed to:

C:\Program Files (x86)\PostgreSQL\9.4\data

Is this the recommended location

2. Should PGDATA be set as a system variable and if so to what?

3. If I try to try pg_ctl manually I get:

C:\Program Files (x86)\PostgreSQL\9.4\bin>pg_ctl -D C:\Program Files (x86)\Post
greSQL\9.4\data status
pg_ctl: unrecognized operation mode "Files"
Try "pg_ctl --help" for more information.

C:\Program Files (x86)\PostgreSQL\9.4\bin>

What is the correct syntax to do this?

Many thanks

Austen

Austen Birchall  Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Begin 2015-06-16 15:44:01 Re: PGDATA on Windows
Previous Message amul sul 2015-06-16 12:53:10 Re: what's wrong with this code?