database backup with pg_dump via pgadmin3 problem

Поиск
Список
Период
Сортировка
От Miha Radej
Тема database backup with pg_dump via pgadmin3 problem
Дата
Msg-id 41387201.2020106@siix.com
обсуждение исходный текст
Ответы Re: database backup with pg_dump via pgadmin3 problem  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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





В списке pgadmin-support по дате отправления:

Предыдущее
От: "Luis F. Araya"
Дата:
Сообщение: Re: How to create Foreign Keys??
Следующее
От: blacknoz@club-internet.fr
Дата:
Сообщение: Re: cursor disappears