Re: unbale to use pg_ctl in Windows Cmd.

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: unbale to use pg_ctl in Windows Cmd.
Date: 2020-12-06 08:16:45
Message-ID: 4421c35e-3859-9a91-94c7-d6f734e58ec6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)elevated-dev(dot)com
> <mailto:scott_ribe(at)elevated-dev(dot)com>> wrote:
>
> > On Dec 5, 2020, at 10:02 AM, mark armon <1994hejian(at)gmail(dot)com
> <mailto:1994hejian(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Atul Kumar 2020-12-07 02:29:32 idle transactions vs memory
Previous Message mark armon 2020-12-06 08:02:35 Re: unbale to use pg_ctl in Windows Cmd.