PGDATA on Windows - Mailing list pgsql-novice

From Birchall, Austen
Subject PGDATA on Windows
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC07078F12@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
In response to Re: database changes during a pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PGDATA on Windows
Re: PGDATA on Windows
List 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


pgsql-novice by date:

Previous
From: James David Smith
Date:
Subject: Re: what's wrong with this code?
Next
From: Daniel Begin
Date:
Subject: Re: PGDATA on Windows