Re: HotSync Replicate doubt?

Good, them I must tested, thanks guys!!!

On Thu, Mar 30, 2017 at 9:49 AM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 03/30/2017 09:39 AM, Periko Support wrote:
>>
>> Hi guys.
>>
>> I had some doubt about PSQL internal replication mechanics(Streaming).
>>
>> If I setup a Master-Slave Hot StandBy.
>>
>> The slave is on a Read-Only stage, but we can query the server.
>>
>> If a user create a table in the database:
>>
>> CREATE DATABASE mynewdb;
>> CREATE TABLE mytbale-name + fields.
>>
>> Or if changes a table with new fields or remove fields.
>>
>> Does the replication will send this commands to the SLAVE without user
>> intervention?
>>
>> I run bucardo for replication, but this feature doesn't work, we need
>> to manually do it on the
>> SLAVE and some other steps to have both DB sync.
>>
>> We already know how to do it, bucardo works.
>>
>> Just wondering if PSQL can handle this automatically?
>
>
> Yes, with an exception:
>
> https://www.postgresql.org/docs/9.6/static/warm-standby.html
>
> 26.2.1. Planning
>
> "Keep in mind that if CREATE TABLESPACE is executed on the primary, any new
> mount point needed for it must be created on the primary and all standby
> servers before the command is executed"
>
>>
>> Thanks.
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com