Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1klf1C-0000DS-DK for pgsql-admin@arkaria.postgresql.org; Sat, 05 Dec 2020 21:23:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1klf1B-0003i3-CJ for pgsql-admin@arkaria.postgresql.org; Sat, 05 Dec 2020 21:23:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1klf1B-0003hw-2C for pgsql-admin@lists.postgresql.org; Sat, 05 Dec 2020 21:23:01 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1klf17-0003WR-ML for pgsql-admin@lists.postgresql.org; Sat, 05 Dec 2020 21:23:00 +0000 Received: by mail-oi1-x231.google.com with SMTP id d27so3148723oic.0 for ; Sat, 05 Dec 2020 13:22:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=s3YKOF8/2Vcp4xch9PG7UPyJhDquxoX69wzd9Z1vW0A=; b=a9/UZFKPnNKqLKP3qTslFlkNf+GhNvK0V7Upz03vapljSIP0/G6xYvQ9AgS61x2Hjb XccQHLtGtnN4mOVNwN4O9GeARRBp80xPOGT6Bfpq7aHmh386v5J+2WbCXyjNPUw7iqny WpxFeNBTif83Ahcltl1r4IL7/zkq6ISGyIA+KcP6xYpzl7327JhH+gf28iF5rYTwnuBw pYA7hkjrxutnYjCg2ui6oDI2OIpAeqCWvl4P9E0s7ToF3ABbY5z8i/8AXapD4HuoAzPB YES30vFmEso3jA7nXR6CnYA56ZwOD3nH8FotmAhBA8TvS7IBrea3uI02VE4GyyE0JHB8 1Glw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=s3YKOF8/2Vcp4xch9PG7UPyJhDquxoX69wzd9Z1vW0A=; b=ob985jMPL916he/o4JKBGAouTwg5qGVrRzxuBerl0c0mP+MR+eOf3iuAPHIZ1HKZ/O jPWfPbuE7U0zT3bjUSjSPy7gBkCvzA3B+p6NtYrK4M3+qsbMsT/H1FABoipKQFmfFcJS 2PkZUA7/bItYBM3Tr5gL6y95BP4jbSY5ueDdsqNizfeSWJPAVK58wEgtkmHV+yozctiM 7Tk7wdWI5RJE8TsD40TpW1Ubdh2BYAR6xVZ5aOl+ucQBPNNb1P//oXH6QQnoY/1DcZLr biXXhPGJ9e6RtPne/fIqZ5jPtss8/dsYDErqGZP9tF7Qa7tXYTIkS2mgkUtwW+aTCLLW Sr2g== X-Gm-Message-State: AOAM530RUYPjLStrJCwQozcHoLROE+BlgcM4X6KDazNBmr1Kk5T9d/NW PmFbUnXnYe13laRnXxKO/2MK6rC7raFNMQ== X-Google-Smtp-Source: ABdhPJznmgC9wIGJgCVLiNxIztPLI+hbvR+5a5gJ19zyQqw3obh6XzTb7DldqwirZcOYnUcAO1PTgQ== X-Received: by 2002:aca:cc08:: with SMTP id c8mr7573908oig.161.1607203375514; Sat, 05 Dec 2020 13:22:55 -0800 (PST) Received: from [192.168.1.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id l12sm1664054ooe.27.2020.12.05.13.22.54 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 05 Dec 2020 13:22:54 -0800 (PST) Subject: Re: unbale to use pg_ctl in Windows Cmd. To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <59f55b22-0355-30ca-f115-ab2d2b26503d@gmail.com> Date: Sat, 5 Dec 2020 15:22:53 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------2A9B6835E2F9EFB7E37B5889" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------2A9B6835E2F9EFB7E37B5889 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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. -- Angular momentum makes the world go 'round. --------------2A9B6835E2F9EFB7E37B5889 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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.

--
Angular momentum makes the world go 'round.
--------------2A9B6835E2F9EFB7E37B5889--