Re: Two questions about "pg_constraint"

> t...@sss.pgh.pa.us wrote: > >> b...@yugabyte.com writes: >> >> Question 1: why does "pg_constraint" have a "connamespace" column? > > You appear to be assuming that every pg_constraint entry is tied to a table. > This isn't so. I see how this might have appeared to be the case. But I did, ve

Re:Re: pg_dump without setting search_path

Dear all, Thank you so much for your response to my request for information. I appreciated you taking the time to provide some answers and for getting back to me so promptly. It made a lot of sense and was exactly what I needed to know. At 2022-08-25 12:19:03, "Adrian Klaver" wrote: >On 8/24/

Re: Unable to start replica after failover

Hi, On Wed, 24 Aug 2022 at 13:37, Lahnov, Igor wrote: > > > Yes, Postgres asks for 0002054E00FB and gets renamed > 0002054E00FB.partial (without *partial* postfix). > But why? This is totally weird and unexpected behavior. Why pg_probackup is doing this? Regards, -- Al

Re: pg_dump without setting search_path

On 8/24/22 20:39, gzh wrote: Hi Tom, Thank you for your prompt response. When I use pg_dump to export schema from an older version of PostgreSQL 8.2.3 , it adds the following line at the beginning: SET search_path = public, pg_catalog; Is it possible set an option where pg_dump will add thi

Re: pg_dump without setting search_path

On Wednesday, August 24, 2022, gzh wrote: > > When I use pg_dump to export schema from an older version of PostgreSQL > 8.2.3 , it adds the following line at the beginning: > > SET search_path = public, pg_catalog; > > Is it possible set an option where pg_dump will add this line in > PostgreSQL 1

Re:Re: pg_dump without setting search_path

Hi Tom, Thank you for your prompt response. When I use pg_dump to export schema from an older version of PostgreSQL 8.2.3 , it adds the following line at the beginning: SET search_path = public, pg_catalog; Is it possible set an option where pg_dump will add this line in PostgreSQL 12.5? A

Re: pg_dump without setting search_path

gzh writes: > When I use pg_dump to export schema from a database, it adds the following > line at the beginning: > SELECT pg_catalog.set_config('search_path', '', false); > Is it possible set an option where pg_dump will not add this line? No. It's a security precaution. > It is causing issu

pg_dump without setting search_path

When I use pg_dump to export schema from a database, it adds the following line at the beginning: SELECT pg_catalog.set_config('search_path', '', false); Is it possible set an option where pg_dump will not add this line? It is causing issues later when I try to execute other SQL commands

Greg Sabino Mullane ? Re: Two questions about "pg_constraint"

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> Thanks, Adrian. I should have tried Google for "remove pg_constraint >> consrc". This finds the quote as the top hit. > > To see all release notes together go here: > > https://bucardo.org/postgres_all_versions > > Then yo

Re: Two questions about "pg_constraint"

On 8/24/22 13:43, Bryn Llewellyn wrote: /adrian.kla...@aklaver.com wrote:/ Thanks, Adrian. I should have tried Google for "remove pg_constraint consrc". This finds the quote as the top hit. To see all release notes together go here: https://bucardo.org/

Re: Corrupted Postgresql Microsoft Binaries

On 8/24/22 2:23 PM, Thomas Kellerer wrote: Hillary Masha schrieb am 23.08.2022 um 20:58: I downloaded the microsoft postgresql binaries for versions 14.5, 13.8, 12.12, 11.17, 10.22 from https://www.enterprisedb.com/download-postgresql-binaries and found that there was an error with opening the z

Re: Corrupted Postgresql Microsoft Binaries

On 8/24/22 2:01 PM, Hillary Masha wrote: Thank you for sending the email to them, i had sent an email to techsupp...@enterprisedb.com  last week but haven't heard back. I need the zip files as my team uses a script that installs the postgres versions to mult

Re: Corrupted Postgresql Microsoft Binaries

Hillary Masha schrieb am 23.08.2022 um 20:58: I downloaded the microsoft postgresql binaries for versions 14.5, 13.8, 12.12, 11.17, 10.22 from https://www.enterprisedb.com/download-postgresql-binaries and found that there was an error with opening the zip files. Does anyone else use these files a

Re: Corrupted Postgresql Microsoft Binaries

Thank you for sending the email to them, i had sent an email to techsupp...@enterprisedb.com last week but haven't heard back. I need the zip files as my team uses a script that installs the postgres versions to multiple machines using the binaries. On Wed, Aug 24, 2022 at 4:09 PM Adrian Klaver w

Re: Two questions about "pg_constraint"

Bryn Llewellyn writes: > *Question 1: why does "pg_constraint" have a "connamespace" column?* You appear to be assuming that every pg_constraint entry is tied to a table. This isn't so. (1) That catalog also carries check constraints for domains, which are tied to types instead. Yeah, you coul

Re: Two questions about "pg_constraint"

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> Question 2: what happened to the column "consrc"? > > It was in 11 but not later, so let's look at release notes... HERE: https://www.postgresql.org/docs/12/release-12.html > « > Remove obsolete pg_constraint.consrc column

Re: Two questions about "pg_constraint"

On 8/24/22 13:11, Bryn Llewellyn wrote: *Question 1: why does "pg_constraint" have a "connamespace" column?* I created this temporary view (using PG 14.4): *create temporary view all_constraints(t_owner, t_schema, t_name, c_name, same) as select   r.rolname,   s.nspname,   c.relname,   x.

Re: Two questions about "pg_constraint"

On 8/24/22 13:17, Adrian Klaver wrote: On 8/24/22 13:11, Bryn Llewellyn wrote: Ad hoc queries in my PG 11.9 env show results like « (v = lower(v)) » in this column for my tables. This is useful information. But the PG 14 version of "pg_constraint" has no such column (and nor does the doc men

Re: Two questions about "pg_constraint"

On 8/24/22 13:11, Bryn Llewellyn wrote: *Question 1: why does "pg_constraint" have a "connamespace" column?* What do you think? *Question 2: what happened to the column "consrc"?* The PG 11 account of "pg_constraint" https://www.postgresql.org/docs/11/catalog-pg-constraint.html

Two questions about "pg_constraint"

*Question 1: why does "pg_constraint" have a "connamespace" column?* I created this temporary view (using PG 14.4): create temporary view all_constraints(t_owner, t_schema, t_name, c_name, same) as select r.rolname, s.nspname, c.relname, x.conname, (x.connamespace = c.relnamespace) fro

Re: Corrupted Postgresql Microsoft Binaries

On 8/24/22 12:22, Hillary Masha wrote: It looks like Windows 10 is unable to open the zip files for windows versions of the binaries 14.5, 13.8, 12.12, 11.17, 10.22. I get this error message when I double click the zip file or when I right click and select 'Extract All..'. image.png I was abl

Re: Corrupted Postgresql Microsoft Binaries

On 8/24/22 12:22, Hillary Masha wrote: It looks like Windows 10 is unable to open the zip files for windows versions of the binaries 14.5, 13.8, 12.12, 11.17, 10.22. I get this error message when I double click the zip file or when I right click and select 'Extract All..'. image.png I cranke

Re: Corrupted Postgresql Microsoft Binaries

It looks like Windows 10 is unable to open the zip files for windows versions of the binaries 14.5, 13.8, 12.12, 11.17, 10.22. I get this error message when I double click the zip file or when I right click and select 'Extract All..'. [image: image.png] I was able to successfully unzip files in po

Re: Corrupted Postgresql Microsoft Binaries

On 8/24/22 09:17, Hillary Masha wrote: Thank you Adrian, I was able to unzip the files using powershell, my OS is Windows 10 and I had been using Windows' 'Extract All' to try to get the files. As well, simply double clicking to open the files showed an error stating that windows cannot open th

Re: Corrupted Postgresql Microsoft Binaries

Thank you Adrian, I was able to unzip the files using powershell, my OS is Windows 10 and I had been using Windows' 'Extract All' to try to get the files. As well, simply double clicking to open the files showed an error stating that windows cannot open this file. I had download the zip files from

Re: recovery_command has precedence over phisical slots?

Il giorno mer 24 ago 2022 alle ore 13:00 Laurenz Albe < laurenz.a...@cybertec.at> ha scritto: > On Wed, 2022-08-24 at 14:18 +0900, Kyotaro Horiguchi wrote: > > At Fri, 19 Aug 2022 18:37:53 +0200, Laurenz Albe < > laurenz.a...@cybertec.at> wrote in > > > On Fri, 2022-08-19 at 16:54 +0200, Giovanni

Re: Question regarding failover behavior

Updating to say I tested and ran into the issue where the timeline switched from 0C to 0D. Trying to bring the old primary back up as standby fails. It recovers upto a point and then gets stuck asked for a next file that doesn't exist. Regardless of taking the existing data directory or restoring

Re: Setting up a server with previous day data

On 8/24/22 01:42, Peter J. Holzer wrote: On 2022-08-23 19:15:58 -0500, Ron wrote: That was before someone developed a utility to convert the roll-forward logs into INSERT, UPDATE and DELETE statements. Such a utility for PostgreSQL that would convert yesterday's WAL files into SQL would really

RE: Unable to start replica after failover

Hi, Yes, the *patial* from the *new leader* is restored to *last leader* and renamed to 0002054E00FB, without *partial* postfix. >>Postgres asks for file 0002054E00FB but somehow gets >>0002054E00FB.partial instead. Why? Yes, Postgres asks for 0002054E

Re: recovery_command has precedence over phisical slots?

On Wed, 2022-08-24 at 14:18 +0900, Kyotaro Horiguchi wrote: > At Fri, 19 Aug 2022 18:37:53 +0200, Laurenz Albe > wrote in > > On Fri, 2022-08-19 at 16:54 +0200, Giovanni Biscontini wrote: > > > Hello everyone,  > > > I'm experiencing a behaviour I don't really understand if is a > > > misconfig