Message-ID: <52433DB4.2040206@pasteleros.org.ar>
Date: Wed, 25 Sep 2013 16:47:00 -0300
From: Alejandro Brust <alejandrob@pasteleros.org.ar>
Reply-To: alejandrob@pasteleros.org.ar
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:17.0) Gecko/20130503 Thunderbird/17.0.5
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: pd_dump server mismatch error
References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
 <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com>
 <A737B7A37273E048B164557ADEF4A58B17C23A2B@ntex2010a.host.magwien.gv.at>
 <1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com>
 <1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com>
 <1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com>
 <A737B7A37273E048B164557ADEF4A58B17C23CED@ntex2010a.host.magwien.gv.at>
 <1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com>
In-Reply-To: <1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com>
Content-Type: multipart/alternative;
 boundary="------------020303010209080706040006"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------020303010209080706040006
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Hello, first excuse my English
U cant do a backup whit a Client minor version than the server
U must have same version to do the backup, so U need upgrade your client
(pg_dump 8.4.13) to at least 9.2.4


See U


El 25/09/2013 15:55, Thara Vadakkeveedu escribió:
>
> Hi
> I wanted to take a backup of my database.
>
> pg_dump throws a server mismatch version error
>
> # cd backups
> # su - postgres
> -bash-4.1$ pg_dump mydb > mydbfile
> pg_dump: server version: 9.2.4; pg_dump version: 8.4.13
> pg_dump: aborting because of server version mismatch
>
> This is a fresh install of postgresql on a red hat linux server that
> did not have any previous database installed on it . I installed
> postgresql 9.2 from an rpm (pgdg-redhat92-9.2-7.noarch.rpm ) using yum
> install.
>
> Why am I seeing this error?
> How can I take a backup of my database? There are two tables that have
> 20,000+ rows in it, that I want to backup  and restore when needed.
>
> thanks
> thara.
>


--------------020303010209080706040006
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello, first excuse my English<br>
    U cant do a backup whit a Client minor version than the server<br>
    U must have same version to do the backup, so U need upgrade your
    client (pg_dump 8.4.13) to at least 9.2.4<br>
    <br>
    <br>
    See U<br>
    <br>
    <br>
    <div class="moz-cite-prefix">El 25/09/2013 15:55, Thara Vadakkeveedu
      escribi&oacute;:<br>
    </div>
    <blockquote
      cite="mid:1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com"
      type="cite">
      <div style="color:#000; background-color:#fff; font-family:times
        new roman, new york, times, serif;font-size:14pt">
        <div><span><br>
          </span></div>
        Hi<br>
        I wanted to take a backup of my database. <br>
        <br>
        pg_dump throws a server mismatch version error<br>
        <br>
        # cd backups<br>
        # su - postgres<br>
        -bash-4.1$ pg_dump mydb &gt; mydbfile<br>
        pg_dump: server version: 9.2.4; pg_dump version: 8.4.13<br>
        pg_dump: aborting because of server version mismatch<br>
        <br>
        This is a fresh install of postgresql on a red hat linux server
        that did not have any previous database installed on it . I
        installed postgresql 9.2 from an rpm
        (pgdg-redhat92-9.2-7.noarch.rpm ) using yum install.<br>
        <br>
        Why am I seeing this error?<br>
        How can I take a backup of my database? There are two tables
        that have 20,000+ rows in it, that I want to backup&nbsp; and restore
        when needed.<br>
        <br>
        thanks<br>
        thara.<br>
        <br>
        <div style="font-family: times new roman, new york, times,
          serif; font-size: 14pt;">
          <div style="font-family: times new roman, new york, times,
            serif; font-size: 12pt;"> </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------020303010209080706040006--