| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, 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 15:47:02 |
| Message-ID: | 54CBA776.3090206@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 30/01/2015 14:46, Adrian Klaver wrote:
> 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.
To add to what Adrian says, you tell pgAdmin which pg_dump (and other
Postgres client programs) to use under File -> Options -> Browser ->
Binary paths, in the "PG bin path" field (this is on PgAdmin III 1.20).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John McKown | 2015-01-30 15:56:21 | Nice article on PostgreSQL HSTORE and JSONB |
| Previous Message | Jeff Amiel | 2015-01-30 15:30:31 | Catalog Bloat |