pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alejandro Brust <alejandrob@pasteleros.org.ar>
To: pgsql-admin@postgresql.org
Subject: Re: pd_dump server mismatch error
Date: Wed, 25 Sep 2013 16:47:00 -0300
Message-ID: <52433DB4.2040206@pasteleros.org.ar> (raw)
In-Reply-To: <1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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.
>

view thread (8+ messages)  latest in thread

Message-ID: <52433DB4.2040206@pasteleros.org.ar>
Permalink:  ../52433DB4.2040206@pasteleros.org.ar/
Also on:    postgresql.org/message-id/52433DB4.2040206@pasteleros.org.ar

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alejandrob@pasteleros.org.ar
  Subject: Re: pd_dump server mismatch error
  In-Reply-To: <52433DB4.2040206@pasteleros.org.ar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox