On Wed, Jan 8, 2020 at 8:52 PM github kran wrote:
> You are right on RDS but I believe the problem is on Aurora PostgreSQL
> where the pglogical throws an error during installation. Are you aware if
> this works on Aurora PostGreSQL
>
It seems like this question should be sent to AWS support fo
shigeo Hirose writes:
> How can I pushdown of functions used in targetlist with FDW ?
There is, AFAIK, no provision for that. There's not a lot of
reason to consider adding it either, because there's no reason
to suppose that the remote node can run such a function any
faster than the local node
On Wed, Jan 08, 2020 at 05:04:21AM +, Daulat Ram wrote:
> I have to implement the streaming replication for our prod environment.
> Can you please share the list of parameters to setup the PostgreSQL
> 11 streaming replication with continuous archiving and give clarity
> on the below.
>
> *
How can I pushdown of functions used in targetlist with FDW ?
I know non-built-in functions can pushdown with WHERE clauses.
https://www.postgresql.org/docs/12/postgres-fdw.html#id-1.11.7.42.10
But I would like to pushdown function when use targetlist.
For example, I would like to change "Remo
On Wed, Jan 08, 2020 at 11:06:28PM -0500, Rita wrote:
> I run a master and standby setup with Postgresql 11. The systems are
> identical from a hardware and software setup. If the master goes down I
> can do a pg_ctl promote on the standby and point my applications to use the
> standby (new master
I run a master and standby setup with Postgresql 11. The systems are
identical from a hardware and software setup. If the master goes down I
can do a pg_ctl promote on the standby and point my applications to use the
standby (new master).
Once the original master is online, when is an appropriate
On Wed, Jan 8, 2020 at 5:57 PM Christophe Pettus wrote:
>
>
> > On Jan 8, 2020, at 15:56, github kran wrote:
> >
> > Great I see its supported based on the link but the problem is we are
> locked into a Aurora RDS and we can't use logical replication on that
> engine.
>
> You can use pglogical o
> On Jan 8, 2020, at 15:56, github kran wrote:
>
> Great I see its supported based on the link but the problem is we are locked
> into a Aurora RDS and we can't use logical replication on that engine.
You can use pglogical on RDS PostgreSQL 9.6.
--
-- Christophe Pettus
x...@thebuild.com
Great I see its supported based on the link but the problem is we are
locked into a Aurora RDS and we can't use logical replication on that
engine. Any thoughts that we can use some alternate mechanism to
migrate the delta data from database 1 ( Running 9.6) to database 2 (
Running 10.6 ) after we
That's a great point, thanks. The DROP SUBSCRIPTION notes say you can:
> Disassociate the subscription from the replication slot by executing ALTER
> SUBSCRIPTION ... SET (slot_name = NONE). After that, DROP SUBSCRIPTION will
> no longer attempt any actions on a remote host.
I'll read some more
On 2020-01-08 22:22, Mike Lissner wrote:
Hi all, this is a follow up from an earlier question I asked about
shortening a chain of logically replicating servers. Right now we have
three servers replicating like this:
A --> B --> C
And we want to remove B so that we have:
A --> C
Is it possible
Hi all, this is a follow up from an earlier question I asked about
shortening a chain of logically replicating servers. Right now we have
three servers replicating like this:
A --> B --> C
And we want to remove B so that we have:
A --> C
Is it possible to DROP the subscription on B to A and the
That's a good trick, thanks again for the help.
Boy, this promises to be a dumb process! I'm unqualified to guess at
what might make this easier, but it does seem like something that
should have some kind of low-level tools that could do the job.
On Wed, Jan 8, 2020 at 1:53 AM Laurenz Albe wrote
On Wed, 8 Jan 2020 at 02:15, Daulat Ram wrote:
> Hi team,
>
>
>
> We would need your help in setting up an environment of EDB Advance Server
> 11 on Dev CentOS 7 VM.
>
>
>
>1. We need to create three database with separate table spaces :
>
>
>
> Test1
>
> Test2
>
> Test3
>
> What would be th
On Wed, Jan 8, 2020 at 7:20 AM github kran wrote:
> Sorry for the confusion, I tried to install this extension on 9.6 and it
> seems to be not working. Does 9.6 PostGreSQL supports logical replication ?
>
No. See the top of this page with supported versions listed. Prior to v10,
pg_logical exte
Sorry for the confusion, I tried to install this extension on 9.6 and it
seems to be not working. Does 9.6 PostGreSQL supports logical replication ?
On Tue, Jan 7, 2020 at 4:56 PM github kran wrote:
>
> On Tue, Dec 10, 2019 at 2:53 AM Andreas Kretschmer <
> andr...@a-kretschmer.de> wrote:
>
>>
>
Thanks, I'll check it out.
Thomas Munro , 7 Oca 2020 Sal, 23:56 tarihinde şunu
yazdı:
> On Wed, Jan 8, 2020 at 4:32 AM İlyas Derse wrote:
> > I want to register C code to PostgreSql on Windows. So I think, I have
> to make a extension for PostgreSql. But I did not find to written extension
> on
On Tue, 2020-01-07 at 23:17 -0800, Mike Lissner wrote:
> > You'd have to suspend all data modification on A in that interval.
>
> I know how to stop the DB completely, but I can't think of any obvious
> ways to make sure that it doesn't get any data modification for a
> period of time. Is there a
Nothing special with the code for the extension itself. Same as other
platforms. Building is another matter.
I have written about compiling pgaudit on Windows on recent Postgres releases
here. This could perhaps supplement the below blog.
https://github.com/njesp/build_pgaudit_on_windows
Reg
19 matches
Mail list logo
