Hello list.
My database includes one table with 1000 partitions, all of them rather
sizeable. I run:
pg_restore -j12 --no-tablespaces --disable-triggers --exit-on-error
--no-owner --no-privileges -n public -d newdb custom_format_dump.pgdump
Right now after 24h of restore, I notice weird beha
Hello,
I am having issues trying to install the postgis30_13 package on a RHEL9
host. Attempting to install the package gives me this error:
$ sudo dnf install postgis30_13
Updating Subscription Management repositories.
Zabbix 6.0 LTS RHEL9
50 kB/s | 2.0 kB
"David G. Johnston" writes:
> On Thu, Mar 20, 2025 at 2:56 PM Tom Lane wrote:
>> That's documented elsewhere, I believe. For the foo_d.h files,
>> I think it'd be sufficient to do something like 0001 attached.
> WFM. Thanks.
Thanks for looking at it.
>> Also, while checking out the results,
> On Mar 31, 2025, at 11:30, Eden Aharoni wrote:
>
> Can you please tell me what other data might help?
You can show your work on how you got the megabytes/second number. (Be aware
that on a general open-source mailing list, there's only so much debugging that
we can do of a specific probl
postgres 13 BTW
On Fri, Apr 4, 2025 at 10:58 AM Willy-Bas Loos wrote:
> Hi!
>
> I'm looking for a way to find out if there are still replication slots
> active for a publication before dropping the publication in an automated
> way. The idea is that the publication is thought not to be needed an
Hello.
Preconditions.
I have some empty table and constantly try to execute `insert ... on
conflict do update ...` on it. My data in row which I try to insert is
invalid by violation of foreing key constraint, so I am getting error
while inserting and table keeps being empty. This table have some
Hi!
I'm looking for a way to find out if there are still replication slots
active for a publication before dropping the publication in an automated
way. The idea is that the publication is thought not to be needed any
longer, but we want to make sure.
I'm having trouble finding a link between a p
On 3/23/25 10:38, Igor Korot wrote:
Hi, Tom,
2 things, however.
1. Apparently CREATE OR RELACE TRIGGER syntax is available since v17,
which is the current one. So I hadto adjust the numbers.. 😀
Really?:
https://www.postgresql.org/docs/14/sql-createtrigger.html
"CREATE [ OR REPLACE ] [
On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
Hello list.
My database includes one table with 1000 partitions, all of them rather
I was not clear here: my database dump has all that, and the database is
brand new and empty.
sizeable. I run:
pg_restore -j12 --no-tablespaces --disable-trig
Dominique,
That's what Tom already replied, yes. --DD
My bad! I missed that answer from Tom.
Thanks.
Seb
From: Dominique Devienne
Sent: Thursday, March 20, 2025 4:49 PM
To: Sebastien Flaesch
Cc: Tom Lane ; Adrian Klaver ; M
Tarkeshwar Rao ; pgsql-gene...@postg
> On Mar 25, 2025, at 13:58, Phillip Diffley wrote:
>
> Oh I see! I was conflating the data I see coming out of a replication slot
> with the internal organization of the WAL. I think the more specific question
> I am trying to answer is, as a consumer of a replication slot, how do I
> reas
On Thu, 3 Apr 2025 at 18:07, Tom Lane wrote:
> A simple-minded approach could be to just be pessimistic, and
> increase our estimate of how many rows would need to be scanned as a
> consequence of noticing that the columns have significant correlation.
> The shape of that penalty function would be
On 4/4/25 9:45 AM, Ron Johnson wrote:
TRUNCATE statements inside of "toc.dat" files? I'm skeptical.
See my post here:
https://www.postgresql.org/message-id/7be2dcc6-3ba4-4e3f-a154-8d13d816aa9b%40aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
On Wed, Apr 2, 2025 at 1:32 PM Dimitrios Apostolou wrote:
> Hello list.
>
> My database includes one table with 1000 partitions, all of them rather
> sizeable. I run:
>
>pg_restore -j12 --no-tablespaces --disable-triggers --exit-on-error
> --no-owner --no-privileges -n public -d newdb custom_
On 4/4/25 08:09, Dimitrios Apostolou wrote:
On Fri, 4 Apr 2025, Adrian Klaver wrote:
On 4/4/25 06:13, Dimitrios Apostolou wrote:
On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
Bug? This happened on a postgres compiled from last week's master
branch.
Are you talking about the dev versio
On Fri, 4 Apr 2025, Adrian Klaver wrote:
On 4/4/25 06:13, Dimitrios Apostolou wrote:
On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
Bug? This happened on a postgres compiled from last week's master branch.
Are you talking about the dev version?
In this thread, yes. My mistake I didn't
On 4/4/25 06:13, Dimitrios Apostolou wrote:
On Wed, 2 Apr 2025, Dimitrios Apostolou wrote:
Bug? This happened on a postgres compiled from last week's master branch.
Are you talking about the dev version?
The dump I'm trying to restore is from postgres 17.4.
Thanks
Dimitris
--
Adria
17 matches
Mail list logo
