Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
Date
Msg-id 20140215222747.GG4406@hermes.hilbert.loc
Whole thread Raw
In response to Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?  ("Antman, Jason (CMG-Atlanta)" <Jason.Antman@coxinc.com>)
Responses Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?  ("Antman, Jason (CMG-Atlanta)" <Jason.Antman@coxinc.com>)
List 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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Fwd: Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
Next
From: Mark Wong
Date:
Subject: Re: designing time dimension for star schema