Re: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL]

At Wed, 28 Feb 2024 03:23:37 +, Mark Schloss wrote in > Thank you for your reply. I can confirm there were no changes made to the > config of the replica. Okay. > Is there any significance in the parameters in the commit record - > 'inval msgs: catcache 21; sync'. I think it is not

Re: PostgreSQL Guard

As before, I encourage you to read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ . On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote: > Hi, > Do I have to run this command on the server where the main database is > located? > > Suppose you want to transfer the

Re: Aligning grants and privileges

On Wed, 28 Feb, 2024, 2:14 am Adrian Klaver, wrote: > On 2/27/24 12:40, veem v wrote: > > Hi, > > We have two different types of DBA group in current on-premise Oracle > > databases, one who deploy code in prod and highest level of privileges > > (i.e having write access to the database

RE: walreceiver fails on asynchronous replica [EXTERNAL] [SEC=UNOFFICIAL]

UNOFFICIAL Thank you for your reply. I can confirm there were no changes made to the config of the replica. We have had a further two occurrences of a walreceiver failing - each occurrence is in a different cluster, however, both clusters are on the same set of hardware. In each of the new

Re: Me again with an insert trigger problem

On 2/27/24 14:38, Thiemo Kellner wrote: Am 27.02.2024 um 23:20 schrieb Adrian Klaver: I am not sure, what you want me to show with your test case. And I am not sure whether I could not make myself clear. Please bear with me if I try to make things clearer with an example. Your comment

Re: Me again with an insert trigger problem

Am 27.02.2024 um 23:20 schrieb Adrian Klaver: On 2/27/24 14:11, Thiemo Kellner wrote: It is a habit of mine to pad conditions in the where clause. This way, it is easy to comment/uncomment parts of the clause for testing purposes. Coming from Oracle, I missed that using "true" is also

Re: Me again with an insert trigger problem

On 2/27/24 14:11, Thiemo Kellner wrote: Am 27.02.2024 um 21:42 schrieb Adrian Klaver: Also not sure what this: select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME    from NODE⠒V   where 1 = 1     and ID = new.NODE⠒ID     and 1 = 1; is supposed to be

Re: Me again with an insert trigger problem

Am 27.02.2024 um 21:42 schrieb Adrian Klaver: Also not sure what this: select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME   from NODE⠒V where 1 = 1    and ID = new.NODE⠒ID    and 1 = 1; is supposed to be doing especially the 1 = 1 tests? The

Re: PostgreSQL Guard

Hi,Do I have to run this command on the server where the main database is located? Suppose you want to transfer the database of a website like Amazon.com to a new server and delete the old one. Many users are buying and selling on this website at the same time and it is not possible to turn

Re: Aligning grants and privileges

On 2/27/24 12:40, veem v wrote: Hi, We have two different types of DBA group in current on-premise Oracle databases,  one who deploy code in prod and highest level of privileges (i.e having write access to the database objects, performing backup recovery, export/import and performing other

Aligning grants and privileges

Hi, We have two different types of DBA group in current on-premise Oracle databases, one who deploy code in prod and highest level of privileges (i.e having write access to the database objects, performing backup recovery, export/import and performing other database maintenance jobs etc). and

Re: Me again with an insert trigger problem

Thanks. 27.02.2024 19:09:50 Adrian Klaver : > > On 2/27/24 9:49 AM, Thiemo Kellner wrote: >> Hi >> >> I am surprised that my before insert trigger function does not insert any >> rows into NODE_GOOD. >> >> I was under the impression that the trigger function would do the insert >> with the

Re: Question on Table creation

On Wed, Feb 21, 2024 at 5:29 AM Adrian Klaver wrote: > > 4)Never created or maintained any partition table in postgres. Here we > > want to daily range partition the both tables based on column > > "PARENT_CREATE_TIMESTAMP", so is it advisable to create the individual > > future partitions post

Re: Cannot COPY xmin?

On Tue, Feb 27, 2024 at 7:26 PM Alvaro Herrera wrote: > On 2024-Feb-27, Dominique Devienne wrote: > > > Hi. I just tried adding the xmin pseudo-column to my COPY, > > and I get an error. > > I suggest you find some other way to achieve whatever it is you think > you'll achieve with this. It's

Re: Cannot COPY xmin?

On 2024-Feb-27, Dominique Devienne wrote: > Hi. I just tried adding the xmin pseudo-column to my COPY, > and I get an error. I suggest you find some other way to achieve whatever it is you think you'll achieve with this. It's not reliable and you'll regret it eventually. Maybe take a step back

Cannot COPY xmin?

Hi. I just tried adding the xmin pseudo-column to my COPY, and I get an error. Using a regular SELECT works fine. Is that normal? that's a `COPY tab(xmin, cols...) ...` Do I need to switch to a `COPY (select xmin, cols... from tab) ...` to access xmin? And if I do that, any performance

Re: Me again with an insert trigger problem

On 2/27/24 9:49 AM, Thiemo Kellner wrote: Hi I am surprised that my before insert trigger function does not insert any rows into NODE_GOOD. I was under the impression that the trigger function would do the insert with the new and possibly adapted values. In my case, to me at least, it is

Re: PostgreSQL Guard

You may need to expand on / rephrase question 2.

Re: PostgreSQL Guard

I used this web page to implement hot standby via physical streaming. This command sets up everything for you: pg_basebackup \ --pgdata=$PGDATA \ --dbname=service=basebackup \ --verbose --progress \ --checkpoint=fast \

Re: PQftype(copy_rset) returns zero OIDs???

On Tue, Feb 27, 2024 at 6:11 PM Tom Lane wrote: > Dominique Devienne writes: > > For the first time, I'm checking the OIDs returned > > (via the result set's PQftype API), by "regular" SELECT: > > ... > > And to my surprise, they are not! > > The ones from the COPY are all zeros. > > > Is that

Me again with an insert trigger problem

Hi I am surprised that my before insert trigger function does not insert any rows into NODE_GOOD. I was under the impression that the trigger function would do the insert with the new and possibly adapted values. In my case, to me at least, it is very simple. Only records of node type

Re: PQftype(copy_rset) returns zero OIDs???

Dominique Devienne writes: > For the first time, I'm checking the OIDs returned > (via the result set's PQftype API), by "regular" SELECT: > ... > And to my surprise, they are not! > The ones from the COPY are all zeros. > Is that normal? The CopyInResponse and CopyOutResponse messages don't

Re: PostgreSQL Guard

Hi,Should I read https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP for question number 2? On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? > > 2- 

Re: Need help with tuning a query

On 2/27/24 07:50, Siraj G wrote: Hello All! Can you please assist me with highlighting the bad area in the execution plan attached. I am kind of new to PgSQL and trying to get some help with troubleshooting a query. Little background. DB was migrated from Oracle to AlloyDB. The SQL that

Re: PostgreSQL Guard

On 2/27/24 07:08, Jason Long wrote: Hi, 1- Both split-brain protection and security. Any tool? 2- Consider a database related to a website, which data is regularly entered. Now you want to transfer this database to another server. What's the solution?

Re: PostgreSQL Guard

Hi,1- Both split-brain protection and security. Any tool? 2- Consider a database related to a website, which data is regularly entered. Now you want to transfer this database to another server. What's the solution? On Tue, Feb 27, 2024 at 5:39 PM, Ron Johnson wrote: On Tue, Feb 27, 2024

Re: PostgreSQL Guard

On Tue, Feb 27, 2024 at 3:43 AM Jason Long wrote: > Hello, > I have some questions about the PostgreSQL database: > > 1- If I want to distribute the PostgreSQL database on several servers at > the same time. what should I do? Something similar to high availability. > HA replication is native in

PQftype(copy_rset) returns zero OIDs???

Hi. For the first time, I'm checking the OIDs returned (via the result set's PQftype API), by "regular" SELECT: `select ... from tab` and by a COPY TO BINARY: `COPY ( select ... from tab ) TO STDOUT WITH (FORMAT BINARY)` And to my surprise, they are not! The ones from the COPY are all

Re: Behavior of debug_parallel_query=regress

On Tue, 27 Feb 2024 at 23:23, Rafsun Masud Prince wrote: > I am looking for a combination of the 'off' and 'regress' state, which is: > use parallel if improves performance + suppress context line (if > parallel is used) > > Our project, Apache AGE, has a regression test for cypher MATCH

Behavior of debug_parallel_query=regress

Hi, For the context, debug_parallel_query has three states (according to the documentation): on: use parallel if safe off:use parallel if improves performance regress:use parallel if safe + suppress context line + hide gather node in explain output I am looking

PQgetCopyData() and "big" rows

Hi. The doc states: >From https://www.postgresql.org/docs/current/libpq-copy.html: > Data is always returned one data row at a time; > if only a partial row is available, it is not returned I'm doing a COPY TO STDOUT WITH (FORMAT BINARY). The record format allows up to int16_t columns. (16K or

PostgreSQL Guard

Hello, I have some questions about the PostgreSQL database: 1- If I want to distribute the PostgreSQL database on several servers at the same time. what should I do? Something similar to high availability. 2- Is there any special guard to protect PostgreSQL? Thank you.