agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Rainer Leo <leo@workfile.de>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Remote access on Windows Server
Date: Tue, 2 Jul 2024 08:46:24 +0200
Message-ID: <575668296224353060@workfile.de> (raw)
Hello, we use postgres 13.15 and have to use Windows Datacenter 2022
I cannot figure out how to configure postgres for secure remote access.
It is not possible to use IP whitelisting or VPN, because the user do not
provide anything
beside host/name/port/user/password
# this works but it grants access without password
host all all 0.0.0.0/0 trust
# these two are unable to establish connection
host all all 0.0.0.0/0 md5
host all all 0.0.0.0/0 scram-sha-256
listen_addresses = '*' in postgresql.conf is set
What is the secure way to ensure remote access on Windows Server?
Thanks for any help!
Regards, Leo
view thread (5+ messages) latest in thread
Message-ID: <575668296224353060@workfile.de>
Permalink: ../575668296224353060@workfile.de/
Also on: postgresql.org/message-id/575668296224353060@workfile.de
reply
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: leo@workfile.de, pgsql-admin@lists.postgresql.org
Subject: Re: Remote access on Windows Server
In-Reply-To: <575668296224353060@workfile.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox