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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx LlamaLand https://netllama.linux-sxs.org -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
