Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
Date: 2014-02-15 22:27:47
Message-ID: 20140215222747.GG4406@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Feb 15, 2014 at 10:17:05PM +0000, Antman, Jason (CMG-Atlanta) wrote:

> [...] I see how my original "brilliant" idea
> (multiple DBs per postgres instance on one host, [...]) is insane,
> without some specific support for it in postgres.

"multiple DBs per PostgreSQL instance on one host" is quite
a usual setup unless I am misinterpreting what you say.

> I'm not sure we could reasonably spin them up on demand. Moreover, if we
> were spinning up a VM on demand, we'd end up with the same situation
> we're in now - every dev comes in in the morning and spins up their VM.

Would a cron-ed serialized-into-batches spinup
help with that ?

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Wong 2014-02-15 23:37:38 Re: designing time dimension for star schema
Previous Message Adrian Klaver 2014-02-15 22:19:58 Fwd: Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?