Re: unbale to use pg_ctl in Windows Cmd. - Mailing list pgsql-admin

From Ron
Subject Re: unbale to use pg_ctl in Windows Cmd.
Date
Msg-id 4421c35e-3859-9a91-94c7-d6f734e58ec6@gmail.com
Whole thread Raw
In response to Re: unbale to use pg_ctl in Windows Cmd.  (mark armon <1994hejian@gmail.com>)
List pgsql-admin
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@elevated-dev.com> wrote:
> On Dec 5, 2020, at 10:02 AM, mark armon <1994hejian@gmail.com> 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.

pgsql-admin by date:

Previous
From: mark armon
Date:
Subject: Re: unbale to use pg_ctl in Windows Cmd.
Next
From: Atul Kumar
Date:
Subject: idle transactions vs memory