Message-ID: <554BA1B5.6090803@geograph.co.za>
Date: Thu, 07 May 2015 19:32:37 +0200
From: Zoltan Szecsei <zoltans@geograph.co.za>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: gilberto.castillo@etecsa.cu
CC: pgsql-admin@postgresql.org
Subject: Re: connect postgresql to a different cluster
References: <554B9261.9080305@geograph.co.za>
 <58149.192.168.207.54.1431021773.squirrel@webmail.etecsa.cu>
In-Reply-To: <58149.192.168.207.54.1431021773.squirrel@webmail.etecsa.cu>
Content-Type: multipart/alternative;
 boundary="------------070109040709020301050800"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------070109040709020301050800
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------070109040709020301050800
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi,<br>
      Thanks to David and Gilberto for the input.<br>
      <br>
      All sorted and working.<br>
      <br>
      Kind regards,<br>
      Zoltan<br>
      <br>
      <br>
      On 2015/05/07 20:02, Gilberto Castillo wrote:<br>
    </div>
    <blockquote
      cite="mid:58149.192.168.207.54.1431021773.squirrel@webmail.etecsa.cu"
      type="cite">
      <pre wrap="">

</pre>
      <blockquote type="cite">
        <pre wrap="">
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?
</pre>
      </blockquote>
      <pre wrap="">
Use:
  pg_ctl -D /mnt/geo_pgsql/postgres -l /tmp/logfile start

Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
</pre>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <a class="moz-txt-link-rfc2396E" href="http://www.kaspersky.com">&lt;http://www.kaspersky.com&gt;</a>, <a class="moz-txt-link-rfc2396E" href="http://www.viruslist.com">&lt;http://www.viruslist.com&gt;</a>
</pre>
    </blockquote>
    <br>
    <br>
    <pre class="moz-signature" cols="72">-- 

===========================================
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     <a class="moz-txt-link-abbreviated" href="http://www.geograph.co.za">www.geograph.co.za</a>
===========================================</pre>
  </body>
</html>

--------------070109040709020301050800--