Hello,
We have an existing master-slave setup running on 9.0. I was looking into
adding a new hot standby into this setup — I have added a script that satisfies
the requirements of the archive_command, but it isn't clear to me how to add
this new standby into the mix. Is it as simple as calling
Andrew Hannon wrote:
> Hello,
>
> We have an existing master-slave setup running on 9.0. I was looking
> into adding a new hot standby into this setup — I have added a script
> that satisfies the requirements of the archive_command, but it isn't
> clear to me how to add this new standby into the
I thought about using dblink and the EXCEPT query, but then I need to
know the field list of each query result, which is a pain in the butt.
That is not correct. As long as the table definitions are precisely
the same, you can move records across dblink without specifying
fields. You do this
