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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 8 Jan 2009 08:05:46 -0800 (PST)
  • Message-id: <156194.76387.qm@web34401.mail.mud.yahoo.com> <text/plain>

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



      


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group