On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan wrote:
> Hi all,
>
> I have a postgres server on Aws RDS no i want to replicate the data or
> logical replication into the on-premise server. I have gone through DMS
> provides the service buy it pricing was high. Do we have any option or
> method to
On Thu, Jun 10, 2021 at 12:39 PM Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
> Wow, the drop table silently removes entry from publication without any
> logs.
>
> I could not find any monitoring view to help me figure out if the
> publication is broken due to ddl change.
> pg_stat_re
On Sat, Oct 10, 2020 at 3:41 AM Peter J. Holzer wrote:
> On 2020-10-05 11:29:04 -0600, Michael Lewis wrote:
> >
> > I suggest that in PG12 you can monitor the
> > "lag" of a standby server more directly by looking at columns
> > write_lag,
> > flush_lag, replay_lag
Another use case is installations where there is heavy reliance on
temporary tables in queries. Since you can't run queries that create
temporary tables on servers that are binary replicas, this leaves the
master (not horizontally scalable) or logical replicas
--cnemelka
On Thu, Oct 10, 2019 a
On Tue, Sep 10, 2019 at 10:11 AM Michael Lewis wrote:
> >My postgres instance is based on docker image postgres:11 and runs on my
> MacBook Pro i7 16GB.
>
> How much ram and such did you give to this vm?
>
>
> >To my surprise, postgres 11 is extremely slow when creating a full text
> index. I add
Well, there is a lot of information we would need to diagnose this. How
much tuning have you done?, etc.
My advice is pretty simple. Don't expect performance on a notebook and,
unless you are planning on hosting it on a notebook, use the notebook for
development only . Test performance on a pro
Thank you :) I'll try restarting postgresql during our next maintenance
window and report back.
--cnemelka
On Mon, Sep 9, 2019 at 3:08 PM Tom Lane wrote:
> "Daniel Verite" writes:
> > I can reproduce this by creating a new locale *after* starting
> > PostgreSQL and trying to use it before a re
│
└───┴──┴──┴─┴─┴───┘
--cnemelka
On Mon, Sep 9, 2019 at 12:45 PM Cory Nemelka wrote:
> We have already run pg_import_system_collations('pg_catalog')
> --cnemelka
>
>
> On Mon, Sep 9, 2019 at 12:43 PM Cory Nemelka wrote:
>
>&
We have already run pg_import_system_collations('pg_catalog')
--cnemelka
On Mon, Sep 9, 2019 at 12:43 PM Cory Nemelka wrote:
> We are having issues with some databases getting our locales generated.
> We are using Ubuntu 18.04 and postgresql 10.8.
>
> Example:
We are having issues with some databases getting our locales generated. We
are using Ubuntu 18.04 and postgresql 10.8.
Example:
*from bash prompt:*
$ locale -a | egrep fr
fr_BE
fr_BE@euro
fr_BE.iso88591
fr_BE.iso885915@euro
fr_BE.utf8
fr_CA
fr_CA.iso88591
fr_CA.utf8
fr_CH
fr_CH.iso88591
fr_CH.u
10 matches
Mail list logo