On 12/5/20 3:40 PM, Paul Förster wrote:
Hi Mark, hi Ron,
On 05. Dec, 2020, at 22:22, Ron <ronljohnsonjr@xxxxxxxxx> 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)
Using Cortana (or good old "DIR/S") to find PG_VERSION should work. I'd be
shocked if it didn't...
--
Angular momentum makes the world go 'round.
