Subject: Re: unbale to use pg_ctl in Windows Cmd.
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: 
 <CACh77r77PdO6qnX6FGDbu2XJEA1art7btFZkXzMOb4GrdPzk1A@mail.gmail.com>
 <59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com>
 <3FCC3330-1DC3-4C22-8952-DDB84B0E003B@gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <070a297c-5dd3-ec86-c597-df7472d1fcdf@gmail.com>
Date: Sat, 5 Dec 2020 16:24:41 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <3FCC3330-1DC3-4C22-8952-DDB84B0E003B@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 12/5/20 3:40 PM, Paul Förster wrote:
> Hi Mark, hi Ron,
>
>> On 05. Dec, 2020, at 22:22, Ron <ronljohnsonjr@gmail.com> wrote:
>>
>> On 12/5/20 11:02 AM, mark armon wrote:
>>> pg_ctl status
>>> pg_ctl: no database directory specified and environment variable PGDATA unset
>>> Try "pg_ctl
>>> --help" for more information.
>>>
>>>
>>> C:\Users\Think>pg_ctl
>>> --help
>>>
>>> pg_ctl is a utility to initialize,
>>> start, stop, or control a PostgreSQL server.
>>>   
>>> I don't know where the pg_data directory. So I set the C:\Users\Think\Desktop\postgres\data as user variable and system variable In windows setting. But still not working. In the bin directory, there is pg_ctl.exe file.
>> Randomly deciding on a directory because you don't know where the data actually is doesn't work.  You need to know where the data is.
> maybe this helps with locating PGDATA. If you can connect you can ask the database where PGDATA is:
>
> postgres=# show data_directory;
>     data_directory
> ---------------------
>   /data/pg01/sdb01/db
> (1 row)

Using Cortana (or good old "DIR/S") to find PG_VERSION should work. I'd be 
shocked if it didn't...

-- 
Angular momentum makes the world go 'round.