PostgreSQL native multi-master
Hello, What are the plans to support multi-master natively? What solution would you recommend at this point? preferably free. Kind regards, Vano
update schema table permission denied
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 notification: ERROR: permission denied for table outbox_event What could be the problem? Version is 16.1 Kind regards, Vano
Upgrade 9.5 cluster on Ubuntu 16.04
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 big and I can afford completely shutdown the cluster during the upgrade. What would you suggest? Kind regards, Vano
Re: Upgrade 9.5 cluster on Ubuntu 16.04
> 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 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? > > What repo are you getting Postgres from, Ubuntu or PGDG? > > > The database is not big and I can afford completely shutdown the cluster > > during the upgrade. > > That is going to happen whether you want it or not 16.04 -> 18.04 is > going to involve a reboot. > > > > > What would you suggest? > > > > Kind regards, > > Vano > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: Upgrade 9.5 cluster on Ubuntu 16.04
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, Vano Beridze wrote: > > > What repo are you getting Postgres from, Ubuntu or PGDG? > > Ubuntu > > So you are going to get version 10. > > Is that what you want? > > If you want to move to something newer then this maybe the time to move > to the PGDG repos, as they allow you to install any of the current > supported versions of Postgres. > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
