pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Ashish Tiwari <tashish786@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: PostgreSQL 9.3 DB initialization issue
Date: Sat, 13 May 2017 09:44:33 -0700
Message-ID: <727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com> (raw)
In-Reply-To: <CAH8UkmHUnDHMAdBZLOo1zuKQMbpwxp+7MOWfZFio6VDO9zkmbw@mail.gmail.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (10+ messages) latest in thread
Message-ID: <727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com>
Permalink: ../727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com/
Also on: postgresql.org/message-id/727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com
reply
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-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, tashish786@gmail.com, pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 9.3 DB initialization issue
In-Reply-To: <727a25d0-00ab-15c3-9eff-1ec7b8e3588f@aklaver.com>
* 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