Re: [External] Dropping connections

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Tarras, Tim" <ttarras(at)onalaskawi(dot)gov>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: [External] Dropping connections
Date: 2024-06-26 22:33:27
Message-ID: ab39060a-a7e4-46f0-ba7d-6cb5dd5f87c8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/26/24 12:56, Tarras, Tim wrote:
> Windows Defender is turned off and a 3rd party AV is being used. We did ask about that and were told that would not be the issue. I would also think that I would be dropping the connection when I am on the Server itself which is not the case.
>
> I have attached the log files with the Errors highlighted in Yellow Go to last page in each one. In reading the whole error the password authentication failed for the postgres user, which is not the user we are logged in as to this database.

Not sure if this is related but for completeness:

1) There seem to be quite a few of:

"ERROR: relation <some_relation> does not exist at character"

Is that normal?

2) Also:

FATAL: password authentication failed for user "postgres"

Somewhat concerning that someone/thing is trying to connect as the super
user and failing. Maybe just erroneous password for some monitoring
program or potentially someone trying to hack the database.

3) In your original post you said the issue pops up when you are
remotely accessing the Postgres server via ArcgisPro 3.3.0.

a) Where is that remote machine located.

b) OS and version of the machine.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bhavani dba 2024-06-26 23:22:57 Issue with installing postgres extension
Previous Message Justin 2024-06-26 19:57:45 Re: --frokbackend process