Re: pd_dump server mismatch error

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