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

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: "Antman, Jason (CMG-Atlanta)" <Jason(dot)Antman(at)coxinc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
Date: 2014-02-16 13:43:58
Message-ID: CA+bJJbx+U9EF04gYEnOZDoyb7Jw9h+gsmW-x16f-viPbc9AY9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Jason:

On Sat, Feb 15, 2014 at 11:17 PM, Antman, Jason (CMG-Atlanta)
<Jason(dot)Antman(at)coxinc(dot)com> wrote:
> the best we'll be able to do is try to run multiple postgres instances
> on each host, and manage the whole "service postgresql-9.0-24 stop"
> craziness that comes with that...

Just a sugestion, I would not try to integrate them with the normal
service infrastructure. I'll shoot more for confining them under a
single user account, probably the postgres one, and have a nice tree
of dirs under it, with scripts going more along the way 'testpg 5432
start/stop/copy/create'

Francisco Olarte.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2014-02-16 13:52:33 Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?
Previous Message Francisco Olarte 2014-02-16 13:38:36 Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces?