On Mon, 2020-05-18 at 18:43 +0200, Albrecht Dreß wrote:
> in a database I have a table with a text, a jsonb and a bytea column, which
> together shall be unique, like:
>
>
> Column | Type | Collation | Nullable | Default
> -++---+--+-
On 5/18/20 6:51 PM, Tom Lane wrote:
Don Seiler writes:
On Mon, May 18, 2020 at 1:40 AM Laurenz Albe
wrote:
Perhaps autovacuum never handled "template0" because it concluded (rightly)
that it has to deal with "foo_db" first.
Yes this DB had a table in it that had been autovacuuming since Fe
On Mon, May 18, 2020 at 8:51 PM Tom Lane wrote:
>
> Do you have an idea why autovac was failing to clear the issue on that one
> problem table, though?
>
Before I intervened, the maintenance_work_mem was only 16MB (they had
encoded and carried over PG 8 defaults in the chef recipe). I bumped it
Don Seiler writes:
> On Mon, May 18, 2020 at 1:40 AM Laurenz Albe
> wrote:
>> Perhaps autovacuum never handled "template0" because it concluded (rightly)
>> that it has to deal with "foo_db" first.
> Yes this DB had a table in it that had been autovacuuming since Feb 2. It's
> age is half way to
On Mon, May 18, 2020 at 1:40 AM Laurenz Albe
wrote:
>
> Did you see any weird messages when you vacuumed "template0"?
>
No.
> Did "datfrozenxid" shrink after the operation?
>
> "foo_db" seems to be the bigger problem.
Perhaps autovacuum never handled "template0" because it concluded (rightly)
Hi all,
in a database I have a table with a text, a jsonb and a bytea column, which
together shall be unique, like:
Column | Type | Collation | Nullable | Default
-++---+--+-
id | bigint | | n
Hi!
This is confused or at least confusing.
- "max_wal_size" of 5TB is clearly insane.
- I don't understand what you mean by "Start backup server for hot standby
backups".
Do I get it right that you want to copy a streaming replication standby
server's data
directory to perform PITR?
I want
Hello team,
I am facing the below error related to pg_basebackup.Tried to find solution.
I also see the DB log but we not found any backup failed error log.
[cid:image001.png@01D62D00.27C23FE0]
Regards,
Ram Pratap.
Lava International Limited.
Tel+ 91-120-4637148
[cid:image001.jpg@01CFD804.C42
