Re: Multitenent architecture

2020-06-07 Thread Laurenz Albe
On Sat, 2020-06-06 at 11:56 +0800, Vasu Madhineni wrote: > > > On Fri, Jun 5, 2020 at 2:57 PM Laurenz Albe > > > wrote: > > > > On Thu, 2020-06-04 at 23:52 +0800, Vasu Madhineni wrote: > > > > > We are planning a POC on multitenant architecture in Postgres, Could > > > > > you please > > > > > h

Re: Logical replication - ERROR: could not send data to WAL stream: cannot allocate memory for input buffer

2020-06-07 Thread Michael Paquier
On Fri, Jun 05, 2020 at 10:57:46PM +0200, Aleš Zelený wrote: > we are using logical replication for more than 2 years and today I've found > new not yet know error message from wal receiver. The replication was in > catchup mode (on publisher side some new tables were created and added to > publica

Re: gdal, proj and other postgis dependencies missing in postgres repos

2020-06-07 Thread Rene Romero Benavides
Thank you very much David. On Sun, Jun 7, 2020 at 5:48 PM David G. Johnston wrote: > On Sunday, June 7, 2020, Rene Romero Benavides > wrote: > >> On Sun, Jun 7, 2020 at 5:37 PM Rene Romero Benavides < >> rene.romer...@gmail.com> wrote: >> >>> Hi everybody, do you know what happened to gdal and

Re: gdal, proj and other postgis dependencies missing in postgres repos

2020-06-07 Thread David G. Johnston
On Sunday, June 7, 2020, Rene Romero Benavides wrote: > On Sun, Jun 7, 2020 at 5:37 PM Rene Romero Benavides < > rene.romer...@gmail.com> wrote: > >> Hi everybody, do you know what happened to gdal and other postgis >> dependencies like proj in the official postgres repos? >> they appear to be mi

Re: gdal, proj and other postgis dependencies missing in postgres repos

2020-06-07 Thread Rene Romero Benavides
On Sun, Jun 7, 2020 at 5:37 PM Rene Romero Benavides < rene.romer...@gmail.com> wrote: > Hi everybody, do you know what happened to gdal and other postgis > dependencies like proj in the official postgres repos? > they appear to be missing in these repos > > https://yum.postgresql.org/12/redhat/rh

gdal, proj and other postgis dependencies missing in postgres repos

2020-06-07 Thread Rene Romero Benavides
Hi everybody, do you know what happened to gdal and other postgis dependencies like proj in the official postgres repos? they appear to be missing in these repos https://yum.postgresql.org/12/redhat/rhel-7-x86_64/ https://yum.postgresql.org/11/redhat/rhel-7-x86_64/ https://yum.postgresql.org/10/re

Re: Question on full vacuum clearing waste space

2020-06-07 Thread Adrian Klaver
On 6/7/20 6:06 AM, Wenjun Che wrote: Thank you for the quick response. I ran the script from https://wiki.postgresql.org/wiki/Show_database_bloat, which shows "app_event_users" table has 3751936 as wastedbytes. https://bucardo.org/check_postgres/check_postgres.pl.html#bloat "Please note tha

Re: Question on full vacuum clearing waste space

2020-06-07 Thread Wenjun Che
Thank you for the quick response. I ran the script from https://wiki.postgresql.org/wiki/Show_database_bloat, which shows "app_event_users" table has 3751936 as wastedbytes. On Sun, Jun 7, 2020 at 12:32 AM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > > On Sat, Jun 6, 2020 at 11:24