DB initialization/ Upgrade issue

From: Ashish Tiwari <tashish786(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: DB initialization/ Upgrade issue
Date: 2017-05-13 12:43:16
Message-ID: CAH8UkmGK2MAvzTN1eVpsZsCvdH929omPsfmHrSuL7K=ZyvxG+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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.

Now when initializaing the DB getting the error as below.

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

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

Any suggestions is welcome

Thanks.

Best regards,
Ashish

On May 12, 2017 23:34, "Günce Kaya" <guncekaya14(at)gmail(dot)com> wrote:

Hi Thomas,

After your mail I figured out that I need export result to excel file. I
used workbench before but I did not know to do it.

Thanks a lot,
Regards.
Gunce

On Fri, 12 May 2017 at 19:21, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Günce Kaya schrieb am 12.05.2017 um 17:58:
> > Thank you for your advice. But I did not want to ask about using
> > Copy. I always use it but my requirement is if there is anyway to
> > export query result to CSV's different sheets.
>
> A CSV file has no sheets (it does not even have a "structure" as it is
> plain text).
>
> The tool I am maintaining can do you what you want (or at least what I
> think you want):
>
> It has a built-in command to export data to various formats including ODS
> or XLSX which you need in order to create multiple "sheets"
>
> The following command
>
> WbExport -file=data.xlsx -sourceTable=table_one,table_two, table_three;
>
> Creates a single XLSX file with three sheets, one for each table.
>
> You can download it here: http://www.sql-workbench.net/
>
> For details on the WbExport command see here:
> http://www.sql-workbench.net/manual/command-export.html
>
> Disclosure: I am the author of that tool.
>
> Regards
> Thomas
>
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
>
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Gunce Kaya

Linkedin <https://tr.linkedin.com/in/guncekaya> - Twitter
<https://twitter.com/gguncesi> - Blog
<http://www.guncekaya.blogspot.com.tr/>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2017-05-13 12:59:30 Re: DB initialization/ Upgrade issue
Previous Message Günce Kaya 2017-05-12 18:03:50 Re: exporting query result

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2017-05-13 12:59:30 Re: DB initialization/ Upgrade issue
Previous Message Günce Kaya 2017-05-12 18:03:50 Re: exporting query result