Re: [SQL] PostgreSQL 9.3 DB initialization issue

Hi Adrian,

Please find the in line answers.

Thanks.

On May 13, 2017 18:55, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:

On 05/13/2017 06:11 AM, Ashish Tiwari wrote:

> Hi Team,
>
> Our team has done some activity but they didn't take the backup before
> activity .it was setting of replication.The Pg data has been kept secure.
>

What data, a dump file or the data directory?

Pgsql/9.3/main

What do you mean by setting of replication?

Enabling the Archive and WAL setting.

>
> Now when initializaing the DB getting the error as below.
>

So you ran initdb to create a cluster?

Yes ..

Or did you do something else?

> The database cluster was initialized with PG_CONTROL_VERSION 922, but the
> server was compiled with PG_CONTROL_VERSION 937.
>

The above would seem to indicate you tried to start a Postgres 9.3 server
using a Postgres 9.2 data directory.

Yes.it seems right.

> Any solution if DB can be upgraded from 9.2 to 9.3.
>

You are trying to upgrade from Postgres 9.2 to 9.3?

How was Postgres installed?

Sudo apt-get install

What OS and version?

Ubuntu 14.04 LTS

>
> Any suggestions are welcome
>
>
> Thanks.
>
> Best regards,
> Ashish
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com