From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Zoltan Szecsei <zoltans@geograph.co.za>
Cc: pgsql-admin@postgresql.org
Subject: Re: connect postgresql to a different cluster
Date: Thu, 7 May 2015 13:02:53 -0500 (GMT+5)
Message-ID: <58149.192.168.207.54.1431021773.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <554B9261.9080305@geograph.co.za>
References: <554B9261.9080305@geograph.co.za>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
>
> 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;
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gilberto.castillo@etecsa.cu, zoltans@geograph.co.za
Subject: Re: connect postgresql to a different cluster
In-Reply-To: <58149.192.168.207.54.1431021773.squirrel@webmail.etecsa.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox