Re: [SQL] PostgreSQL 9.3 DB initialization issue

[Ashish Tiwari <tashish786@xxxxxxxxx>]

Hi Adrian,

Please find the in line answers.

Thanks.

On May 13, 2017 18:55, "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx