Re: connect postgresql to a different cluster

From: Zoltan Szecsei <zoltans(at)geograph(dot)co(dot)za>
To: gilberto(dot)castillo(at)etecsa(dot)cu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: connect postgresql to a different cluster
Date: 2015-05-07 17:32:37
Message-ID: 554BA1B5.6090803@geograph.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
Thanks to David and Gilberto for the input.

All sorted and working.

Kind regards,
Zoltan

On 2015/05/07 20:02, Gilberto Castillo wrote:
>
>> Hi,
>> My question refers to a newly installed postgresql 9.4 on ubuntu 15.04.
>>
>> Is it possible to mount a file system with an existing 9.4 version
>> postgresql cluster onto a new machine and get a fresh postgresql install
>> to connect to that cluster?
>>
>> When I installed postgresql it created a /var/lib/postgrersql/9.4/main
>> cluster, and pointed to it via /etc/postgresql/9.4/main
>>
>> I then mounted a HD with an existing v9.4 postgresql cluster called
>> gisdata at /mnt/geo_pgsql/postgres.
>> Note that I have no /etc/postgresql/9.4/gisdata directory. (I forgot to
>> back it up before reinstalling ubuntu)
>>
>> initdb -D /mnt/geo_pgsql/postgres will clobber my existing gisdata
>> cluster, will it not?
> Use:
> pg_ctl -D /mnt/geo_pgsql/postgres -l /tmp/logfile start
>
> Saludos,
> Gilberto Castillo
> ETECSA, La Habana, Cuba
>
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

--

===========================================
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
GIS and Photogrammetric Services

P.O. Box 7, Muizenberg 7950, South Africa.

Mobile: +27-83-6004028
Fax: +27-86-6115323 www.geograph.co.za
===========================================

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2015-05-07 18:02:53 Re: connect postgresql to a different cluster
Previous Message David G. Johnston 2015-05-07 16:39:06 Re: connect postgresql to a different cluster