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
===========================================
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 |