Postgres Pro
Downloads
Home   >   mailing lists

Thread: Will "rename database" get replicated?

Will "rename database" get replicated?

From
"Gauthier, Dave"
Date:

Hi:

 

Will V9.0.1 streaming replication replicate the effects of "alter database foo rename to fee" ?

Will it replicate "analyze" (I do this after a big DB load to give the query optimizer good stats to work with)?

If I kill a user on the master (using "pg_ctl kill ABRT procpid"), will that goof up replication if that user was in the middle of a write transation?

 

I've read in http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#5_Minutes_to_Simple_Replication ...

 

What Can't You Do With Binary Replication?

*  Replicate a specific table, schema, or database. Binary replication is the entire Postgres instance (or "cluster").

*  Multi-master replication. Multi-master binary replication is probably technically impossible.

*  Replicate between different versions of PostgreSQL, or between different platforms.

*  Set up replication without administration rights on the server. Sorry, working on it.

*  Replicate data synchronously, guaranteeing zero data loss. But ... this is coming in PostgreSQL 9.1.

 

 

Beside the last one, are any of the other 4 going to be addressed in 9.1 ?

 

Thanks in advance.

 

Re: Will "rename database" get replicated?

From
Guillaume Lelarge
Date:
Le 09/02/2011 20:06, Gauthier, Dave a écrit :
> Hi:
>
> Will V9.0.1 streaming replication replicate the effects of "alter database foo rename to fee" ?

Yes.

> Will it replicate "analyze" (I do this after a big DB load to give the query optimizer good stats to work with)?

AFAIK, yes.

> If I kill a user on the master (using "pg_ctl kill ABRT procpid"), will that goof up replication if that user was in
themiddle of a write transation? 

No.

> I've read in http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#5_Minutes_to_Simple_Replication ...
>
> What Can't You Do With Binary Replication?
> [PicExportError]  Replicate a specific table, schema, or database. Binary replication is the entire Postgres instance
(or"cluster"). 
> [PicExportError]  Multi-master replication. Multi-master binary replication is probably technically impossible.
> [PicExportError]  Replicate between different versions of PostgreSQL, or between different platforms.
> [PicExportError]  Set up replication without administration rights on the server. Sorry, working on it.
> [PicExportError]  Replicate data synchronously, guaranteeing zero data loss. But ... this is coming in PostgreSQL
9.1.
>
>
> Beside the last one, are any of the other 4 going to be addressed in 9.1 ?
>

I know no-one working on the four first. And there is work ongoing for
the last one, but it may not make it for 9.1.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com