Re: connect postgresql to a different cluster

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Zoltan Szecsei <zoltans(at)geograph(dot)co(dot)za>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: connect postgresql to a different cluster
Date: 2015-05-07 16:39:06
Message-ID: CAKFQuwapHCDFv8UhKn4WfxMN1xYZsSBxvpNSY5fk_NzeR6XLKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 7, 2015 at 9:27 AM, Zoltan Szecsei <zoltans(at)geograph(dot)co(dot)za>
wrote:

> But maybe there is an elegant way to "import" a cluster?
>

​It should possible to accomplish your goal without performing "initdb"​ -
though you may find it easier to forgo the Ubuntu utilities and just write
the necessary pg_ctl commands yourself. You indeed need to use either
"$PGDATA" or explicit command line parameters and just point directly at
the cluster data directory that you mounted - with pg_ctl, not initdb.

Whether that is easier than a simple pg_dump/pg_restore ​"import" it up for
you to decide.

You might be able to rename things to match the expected structure for the
Ubuntu cluster commands.

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Zoltan Szecsei 2015-05-07 17:32:37 Re: connect postgresql to a different cluster
Previous Message Zoltan Szecsei 2015-05-07 16:27:13 connect postgresql to a different cluster