Skip site navigation (1) Skip section navigation (2)

Feature request: pgdump and version number / -i option

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: pgAdmin III support <pgadmin-support(at)postgresql(dot)org>
Subject: Feature request: pgdump and version number / -i option
Date: 2009-01-08 16:05:46
Message-ID: 156194.76387.qm@web34401.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,

I am running pgAdmin III 8.1.4 on WinXP on a PG server 8.3.3.

I am trying to backup a single table. When doing right-click on the table and "backup" command, it will fail because pgdump considers there's a mismatch between the server version (8.3.3) and the pgdump version (8.3) version.
I get the following message:
C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h my_server -p 5432 -U postgres -F p -v -f "C:\Projects\table.sql" -t "\"public\".\"my_table\"" my_db
pg_dump: server version: 8.3.3; pg_dump version: 8.3.0
pg_dump: aborting because of version mismatch  (Use the -i option to proceed anyway.)
pg_dump: *** aborted because of error

I realise this is because pgdump is a bit too specific about the version number: for now, the solution is to run the command from the command line with the extra option -i.

But in a future version, could we have an extra option in the backup popup to use the -i option ?


 Cheers,
L(at)u
The Computing Froggy



      

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2009-01-09 21:39:20
Subject: Re: Feature request: pgdump and version number / -i option
Previous:From: Dave PageDate: 2009-01-08 15:00:49
Subject: Re: Re : Re : Dependence between jobs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group