I'm probably doing this wrong, but I couldn't find any resources to learn how to get this right.
Can the renaming be done without disruption to current connections? From what I've read you have to disconnect everyone before renaming a database.
Can the renaming be done without disruption to current connections? From what I've read you have to disconnect everyone before renaming a database.
2014-06-18 17:47 GMT-03:00 Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>:
As someone who's fought with release engineering for a few years now,On Wed, 18 Jun 2014 17:05:22 -0300 Nicolás Lichtmaier <nico.lichtmaier@xxxxxxxxx> 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?
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@xxxxxxxxxxxxxxxxx>
