[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: [SQL] DB initialization/ Upgrade issue
From: Ashish Tiwari <tashish786 () gmail ! com>
Date: 2017-05-13 12:55:16
Message-ID: CAH8UkmGK2MAvzTN1eVpsZsCvdH929omPsfmHrSuL7K=ZyvxG+A () mail ! gmail ! com
[Download RAW message or body]
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@gmail.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@gmx.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@postgresql.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/>
[Attachment #3 (text/html)]
<div dir="auto">Hi Team,<div dir="auto"><br></div><div dir="auto">Our team has done \
some activity but they didn't take the backup before <a \
href="http://activity.it">activity.it</a> was setting of replication.The Pg data has \
been kept secure.</div><div dir="auto"><br></div><div dir="auto">Now when \
initializaing the DB getting the error as below.</div><div dir="auto"><br></div><div \
dir="auto">The database cluster was initialized with PG_CONTROL_VERSION 922, but the \
server was compiled with PG_CONTROL_VERSION 937.</div><div dir="auto"><br></div><div \
dir="auto">Any solution if DB can be upgraded from 9.2 to 9.3.</div><div \
dir="auto"><br></div><div dir="auto">Any suggestions is welcome</div><div \
dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">Thanks.</div><div \
dir="auto"><br></div><div dir="auto">Best regards,</div><div \
dir="auto">Ashish</div></div><div class="gmail_extra"><br><div class="gmail_quote">On \
May 12, 2017 23:34, "Günce Kaya" <<a \
href="mailto:guncekaya14@gmail.com">guncekaya14@gmail.com</a>> wrote:<br \
type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div>Hi Thomas,</div><div><br></div><div>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. </div><div><br></div><div>Thanks a lot,</div><div>Regards. \
</div><div>Gunce</div><div><br><div class="gmail_quote"><div>On Fri, 12 May 2017 at \
19:21, Thomas Kellerer <<a href="mailto:spam_eater@gmx.net" \
target="_blank">spam_eater@gmx.net</a>> wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div class="quoted-text">Günce Kaya schrieb am 12.05.2017 um \
17:58:<br> > Thank you for your advice. But I did not want to ask about using<br>
> Copy. I always use it but my requirement is if there is anyway to<br>
> export query result to CSV's different sheets.<br>
<br></div>
A CSV file has no sheets (it does not even have a "structure" as it is \
plain text).<br> <br>
The tool I am maintaining can do you what you want (or at least what I think you \
want):<br> <br>
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"<br> <br>
The following command<br>
<br>
WbExport -file=data.xlsx -sourceTable=table_one,table_<wbr>two, table_three;<br>
<br>
Creates a single XLSX file with three sheets, one for each table.<br>
<br>
You can download it here: <a href="http://www.sql-workbench.net/" rel="noreferrer" \
target="_blank">http://www.sql-workbench.net/</a><br> <br>
For details on the WbExport command see here: <a \
href="http://www.sql-workbench.net/manual/command-export.html" rel="noreferrer" \
target="_blank">http://www.sql-workbench.net/<wbr>manual/command-export.html</a><br> \
<br>
Disclosure: I am the author of that tool.<br>
<br>
Regards<br>
Thomas<br>
<br>
<br>
<br>
<br>
--<br>
Sent via pgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org" \
target="_blank">pgsql-sql@postgresql.org</a>)<div class="quoted-text"><br> To make \
changes to your subscription:<br> </div><a \
href="http://www.postgresql.org/mailpref/pgsql-sql" rel="noreferrer" \
target="_blank">http://www.postgresql.org/<wbr>mailpref/pgsql-sql</a><br> \
</blockquote></div></div><div class="elided-text"><div dir="ltr">-- <br></div><div \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr">Gunce \
Kaya</div><div dir="ltr"><br></div><div dir="ltr"><a \
href="https://tr.linkedin.com/in/guncekaya" style="color:rgb(17,85,204)" \
target="_blank">Linkedin</a><span style="font-size:small"> - </span><a \
href="https://twitter.com/gguncesi" style="color:rgb(17,85,204)" \
target="_blank">Twitter</a><span style="font-size:small"> - </span><a \
href="http://www.guncekaya.blogspot.com.tr/" style="color:rgb(17,85,204)" \
target="_blank">Blog</a><br></div></div></div></div> \
</div></blockquote></div><br></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic