From: Paul Förster <paul.foerster@gmail.com>
To: Ron <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: unbale to use pg_ctl in Windows Cmd.
Date: Sat, 5 Dec 2020 22:40:56 +0100
Message-ID: <3FCC3330-1DC3-4C22-8952-DDB84B0E003B@gmail.com> (raw)
In-Reply-To: <59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com>
References: <CACh77r77PdO6qnX6FGDbu2XJEA1art7btFZkXzMOb4GrdPzk1A@mail.gmail.com>
<59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com>
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)
Cheers,
Paul
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: paul.foerster@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: unbale to use pg_ctl in Windows Cmd.
In-Reply-To: <3FCC3330-1DC3-4C22-8952-DDB84B0E003B@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox