Re: [SQL] PostgreSQL 9.3 DB initialization issue

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