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