Search Postgresql Archives

Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format for cloning schemas

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Mar 9, 2018 at 6:26 AM, Aldrin Martoq Ahumada <aldrin.martoq@xxxxxxxxx> wrote:
Thinking in the long term, how could be the best way to clone a schema into another?

Depends on why you are cloning schemas.

Generally not cloning is the best bet - instead place the reference schema into version control and simply install it whenever necessary.  Parameterize the installation script.

​Or, clone into a different database and leave the namespace the same.

pg_dump, as currently written, is tasked with recreating the original database exactly and safely.  If you need it to do something different you could teach it the desired behavior and add some relevant command line switches to enable said behavior.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux