Re: unbale to use pg_ctl in Windows Cmd.

[Ron <ronljohnsonjr@xxxxxxxxx>]

    You've got to do it because Postgresql requires you to.
    
    Or you could set PGDATA=C:\Program Files\PostgreSQL\13\data'and
    run pg_ctl status,
    just like the error message aid.

On 12/6/20 2:02 AM, mark armon wrote:

Problem resolved. But I just don’t know why.
So I need to add the data directory. like pg_ctl status -D 'C:\Program Files\PostgreSQL\13\data'

On Sat, Dec 5, 2020 at 10:54 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:

> On Dec 5, 2020, at 10:02 AM, mark armon <1994hejian@xxxxxxxxx> wrote:
>
> I don't know where the pg_data directory.

You will have to find it to use pg_ctl

> So I set the C:\Users\Think\Desktop\postgres\data as user variable and system variable In windows setting.

Doesn't do any good if that's not where the data directory is.

--
Angular momentum makes the world go 'round.