| From: | Thara Vadakkeveedu <tharagv(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pd_dump server mismatch error |
| Date: | 2013-09-25 18:55:05 |
| Message-ID: | 1380135305.67283.YahooMailNeo@web125005.mail.ne1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alejandro Brust | 2013-09-25 19:47:00 | Re: pd_dump server mismatch error |
| Previous Message | Thara Vadakkeveedu | 2013-09-25 01:30:27 | Re: connecting to the database from pgadmin client |