Feedback-ID: i76984098:Fastmail
Message-ID: <ab39060a-a7e4-46f0-ba7d-6cb5dd5f87c8@aklaver.com>
Date: Wed, 26 Jun 2024 15:33:27 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [External] Dropping connections
To: "Tarras, Tim" <ttarras@onalaskawi.gov>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <842a688946204561ad0787606a644ecf@onalaskawi.gov>
 <14389955-b421-47dd-bcc1-641468845dde@aklaver.com>
 <b18c5306cb82414e925c11ec2d556af7@onalaskawi.gov>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <b18c5306cb82414e925c11ec2d556af7@onalaskawi.gov>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/ab39060a-a7e4-46f0-ba7d-6cb5dd5f87c8%40aklaver.com>
Precedence: bulk

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.klaver@aklaver.com