Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.20.0.2.21\))
Subject: Re: unbale to use pg_ctl in Windows Cmd.
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: <59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com>
Date: Sat, 5 Dec 2020 22:40:56 +0100
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <3FCC3330-1DC3-4C22-8952-DDB84B0E003B@gmail.com>
References: 
 <CACh77r77PdO6qnX6FGDbu2XJEA1art7btFZkXzMOb4GrdPzk1A@mail.gmail.com>
 <59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com>
To: Ron <ronljohnsonjr@gmail.com>
Precedence: bulk

Hi Mark, hi Ron,

> On 05. Dec, 2020, at 22:22, Ron <ronljohnsonjr@gmail.com> wrote:
>=20
> 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=20
>> --help" for more information.
>>=20
>>=20
>> C:\Users\Think>pg_ctl=20
>> --help
>>=20
>> pg_ctl is a utility to initialize,=20
>> start, stop, or control a PostgreSQL server.
>> =20
>> 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.
>=20
> 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=3D# show data_directory;
   data_directory   =20
---------------------
 /data/pg01/sdb01/db
(1 row)

Cheers,
Paul=