Re: pd_dump server mismatch error

Looks like the real problem here is that you got a version of
postgresql installed with the OS, and then you also installed the 9.2
RPMs. Uninstall the postgres that came with the OS and/or specify the
full path to the 9.2 pg_dump.

On Wed, Sep 25, 2013 at 12:47 PM, Alejandro Brust
<alejandrob(at)pasteleros(dot)org(dot)ar> wrote:
> 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.
>
>

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand https://netllama.linux-sxs.org