update schema table permission denied

2024-02-02 Thread Vano Beridze
Hello, I've got a table outbox_event in schema adm The owner of this table is some role I granted insert and update permission on the table outbox_event to the user "app" When the following command is run with the user app update adm.outbox_event set .. where id = .. Postgresql gives the notifi

Re: Upgrade 9.5 cluster on Ubuntu 16.04

2021-09-02 Thread Vano Beridze
I just want to upgrade to the OS and Postgres that is supported. If I just stop the service on both VMs and upgrade Ubuntu, then start Postgres, will it work or I should go with clean install and dump/restore? On Thu, Sep 2, 2021 at 10:41 PM Adrian Klaver wrote: > On 9/2/21 11:34 AM, V

Re: Upgrade 9.5 cluster on Ubuntu 16.04

2021-09-02 Thread Vano Beridze
> What repo are you getting Postgres from, Ubuntu or PGDG? Ubuntu On Thu, Sep 2, 2021 at 10:13 PM Adrian Klaver wrote: > On 9/2/21 10:38 AM, Vano Beridze wrote: > > Hello, > > > > I've got 2 VMs with Postgresql 9.5 cluster with streaming replication. > > VMs

Upgrade 9.5 cluster on Ubuntu 16.04

2021-09-02 Thread Vano Beridze
Hello, I've got 2 VMs with Postgresql 9.5 cluster with streaming replication. VMs have Ubuntu 16.04. I would like to upgrade Ubuntu and Postgresql to newer versions. Ubuntu 16.04 supports upgrading to 18.04. What is the safest way to upgrade Postgresql cluster along with it? The database is not b

PostgreSQL native multi-master

2020-04-07 Thread Vano Beridze
Hello, What are the plans to support multi-master natively? What solution would you recommend at this point? preferably free. Kind regards, Vano