Re: PGDATA on Windows

QA1 - If you are talking about the program itself, there is nothing bad
about that location. If you are talking about the data cluster location
(where will be store the data managed by PostgreSQL), it all depends on the
expected size of your DB.

However, even if your C:\ drive can afford the size of your DB, I would
place the data component somewhere else like on another drive or at least
not under " C:\Program Files (x86)\..." Something likes C:\mydatacluster
would be easier to manage (access, later upgrade...)

QA2- It is a good idea to set PGDATA as a system variable. You must set it
to actual data location which in your case seems to be C:\Program Files
(x86)\PostgreSQL\9.4\data. For instance, mine is set to E:\pgsqlData.

QA3- About pg_ctl: unrecognized operation mode "Files" error message, my
guess is that you need to quote the location since there are white spaces in
it. This version should work...

pg_ctl -D "C:\Program Files (x86)\PostgreSQL\9.4\data" status

Daniel

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Birchall, Austen
Sent: June-16-15 10:15
To: pgsql-novice@postgresql.org
Subject: [NOVICE] PGDATA on Windows

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


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice