I am having heavy polling into the database and need to perform certain tasks
without any application interference.
On Friday, December 20, 2024 at 03:13:21 PM EST, Adrian Klaver
wrote:
On 12/20/24 11:25, Y_Bharani_mbsv wrote:
> Team
> I have the need to have postgresql db running i
TQ
On Friday, December 20, 2024 at 03:26:30 PM EST, Ron Johnson
wrote:
On Fri, Dec 20, 2024 at 2:25 PM Y_Bharani_mbsv wrote:
TeamI have the need to have postgresql db running in multiuser mode and do my
needed tasks for few mins.
How to restrict all the application layer , not to ge
On Fri, Dec 20, 2024 at 2:25 PM Y_Bharani_mbsv wrote:
> Team
> I have the need to have postgresql db running in multiuser mode and do my
> needed tasks for few mins.
>
> How to restrict all the application layer , not to get connected with the
> postgres db ,
> during my specific time window
>
On 12/20/24 11:25, Y_Bharani_mbsv wrote:
Team
I have the need to have postgresql db running in multiuser mode and do
my needed tasks for few mins.
What are the tasks and why do you think they can't be run concurrently
with other users?
How to restrict all the application layer , not to
On 12/20/24 12:05, mark bradley wrote:
I'm getting a strange error message when I try to insert a date using
the view/edit grid in pgadmin. See below. I've tried quotes, no quotes
and various formats. The column type is clearly "date."
Don't hijack a thread, start a new one.
Mark Brady,
I'm getting a strange error message when I try to insert a date using the
view/edit grid in pgadmin. See below. I've tried quotes, no quotes and
various formats. The column type is clearly "date."
[cid:4ff69cfe-2efa-4636-8dde-6230512706f7]
Mark Brady, Ph.D.
Deputy Chief Data Officer, TRMC
am
TeamI have the need to have postgresql db running in multiuser mode and do my
needed tasks for few mins.
How to restrict all the application layer , not to get connected with the
postgres db ,during my specific time window I am aware of their application
layer - username
Changing password is t
I found the culprit env variable was defined as PG_DATA inlieu of PGDATA
cleared and dropped itand restarted dband created once again tablespace in the
desired location and it worked
Thank YouRegards
On Friday, December 20, 2024 at 11:50:20 AM EST, Adrian Klaver
wrote:
On 12/20/24 08:0
On 12/20/24 08:09, Bharani SV-forum wrote:
Adrian
Inline image
initially i had created tblspace outside pg_data env variable
Did you run CREATE TABLESPACE as shown below?:
https://www.postgresql.org/docs/current/sql-createtablespace.html
Did you ever use the tablespace?
e.g PG_DATA env var
On 12/20/24 07:02, Enrico Schenone wrote:
Hi, Adrian.
Today I have collected a tcpdump at client side with communications
between application server and db server while the issue was occurring
one time per second on another program.
I send you two files.
The first one is a zipped tarball (.tgz
On 12/19/24 23:57, Enrico Schenone wrote:
At 19/12/24 22:47, Adrian Klaver wrote:
So are they building their own driver over libpq?
I think so.
They wrote ...
<
/The error “no connection to the server“ is definitively a PostgreSQL
error:/
/||/
/|./src/interfaces/libpq/fe-exec.c: libpq_
Adrian
initially i had created tblspace outside pg_data env variablee.g PG_DATA env
variable is defined to /XXX//ABC/15/data
the tablespace was created under
/XXX//ABC/15/tblspace/<>/assume tablespace name is abc_data
cd /XXX//ABC/15/tblspace/abc_data/ls -atldrwxr-x---. 2 postgres
Hi all,
I've a doubt about background workers. I've a worker (loaded by a
module via shared_preloaded_libraries) should register a dyanmic
background worker per database, in a manner similar to what autovacuum
does.
I would like to pass to these dynamic background workers a pointer to
a custom stru
Ekaterina Amez Gonzalez writes:
> I tried what was suggested: reindexing and running "refresh collation"
> alter after that and everything seems to work ok so this looks like an easy
> wat to migrate from one server to another. Plus I feel more comfortable
> using streaming replication than logica
At 19/12/24 22:47, Adrian Klaver wrote:
On 12/19/24 11:40 AM, Enrico Schenone wrote:
Hello, my answers in line along your message ...
Thanks a lot again.
Enrico
On 12/19/24 10:11, Enrico Schenone wrote:
Good day, Adrian.
I get the error inside the program by catching the exception and
l
Good day, Adrian.
I get the error inside the program by catching the exception and logging
it with diagnostic info provided by the DVM (a runtime interpreter
similar in concept to a JVM) that embed the PG driver.
This is the fragment of the source code where the error occurs ...
comments are
Good day, Adrian.
First of all I thank-you for you answer.
Yes, the client is running on Ubuntu 22.04 LTS in this case, bu I have
observed the same problem on Debian 10 and 12 and Postgres versions 12,
13 and 16.
In the reported case no relevant info has been reported on syslog
and/or kern.l
Hello Everyone,
We have a Postgres setup in Azure (IAAS) with 2 DB nodes in the cluster and
pgpool is running on each DB node. We have enabled the watchdog.
What we are doing: We are testing the connectivity to DB cluster via
HammerDB to apply the load.
HammerDB is connecting to Delegate IP via 9
Hi List,
I'm making some tests in order to prepare a db migration. We have version
9.6 over CentOS 7 and we're going to migrate to version 15 over Rocky Linux
9. Of course there is a no downtime requirement or I wouldn't be here
asking.
I was previously aware of the problem with different glibc v
On 12/10/24 17:59, Felipe Matas wrote:
Hi all! I'm trying to build three postgres clusters (in different
servers), I'm thinking to use CITUS to make the data available across
the clusters, I'm checking the docs.
What I have not been able to found in any place, is how to handle the
permission
On 12/4/24 17:51, Ivan Shershnev wrote:
Hello!
I need to use the 'age (xid)' function, but I have noticed that it is
deprecated without a clear alternative. I know that xid is also kinda
deprecated, so it makes sense not to use it. I can get xid8 from
'pg_current_xact_id()', which replaced
21 matches
Mail list logo
