database backup with pg_dump via pgadmin3 problem

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: database backup with pg_dump via pgadmin3 problem
Date: 2004-09-03 13:30:41
Message-ID: 41387201.2020106@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

hi!

on windows 2000 sp4 i get to the following problem while trying to do a
database backup using pgadmin3 version 1.1.0 devel (jul 23 2004):

**********************
pg_dump.exe -h localhost -p 5432 -U delo -F p -v -f
"c:\trusted_backup.sql" explorer
pg_dump.exe: server version: 8.0.0beta1; pg_dump.exe version: 7.5devel
pg_dump.exe: aborting because of version mismatch (Use the -i option to
proceed anyway.)
pg_dump.exe: *** aborted because of error

Process returned exit code 1.
**********************

pgsql server is running on localhost, pgsql_8.0_beta1, installed with
pginstaller (http://pgfoundry.org/forum/forum.php?forum_id=119).

unfortunately i cannot try a newer version because (a) that's currently
not an option for me and (b) i can't seem to connect to www.pgadmin.org
to get a new snapshot. perhaps the http server died?

in other tries it also complained about using the -W parameter which had
a password provided (if not connected to a trusted server) but that's
already been reported.

could pgadmin3 be aware of the version of pg_dump.exe that comes with it
(or get it by executing "pg_dump -V" prior to starting the dump) and
check for the server version to provide the -i option if need be? when i
renamed pgadmin3's accompanying pg_dump.exe to something else so it
would use pg_dump.exe which comes with pgsql 8.0 beta1 (which i have in
the system path), it worked like a charm.

--
regards,
M

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Martin Sarsale 2004-09-03 14:36:09 Re: cursor disappears
Previous Message Luis F. Araya 2004-09-02 16:14:35 Re: How to create Foreign Keys??