On 24-May-20 15:48, Stephen Frost wrote:
That really shouldn't be possible. I'm very curious as to exactly what
happened that resulted in your primary/replica being 'out of sync', as
you say.
Hi Stephen,
Actually this was more a hypothetical question to find a solution in
case some day
Hello
On 2020-05-25 15:50, Laurenz Albe wrote:
On Fri, 2020-05-22 at 08:02 -0500, Ted Toth wrote:
Will RLS be applied to data being retrieved via a FDW?
ALTER FOREIGN TABLE rp_2019 ENABLE ROW LEVEL SECURITY;
ERROR: "rp_2019" is not a table
Doesn't look good.
Yours,
Laurenz Albe
Actually
On 5/24/20 10:30 PM, Nico De Ranter wrote:
Unfortunately not. I discovered the issue rather late. The last working
backup is about 2 months old.
Well first it is entirely possible this is not the only corruption in
the database.
Second you are probably going to have to reach out to the
On Fri, 2020-05-22 at 08:02 -0500, Ted Toth wrote:
> Will RLS be applied to data being retrieved via a FDW?
ALTER FOREIGN TABLE rp_2019 ENABLE ROW LEVEL SECURITY;
ERROR: "rp_2019" is not a table
Doesn't look good.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
On 2020-05-25 10:19, Anders Bøgh Bruun wrote:
Thank you for that clarification. It helps me understand how things work
a lot better.
I know this might be a bit off topic, but my challenge here is that we
are using Patroni (by using Zalando's postgres-operator for Kubernetes),
and any
Thank you for that clarification. It helps me understand how things work a
lot better.
I know this might be a bit off topic, but my challenge here is that we are
using Patroni (by using Zalando's postgres-operator for Kubernetes), and
any replication slot not created by Patroni, seems to be
Hi!
How to set logical replication for all user databases in cluster so that
when new database is added or new tables are added to database they will
start replicate automatically ?
I think that it would be good if you spend some time reading the
documentation on this stuff, particularly the
On Fri, 2020-05-22 at 16:15 +0530, devchef2020 d wrote:
> PostgreSQL : 9.5.15
> Created Indexes on column parental_path:
> =
>
> CREATE INDEX cable_pair_parental_path_idx
> ON SCHEMA.TABLE_NAME
> USING btree
> (md5(parental_path) COLLATE
On Sunday, May 24, 2020, Andrus wrote:
> Hi!
>
> Backup in created in Windows from Linux server using pg_receivewal and
>>> pg_basebackup .
>>> Can this backup used for PITR in Linux ?
>>>
>> No. Physical copies need to be based on the same platform. If you
>> wish to replicate a cluster
On Mon, May 25, 2020 at 09:02:49AM +0300, Andrus wrote:
> Will logical replication also allow two modes:
> 1. PITR recovery can used if needed
> 2. Hot standby: User databases in both clusters contain same data.
>
> How to set logical replication for all user databases in cluster so that
> when
Hi!
No. Physical copies need to be based on the same platform.
Does the O/S that the client software runs on really affect this?
To the extent that the O/S determines text sort order, yes; see thread.
The short answer here is that we aren't going to support such cases.
If you try to
Hi!
Backup in created in Windows from Linux server using pg_receivewal and
pg_basebackup .
Can this backup used for PITR in Linux ?
No. Physical copies need to be based on the same platform. If you
wish to replicate a cluster without any platform, architecture or even
not-too-many major
12 matches
Mail list logo