On Thu, Jun 27, 2024 at 09:19:45AM +0500, Kashif Zeeshan wrote:
> It's hard to figure out the issue by just looking on the process list, to
> figure out the issue you need to share the DB Server Logs and thats the why
> to figure out the exac issue.
Note that it is equally hard for anybody reading
Hi
It's hard to figure out the issue by just looking on the process list, to
figure out the issue you need to share the DB Server Logs and thats the why
to figure out the exac issue.
Regards
Kashif Zeeshan
On Wed, Jun 26, 2024 at 10:06 PM satyajit patra <
satyajit.pa...@sunknowledge.com> wrote:
On Wed, Jun 26, 2024 at 02:43:30PM +, Andrew Longwill wrote:
> We’re using Postgresql 15.4 in AWS RDS. Since yesterday we have seen
> two occurrences where our PHP application becomes unable to connect
> to our RDS replicas. In the application logs we see the error
> "FATAL: could not attach to
Hi Tarras
Please refer to the following guide where connection was working fine with
PG and EPAS.
https://www.enterprisedb.com/docs/partner_docs/EsriArcGISProandEsriArcGISEnterprise/04-ConfiguringEsriArcGISProandEsriArcGISEnterprise/
Regards
Kashif Zeeshan
On Wed, Jun 26, 2024 at 10:45 PM Tarra
thank you Tom!!!, I installed postgres 16 and was able to get the extension
installed.
On Wed, Jun 26, 2024 at 10:46 PM bhavani dba wrote:
> Thank you , installing postgres16 on my server.
>
> Thanks,
> Bhavani
>
> On Wed, Jun 26, 2024 at 10:25 PM Tom Lane wrote:
>
>> bhavani dba writes:
>> >
Thank you , installing postgres16 on my server.
Thanks,
Bhavani
On Wed, Jun 26, 2024 at 10:25 PM Tom Lane wrote:
> bhavani dba writes:
> > thank you for tom for your response. i dont remember installing postgres
> 14
> > version on the server and it seems like I have postgres 15 running.
>
> >
bhavani dba writes:
> thank you for tom for your response. i dont remember installing postgres 14
> version on the server and it seems like I have postgres 15 running.
> [postgres@postgres ~]$ psql
> psql (15.7, server 15.0)
> Type "help" for help.
Hmm ... after poking around a bit, it appears y
thank you for tom for your response. i dont remember installing postgres 14
version on the server and it seems like I have postgres 15 running.
Please see below.
[postgres@postgres ~]$ psql
psql (15.7, server 15.0)
Type "help" for help.
postgres=#
postgres=# CREATE EXTENSION pg_stat_statements;
bhavani dba writes:
> postgres=# CREATE EXTENSION pg_stat_statements;
> ERROR: could not load library
> "/home/postgres/bin/pgsql/15/lib/pg_stat_statements.so":
> /home/postgres/bin/pgsql/15/lib/pg_stat_statements.so: undefined symbol:
> InitMaterializedSRF
This certainly looks like you are tryi
I am having issues with postgres extensions and I have already installed
the contrib package.
thank you for the help!!
postgres=# CREATE EXTENSION pg_stat_statements;
ERROR: could not load library
"/home/postgres/bin/pgsql/15/lib/pg_stat_statements.so":
/home/postgres/bin/pgsql/15/lib/pg_stat_st
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 atta
Hi Satyajit:
Can't tell what is going on from the task manager list. Looks like a
normal task list for PostgreSQL. Keep in mind PG is a process based
application NOT a threaded application. Meaning postgresql starts/forks a
new process for every connection. This means we can see each sessions
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 high
On 6/26/24 10:44 AM, Tarras, Tim wrote:
Hello,
Underlying DBMS error [no connection to the server::SQLSTATE=å]
[xxx.xxx.GDB_Items][STATE_ID = 0]
X's replace actual names.
Working with ESRI we found the following information in the logs :
"*An existing connection was forcibly closed
Hello,
I am having problems with loosing connection to a postgresql database with ESRI
ArcGIS Pro. Below is what I put on the ESRI community forums but also wanted to
post here to see I can get a resolution to this problem. Thank you for any
help you can provide.
Tim
I'm not sure if this is
Dear Team,
I am using postgres database in windows 10 but suddenly we are facing some hang
issue while starting the cluster and also, we observe few below process in the
task manager. Is it bad impact to the database ?
[cid:64119219-38cc-435a-8b20-93d9fa405116]
Hi all,
We’re using Postgresql 15.4 in AWS RDS. Since yesterday we have seen two
occurrences where our PHP application becomes unable to connect to our RDS
replicas. In the application logs we see the error "FATAL: could not attach to
dynamic shared area". The RDS replica remains unusable in th
On 6/26/24 00:03, Shenavai, Manuel wrote:
Thanks for the suggestions.
I checked pg_locks shows and pg_stat_activity but I could not find a LOCK or
an transaction on this (at this point in time).
I assume that this problem may relate to long running transactions which write
a lot of data. Is t
On Wed, Jun 26, 2024 at 3:03 AM Shenavai, Manuel
wrote:
> Thanks for the suggestions.
> I checked pg_locks shows and pg_stat_activity but I could not find a LOCK
> or an transaction on this (at this point in time).
>
> I assume that this problem may relate to long running transactions which
> wr
On Wed, Jun 26, 2024 at 2:42 PM David G. Johnston
wrote:
> On Wednesday, June 26, 2024, Dominique Devienne wrote:
>> Only session_user
>> is representative of the caller, and reliable (modulo SUPERUSER and
>> SET AUTHORIZATION, but that's a different story and kinda normal)
>
> Why can you not us
On Wed, 26 Jun 2024 at 08:42, David G. Johnston
wrote:
> On Wednesday, June 26, 2024, Dominique Devienne
> wrote:
>
>> Only session_user
>> is representative of the caller, and reliable (modulo SUPERUSER and
>> SET AUTHORIZATION, but that's a different story and kinda normal)
>>
>
> Why can you
On Wednesday, June 26, 2024, Dominique Devienne wrote:
> Only session_user
> is representative of the caller, and reliable (modulo SUPERUSER and
> SET AUTHORIZATION, but that's a different story and kinda normal)
>
Why can you not use session_user then?
David J.
On Wed, Jun 26, 2024 at 12:11 PM wrote:
> Dominique Devienne:
> > 1) Is there any way to know the current_role of the caller of a
> > DEFINER function. I fear the answer is no, but better be sure from
> > experts here.
>
> You can do something like this:
>
> CREATE DOMAIN current_user_only AS text
Dominique Devienne:
1) Is there any way to know the current_role of the caller of a
DEFINER function. I fear the answer is no, but better be sure from
experts here.
You can do something like this:
CREATE DOMAIN current_user_only AS text
CONSTRAINT current_user_only CHECK (VALUE = CURRENT_USE
On 2024-06-26 10:35 +0200, Dominique Devienne wrote:
> Hi. I was led to believe (by an hallucination...) that I could know
> the current_role of the caller of a DEFINER function, but after actual
> experimentation, turns out it shows the OWNER of the function, and not
> the current_role of the call
On Wed, 2024-06-26 at 10:35 +0200, Dominique Devienne wrote:
> So I have two questions:
> 1) Is there any way to know the current_role of the caller of a
> DEFINER function. I fear the answer is no, but better be sure from
> experts here.
> 2) Why isn't there a way to obtain the above? What harm wo
Hi. I was led to believe (by an hallucination...) that I could know
the current_role of the caller of a DEFINER function, but after actual
experimentation, turns out it shows the OWNER of the function, and not
the current_role of the caller.
I foolishly thought curent_role != current_user inside t
On Tue, 2024-06-25 at 14:11 -0500, Bruno Wolff III wrote:
> The actual
> use case is a set of tripplets returned from a query, where I want on
> row for each distinct value in the first column, paired with the value
> in the second column, for which the third column is the largest. The
> second
Thanks for the suggestions.
I checked pg_locks shows and pg_stat_activity but I could not find a LOCK or
an transaction on this (at this point in time).
I assume that this problem may relate to long running transactions which write
a lot of data. Is there already something in place that would h
29 matches
Mail list logo
