Subject: Re: PostgreSQL 9.3 DB initialization issue
To: Ashish Tiwari <tashish786@gmail.com>
Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
References: 
 <CAH8UkmHAE=EKjjok+GeNq_zei=kne+i=kHAS9nUyO6YZcamfXg@mail.gmail.com>
 <a903b9af-4942-26d8-af15-1e4b7e754848@aklaver.com>
 <CAH8UkmHUiAzdrOaWfe4XHAMcCVkCVgB0kL=XBriJwePYu2R4=g@mail.gmail.com>
 <CAH8UkmGgQcqAkQFF83gsL1fADVVM+1k4vn6nBfYAMsH27x9+aw@mail.gmail.com>
 <CAH8UkmGNKv3-2e8e6D7y3FME5MdhV1fKO0RrU6q3w3MpazzTgA@mail.gmail.com>
 <CAH8UkmFrihRfL4AyrgSpJ-uAdRFz_Jcoe2RiL_x+wr3yJMabyA@mail.gmail.com>
 <CAH8UkmGMZzEB_AL8uTovaRb0DDOD+G5zDcF26JFpXP2bf3CNng@mail.gmail.com>
 <CAH8UkmF8ECHn1D2Jf-1S8PXZF1Ba8ih1dqhZJjU8-z4+KB2vdg@mail.gmail.com>
 <9e6bc162-5082-fd56-fab0-152989e4c002@aklaver.com>
 <CAH8UkmFPO6SEDdNyextO79_S2um5SCVD5gchYx=vhKY8zhjbnQ@mail.gmail.com>
 <CAH8UkmHUnDHMAdBZLOo1zuKQMbpwxp+7MOWfZFio6VDO9zkmbw@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com>
Date: Sat, 13 May 2017 09:44:33 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.0
MIME-Version: 1.0
In-Reply-To: 
 <CAH8UkmHUnDHMAdBZLOo1zuKQMbpwxp+7MOWfZFio6VDO9zkmbw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 05/13/2017 08:53 AM, Ashish Tiwari wrote:
> Hi Andrian,
> 
> The data have kept separate as in
> 
> /pgsql/data2 directory.
> 
> We are passing this path while starting the server using pg-ctl from bin 
> directory as well this data path is given in to postgresql.conf .
> 
> So in current situation the binary is as of 9.3 and data is as of 9.2
> 
> As an alternative can we install the 9.2 and manually make the up DB is 
> it possible Or data is lost ?. finally

If  /pgsql/data2 represents the Postgres 9.2 data directory then the 
data is not lost.

I am including information from your previous post in the below.

 > $./initdb  -D /pgsql/9.3/main/data

Are you overriding the default location that Debian uses?:

https://wiki.debian.org/PostgreSql

I would look at the above to see how you can use the Debian tools to 
maintain/create multiple Postgres clusters.


 > 9.2 is uninstalled now.

You will need to install it again to be able to access the data in the 
9.2 data directory you show above(/pgsql/data2). I would maintain that 
copy(/pgsql/data2) and just copy it into the 9.2 cluster when you get it 
reinstalled. If you want to upgrade to 9.3, then use the 9.3 pg_dumpall 
to dump the 9.2 data and then the 9.3 pg_restore to restore it into the 
9.3 instance.


> 
> Thanks.
> BR,Ashish
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql