Re: Replacing a production db

On Wed, 18 Jun 2014 17:05:22 -0300 Nicolás Lichtmaier <nico(dot)lichtmaier(at)gmail(dot)com> wrote:

> Is there a way to replace a production database with another as part of a
> new "release" of our website?
>
> Where I work we have a scheme of pushing code+db releases to "testing" and
> then to "production". Most of our databases use MySQL and I was told they
> can just rename the db and it works. We are adopting PostgreSQL for some
> new developments and we'd like to do something similar. I've tried loading
> the dump in a single transaction, but that has many problems as the
> database is fairly big for that (some GBs). Is there a trick I'm missing
> here?

As someone who's fought with release engineering for a few years now,
let me start off by saying that you're probably doing it wrong.

That being said, you can rename databases in Postgres just like you
can in MySQL (in fact, it's more reliable in Postgres) so I don't
understand why you can't continue to do it that way.

--
Bill Moran <wmoran(at)potentialtech(dot)com>