| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Ramesh T <rameshparnanditech(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgdump |
| Date: | 2015-01-30 14:46:06 |
| Message-ID: | 54CB992E.2050802@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 01/30/2015 01:16 AM, Ramesh T wrote:
> when i try to dump the database windows based pgadmin 3 it returns
> message like
>
> pg_dump: server version: 9.3.4; pg_dump version: 9.1.3
> pg_dump: aborting because of server version mismatch
>
> any help..?
Use a 9.3+ version of pg_dump. A version of pg_dump is backwards
compatible so it can work on its version to Postgres versions going back
to 7.2, I believe. That does not work the other way around as you found
above. pgAdmin3 is picking up a 9.1.3 version of pg_dump and trying to
use it to dump a 9.3 version of Postgres. So you will need to find the
9.3 version of pg_dump and use that.
>
> Advanced thanks,
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sterpu Victor | 2015-01-30 14:46:50 | Re: Subselect with no records results in final empty set |
| Previous Message | Holger.Friedrich-Fa-Trivadis | 2015-01-30 11:40:29 | Re: Building extensions against OpenSCG RPM packages |