Re: parallel-processing multiple similar query tasks - any example?

On Wed, Apr 27, 2022 at 4:44 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI > wrote: > >> multiple similar query tasks are as follows: >> >> select * from a_table where country ='UK' >> select * from a_table where country='France' >> and

Re: Backing up a DB excluding certain tables

On 4/27/22 15:45, JORGE MALDONADO wrote: Is this the correct way to answer when you say that I must *keep the list cc'd*? I am not sure if I only have to reply to the *pgsql-general@lists.postgresql.org * list or also include individual emails like yo

Re: parallel-processing multiple similar query tasks - any example?

On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI wrote: > multiple similar query tasks are as follows: > > select * from a_table where country ='UK' > select * from a_table where country='France' > and so on > > How best to parallel-processing such types of multiple similar query tasks? > > Any exam

Re: Backing up a DB excluding certain tables

On Wed, Apr 27, 2022 at 4:16 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Apr 27, 2022 at 3:46 PM JORGE MALDONADO > wrote: > >> Is this the correct way to answer when you say that I must *keep the >> list cc'd*? I am not sure if I only have to reply to the >> *pgsql-genera

parallel-processing multiple similar query tasks - any example?

multiple similar query tasks are as follows: select * from a_table where country ='UK' select * from a_table where country='France' and so on How best to parallel-processing such types of multiple similar query tasks? Any example available? Regards, David

Re: Backing up a DB excluding certain tables

On Wed, Apr 27, 2022 at 3:46 PM JORGE MALDONADO wrote: > Is this the correct way to answer when you say that I must *keep the list > cc'd*? I am not sure if I only have to reply to the > *pgsql-general@lists.postgresql.org > * list or also include individual > emails like yours and Adrian's. > >

Re: Backing up a DB excluding certain tables

Is this the correct way to answer when you say that I must *keep the list cc'd*? I am not sure if I only have to reply to the *pgsql-general@lists.postgresql.org * list or also include individual emails like yours and Adrian's. I have tried many ways to make this pg_dump command work without succe

Re: Replication with Patroni not working after killing secondary and starting again

On 2022-04-27 15:27:34 +0200, Zb B wrote: > Hi, > I am new to Patroni and PostgreSQL.We have set up a cluster with etcd (3 > nodes), Patroni (2 nodes) and PostgreSQL (2 nodes) with replication from > primary to secondary. Pretty much the setup we have. > Seemed to be working fine and we started s

Re: Privilege error with c functions during postgresql upgrade from 11 -> 13

On 4/27/22 7:51 AM, Dives, Chloe wrote: I am doing a test run of upgrading a postgresql instance from v11 to v13 and am hitting the following error: *pg_restore: while PROCESSING TOC:* *pg_restore: from TOC entry 13902; 0 0 ACL FUNCTION "bt_index_check"("index" "regclass") rolename1* *pg_re

Re: Whole Database or Table AES encryption

On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote: > Hi, > > Is there any way to (virtually) encrypt whole databases or tables with > AES or other types of encryption ? You can use storage encryption via the operating system. Cybertec has a patch for PG 12 and the community is working o

Re: Fresh eyeballs needed: input into error [FIXED]

On Wed, 27 Apr 2022, Francisco Olarte wrote: Where you using cut&paste / selection or something similar? Lately I've been getting weird errors on paste operations due to bracketed paste, which are puzzling, It seems to have interactions with readline and other stuff depending on where the cursor

Re: Fresh eyeballs needed: input into error [FIXED]

Rich: On Wed, 27 Apr 2022 at 14:38, Rich Shepard wrote: > On Tue, 26 Apr 2022, Bruce Momjian wrote: > > I am curious what OS psql was using that was fixed by a re-login? > This desktop's running Slackware64-14.2. Where you using cut&paste / selection or something similar? Lately I've been gettin

Privilege error with c functions during postgresql upgrade from 11 -> 13

I am doing a test run of upgrading a postgresql instance from v11 to v13 and am hitting the following error: pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 13902; 0 0 ACL FUNCTION "bt_index_check"("index" "regclass") rolename1 pg_restore: error: could not execute query: ERROR: ro

Whole Database or Table AES encryption

Hi, Is there any way to (virtually) encrypt whole databases or tables with AES or other types of encryption ? Regards, Aaron -- Aaron Gray Independent Open Source Software Engineer, Computer Language Researcher, Information Theorist, and amateur computer scientist.

Re: "create function... depends on extension..." not supported. Why?

Alvaro Herrera writes: > IIRC Abhijit and I discussed this point offline, and our conclusion was > that DEPENDS ON EXTENSION was not of general enough usefulness to > warrant support for it in CREATE FUNCTION -- keeping in mind that we > would need support for it in CREATE INDEX, CREATE TRIGGER, C

Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac

Laurenz Albe writes: > On Wed, 2022-04-27 at 10:05 +1000, Sam Kidman wrote: >> I recently upgraded one of our applications to use postgres 13.6. When I try >> to compile >> from a source checkout or by running asdf install (our version manager which >> also compiles 13.6) >> I get the same error

Re: Fresh eyeballs needed: input into error

On Wed, 27 Apr 2022, Rob Sargent wrote: Have you tried \r instead of C-c? Rob, No, I haven't. I'll try it to reset the query buffer the next time I make a mistake entering a command. Thanks, Rich

Replication with Patroni not working after killing secondary and starting again

Hi, I am new to Patroni and PostgreSQL.We have set up a cluster with etcd (3 nodes), Patroni (2 nodes) and PostgreSQL (2 nodes) with replication from primary to secondary. Seemed to be working fine and we started some tests. One of the tests gave us unsatisfactory results. Specifically when we star

Re: Fresh eyeballs needed: input into error

> On Apr 27, 2022, at 5:43 AM, Rich Shepard wrote: > > On Wed, 27 Apr 2022, Laurenz Albe wrote: > > > From time to time I mis-type a character or make another error and psql > responds with a different prompt and no explicit explanation. I'll then type > C-c and get the default => prompt ba

Re: Fresh eyeballs needed: input into error

On Wed, 27 Apr 2022, Laurenz Albe wrote: test=> insert test-> insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr, loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment) values (6000,'No','Name',null,404,1,null,null,null,null,null,null,null); ERROR: syntax e

Re: Fresh eyeballs needed: input into error [FIXED]

On Tue, 26 Apr 2022, Bruce Momjian wrote: I am curious what OS psql was using that was fixed by a re-login? Bruce, This desktop's running Slackware64-14.2. Regards, Rich

partitioned tables in high OLTP db

Hello, I'd like to ask for your opinion and experience you might have with partitioned tables on a production OLTP database. We have a couple of tables reaching 1T and beyond and liked to have them partitioned. We built a pg14 full volume db. To get an impression of the new performance we're execu

Re: errcodes.h and others not generated when compiling 13.6 on M1 Mac

On Wed, 2022-04-27 at 10:05 +1000, Sam Kidman wrote: > I recently upgraded one of our applications to use postgres 13.6. When I try > to compile > from a source checkout or by running asdf install (our version manager which > also compiles 13.6) > I get the same error message: > > ../../src/incl

Re: Fresh eyeballs needed: input into error

On Tue, 2022-04-26 at 14:31 -0700, Rich Shepard wrote: > I'm getting a syntax error with an input into statement and I cannot see the > cause. > > A MWE and the result (N.B.: line one wrapped for readability; it ends with > 'values'): > insert into people (person_nbr,lname,fname,job_title,company_

Re: "create function... depends on extension..." not supported. Why?

On 2022-Apr-26, Tom Lane wrote: > I suppose that "DEPENDS ON EXTENSION" was modeled after the commands > to control extension membership, which likewise exist only in ALTER > form because CREATE's behavior for that is hard-wired. If you wanted > to hand-wave a lot, you could maybe claim that owne

errcodes.h and others not generated when compiling 13.6 on M1 Mac

Hello I recently upgraded one of our applications to use postgres 13.6. When I try to compile from a source checkout or by running asdf install (our version manager which also compiles 13.6) I get the same error message: ../../src/include/utils/elog.h:71:10: fatal error: 'utils/errcodes.h' file n

Physical replication high shared buffers hits

Hello, We have been struggling with weird issue with postgresql physical replication, and i wonder if someone had this problem before, we have two servers (primary, replica) same hardware spec connected directly with switch running postgresql 13.4, with replication lag less than 1 second, we use p