Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2024-11-29 Thread Alvaro Herrera
Hello, On 2024-Nov-29, Paul Foerster wrote: > > On 29 Nov 2024, at 18:15, Alvaro Herrera wrote: > > This reports case 2 as OK and case 1 as bogus, as should be. I tried > > adding more partitions and this seems to hold correctly. I was afraid > > though that this would fail if we create an FK

Re: Errors when restoring backup created by pg_dumpall

2024-11-29 Thread Adrian Klaver
On 11/29/24 17:34, PopeRigby wrote: My HDD recently failed so I'm trying to restore my backup, but I'm running into some errors. I've been using a systemd service that periodically backs up my cluster with pg_dumpall, and I'm using this command to restore: sudo psql -f backup.sql postgres I

Re: Errors when restoring backup created by pg_dumpall

2024-11-29 Thread Ron Johnson
On Fri, Nov 29, 2024 at 8:35 PM PopeRigby wrote: > My HDD recently failed so I'm trying to restore my backup, but I'm > running into some errors. > > I've been using a systemd service that periodically backs up my cluster > with pg_dumpall, and I'm using this command to restore: > > sudo psql -f

Errors when restoring backup created by pg_dumpall

2024-11-29 Thread PopeRigby
My HDD recently failed so I'm trying to restore my backup, but I'm running into some errors. I've been using a systemd service that periodically backs up my cluster with pg_dumpall, and I'm using this command to restore: sudo psql -f backup.sql postgres I'm getting this output: https://gist

Re: Find out the version of the server

2024-11-29 Thread Igor Korot
Thx. On Fri, Nov 29, 2024, 2:03 PM Tom Lane wrote: > Adrian Klaver writes: > > On 11/29/24 11:15 AM, Igor Korot wrote: > >> Are you saying that the current version can connect even to 9.6.1 > >> server? (I have a really old Mac with the 9.6.1 version installed). > > > Yes. > > Current libpq wi

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2024-11-29 Thread Paul Foerster
Hi Alvaro, > On 29 Nov 2024, at 18:15, Alvaro Herrera wrote: > > This all was to say that the query in the release notes is undoubtedly > wrong. After thinking some more about it, I think the fix is to add 1 > to the number of constraints: > > SELECT conrelid::pg_catalog.regclass AS "constrain

Re: Find out the version of the server

2024-11-29 Thread Tom Lane
Adrian Klaver writes: > On 11/29/24 11:15 AM, Igor Korot wrote: >> Are you saying that the current version can connect even to 9.6.1 >> server? (I have a really old Mac with the 9.6.1 version installed). > Yes. Current libpq will probably work with servers back to around 7.0 (whenever we introdu

Re: Find out the version of the server

2024-11-29 Thread Igor Korot
Hi, Adrian, On Fri, Nov 29, 2024, 1:24 PM Adrian Klaver wrote: > Reply to list also > > Ccing list > > On 11/29/24 11:15 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Fri, Nov 29, 2024 at 10:12 AM Adrian Klaver > > wrote: > >> > > >> Reuse it for what? > > > > For building.. > > I got a link

Re: Find out the version of the server

2024-11-29 Thread Adrian Klaver
Reply to list also Ccing list On 11/29/24 11:15 AM, Igor Korot wrote: Hi, Adrian, On Fri, Nov 29, 2024 at 10:12 AM Adrian Klaver wrote: Reuse it for what? For building.. I got a linking errors of not finding sscanf() and sprntf() when building my code. Googling revealed that MSVC made

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2024-11-29 Thread Alvaro Herrera
On 2024-Nov-27, Tom Lane wrote: > I doubt that there's anything actually wrong with the catalog state at > this point (perhaps Alvaro would confirm that). That leads to the > conclusion that what's wrong is the release notes' query for fingering > broken constraints, and it needs some additional

Re: Find out the version of the server

2024-11-29 Thread Adrian Klaver
On 11/28/24 17:31, Igor Korot wrote: Hi, ALL, In April of 2017 I got the source code of the Postgresql, build the libpq and then deleted everything else. I was using MSVC 3010 at the time. Now I moved to MSVC 2017 but unfortunately I can't reuse the library built, since MSVC changed one of