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
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?? |