Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10

On Jul 22, 2020, at 4:58 PM, Surya Widyanto <ayrus02@gmail.com> wrote:

On 23-07-2020 05:26, Adrian Klaver wrote:

On 7/22/20 10:24 AM, Surya Widyanto wrote:

Hi,

I have PostgreSQL v12.3 (x64) installed on my Laptop running Windows 10 Home Single Language (64-bit).
In two or three times since I fresh install the PostgreSQL and windows on 17-05-2020, 06:04:56 (GMT).

Meant to ask earlier, where did you install Postgres from?

I've download the installer executable from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads, the Windows x86-64 version.

Then I've install it on my Windows with binaries path to "C:\Program Files\PostgreSQL\12\" and for data path to "H:\PostgreSQL\Data\12.x\".
Both C: and H: drive are partition on my NVMe PCIe Gen. 3 x 4 SSD Drive mentioned earlier.

For additional information, I've also install the PostGIS v3.0 r15475 (x64) for PostgreSQL v12.

By two or three times I mean, if this slow connection problem happen, than it wil occur in a view days in a row. Then it will return to normal with fast login/connection process.

Regards,
Surya