Unable to compile postgres 13.1 on Slackware current x64

Hello, unable to compile Postgresql 13.0 and 13.1 on Slackware current x64. Here is gcc -v: Reading specs from /usr/lib64/gcc/x86_64-slackware-linux/9.3.0/specs COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/libexec/gcc/x86_64-slackware-linux/9.3.0/lto-wrapper Target: x86_64-slackware-linux Configur

Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

Thanks, it's my local copy, which I drop and rebuild constantly as part of my testing cycle. On our deployed servers, my patch and test procedures are very strict. Locally, I like to experiment and blow things up. Well, mission accomplished there ;-) Thanks for taking the time to answer. On Mon,

Restoring database from false update

‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 8:23 PM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, November 15, 2020 4:32 PM, David G. Johnston >> wrote: >> >>> On Sunday, November 15, 2020, M

Re: Restoring database from false update

On Sunday, November 15, 2020, Maksim Fomin wrote: > > > ‐‐‐ Original Message ‐‐‐ > On Sunday, November 15, 2020 4:32 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, Nove

Restoring database from false update

‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 4:32 PM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, November 15, 2020 7:27 AM, David G. Johnston >> wrote: >> >>> On Sunday, November 15, 2020, M

Re: two questions about toast

On 11/15/20 9:03 AM, Luca Ferrari wrote: Hi all, I've a couple of doubts about toast: 1) is a REINDEX DATABASE hitting also toast tables or they need to be reindexed manually? https://www.postgresql.org/docs/current/sql-reindex.html "DATABASE Recreate all indexes within the current databa

Re: New "function tables" in V13 documentation

On 11/15/20 9:00 AM, David G. Johnston wrote: On Sun, Nov 15, 2020 at 9:39 AM Adrian Klaver > wrote: On 11/14/20 8:24 PM, David G. Johnston wrote: > On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver mailto:adrian.kla...@aklaver.com> >

two questions about toast

Hi all, I've a couple of doubts about toast: 1) is a REINDEX DATABASE hitting also toast tables or they need to be reindexed manually? 2) while executing a query against toasted values I got this debug message that I don't know what is meaning DEBUG: building index "pg_toast_33875_index" on table

Re: New "function tables" in V13 documentation

On 11/14/20 8:24 PM, David G. Johnston wrote: On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver > wrote: Which is an indication that for changes of this scope it would be prudent to create a mock up and have end users see and comment on before rollin

Re: New "function tables" in V13 documentation

On Sun, Nov 15, 2020 at 9:39 AM Adrian Klaver wrote: > On 11/14/20 8:24 PM, David G. Johnston wrote: > > On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver > > wrote: > > > > Which is an indication that for changes of this scope it would be > > prudent to cre

Re: I have just downloaded Postgre SQL and "pgadmin 4" doesn't open.

On 11/15/20 4:51 AM, Ecenur Corlu wrote: Hello Mr Klaver, I downloaded it from "https://www.enterprisedb.com/software-downloads-postgres " The above needs an account to access. Is this one of the EDB paid versions of Postgres? The

Re: New "function tables" in V13 documentation

On 11/14/20 8:24 PM, David G. Johnston wrote: On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver > wrote: Which is an indication that for changes of this scope it would be prudent to create a mock up and have end users see and comment on before rollin

Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

Morris de Oryx writes: > After posting, I realized that this is likely a Stupid User Error. I was > mucking around, and did something along the lines of > delete from pg_statistic_ext; > or > delete from pg_stats_ext; > ...instead of DROP STATISTICS calls. Would this likely explain what I'm > see

Re: Restoring database from false update

On Sunday, November 15, 2020, Maksim Fomin wrote: > ‐‐‐ Original Message ‐‐‐ > On Sunday, November 15, 2020 7:27 AM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> >> > plsql -d tsvt >> psql (12.5) >> Type "help" for he

Restoring database from false update

‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 7:27 AM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >>> plsql -d tsvt >> psql (12.5) >> Type "help" for help. >> >> tsvt=# \dt+ >> List of relations >> Schema | Name | Type | Owner | Size | Descrip

Re: I have just downloaded Postgre SQL and "pgadmin 4" doesn't open.

Hello Mr Klaver, I downloaded it from " https://www.enterprisedb.com/software-downloads-postgres"; I start it by just clicking on "pgadmin 4" from the start menu. I also tried starting it by clicking on "run as administrator" My system is : Windows 10 Ram 12GB (11.9 GB usable Ram) Intel(R) Core (

Re: Bi-directional Replica updates

ne 15. 11. 2020 v 12:58 odesílatel Job napsal: > > Dear Postgresql Community, > > I have been using the "vintage" Rubyrep to replicate some tables on multiple > Postgresql 9.6 databases. > For performance improving, I'd need to upgrade to Postgresql 12 but, since > sequences are managed differen

Bi-directional Replica updates

Dear Postgresql Community, I have been using the "vintage" Rubyrep to replicate some tables on multiple Postgresql 9.6 databases. For performance improving, I'd need to upgrade to Postgresql 12 but, since sequences are managed differently, Rubyrep does not work since it had no updates during la

Re: conflict with recovery when delay is gone

On Sun, Nov 15, 2020 at 12:48 AM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > > > On Sat, Nov 14, 2020 at 2:46 PM Radoslav Nedyalkov > wrote: > >> >> >> On Fri, Nov 13, 2020 at 8:13 PM Radoslav Nedyalkov >> wrote: >> >>> >>> >>> On Fri, Nov 13, 2020 at 7:37 PM Laurenz Albe >>> wr

Re: Race condition with restore_command on streaming replica

On Thu, Nov 5, 2020 at 1:39 AM Brad Nicholson wrote: > > Hi, > > I've recently been seeing a race condition with the restore_command on > replicas using streaming replication. > > On the primary, we are archiving wal files to s3 compatible storage via > pgBackRest. In the recovery.conf section o

Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

After posting, I realized that this is likely a Stupid User Error. I was mucking around, and did something along the lines of delete from pg_statistic_ext; or delete from pg_stats_ext; ...instead of DROP STATISTICS calls. Would this likely explain what I'm seeing? If so, bug is in front of keybo