Re: AW: Reducing bandwidth usage of database replication

At Fri, 4 Nov 2022 09:25:44 +, Sascha Zenglein wrote in > I have set the status interval to 600s and it still sends a status message > every 30s. > I also tried setting every available option higher, with no success: I guess you are not setting wal_sender_timeout on the primary side. Stat

Re: Some questions about Postgres

Thanks Laurenz. On Fri, Nov 4, 2022 at 1:55 AM Laurenz Albe wrote: > On Thu, 2022-11-03 at 10:42 -0700, Christophe Pettus wrote: > > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > > I read an old article comparing MySQL to Postgres and wanted to get > answers to following questions. > >

Re: an difficult SQL

Great, with a little tweaking (to get the remaining rows ordered correctly), this did the job. Thank you Erik. BR -R W dniu 6.11.2022 o 15:23, Erik Wienhold pisze: On 06/11/2022 13:48 CET Rafal Pietrak wrote: W dniu 5.11.2022 o 19:05, Thiemo Kellner pisze: You first could select the thre

Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault

Stefan Froehlich writes: > I am using v13, but well: > | # create extension amcheck; > | # select oid, relname from pg_class where relname ='faultytablename_pkey'; > | [returns oid 537203] > | # select bt_index_check(537203, true); > | server closed the connection unexpectedly Oh ... up through

Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault

On Sun, Nov 06, 2022 at 09:13:08AM -0500, Tom Lane wrote: > > | 2022-11-06 11:52:36.367 CET [2098-35] LOG: server process (PID 2964738) > > was terminated by signal 11: Segmentation fault > contrib/amcheck might help to identify the faulty data (at this > point there's reason to fear multiple c

Re: an difficult SQL

> On 06/11/2022 13:48 CET Rafal Pietrak wrote: > > W dniu 5.11.2022 o 19:05, Thiemo Kellner pisze: > > > > You first could select the three users with the most recent entries with > > a windowing function > > (https://www.postgresql.org/docs/15/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS) > > sur

Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault

Stefan Froehlich writes: > I followed the suggestion to trace down the faulty record, found and > fixed it. Now I can access that record again, but if I try to dump > the table I get: > | 2022-11-06 11:52:36.367 CET [2098-35] LOG: server process (PID 2964738) > was terminated by signal 11: Segme

Re: an difficult SQL

Hi Thiemo, Thank you for suggestions. W dniu 5.11.2022 o 19:05, Thiemo Kellner pisze: Hi Rafal You first could select the three users with the most recent entries with a windowing function (https://www.postgresql.org/docs/15/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS) surely I'm missing

server process (PID 2964738) was terminated by signal 11: Segmentation fault

This was starting with an invalid memory alloc request size, like in . I followed the suggestion to trace down the faulty record, found and fixed it. Now I can access that record again, but if I try to dump the table I get:

Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack?

thx... But it's a different item. fyi... On Sat, Nov 5, 2022 at 2:50 PM Tony Shelver wrote: > > On Sat, 5 Nov 2022 at 01:15, Larry Sevilla > wrote: > >> Hi, >> >> I'm studying OpenStack Zed using Ubuntu 22.04 with the following guides: >> >> https://docs.openstack.org/install-guide/ >> >> And