pgadmin 1.8.4 gives error while backing up
Hello
I am using pgplus 8.3 in linux(centos) and trying to backup the database
from windows machine using pgadmin 1.8.4 but i get an error while backing
up. It says version mismatched and use -i option if I want to proceed.
If anybody knows what going on please email me or reply on this post.
Thanks in advance.
--
View this message in context: http://www.nabble.com/pgadmin-1.8.4-gives-error-while-backing-up-tp23090683p23090683.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Thu, 16 Apr 2009 21:05:41 -0700 (PDT), kabindra <kabindra@ttwin.com>
wrote:
Hello
I am using pgplus 8.3 in linux(centos) and trying to backup the
database
from windows machine using pgadmin 1.8.4 but i get an error while backing
up. It says version mismatched and use -i option if I want to proceed.
If anybody knows what going on please email me or reply on this post.
Thanks in advance.
You have a version of pg_dump that is installed that isn't the same as the
server.
Joshua D. Drake
--
View this message in context:
http://www.nabble.com/pgadmin-1.8.4-gives-error-while-backing-up-tp23090683p23090683.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
I think this is a bug in the version.
If linux and windows pg_dump are not the same and what can be I do to backup
the database.
Thanks
Joshua D. Drake wrote:
On Thu, 16 Apr 2009 21:05:41 -0700 (PDT), kabindra <kabindra@ttwin.com>
wrote:Hello
I am using pgplus 8.3 in linux(centos) and trying to backup thedatabase
from windows machine using pgadmin 1.8.4 but i get an error while backing
up. It says version mismatched and use -i option if I want to proceed.
If anybody knows what going on please email me or reply on this post.
Thanks in advance.You have a version of pg_dump that is installed that isn't the same as the
server.Joshua D. Drake
--
View this message in context:http://www.nabble.com/pgadmin-1.8.4-gives-error-while-backing-up-tp23090683p23090683.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
View this message in context: http://www.nabble.com/pgadmin-1.8.4-gives-error-while-backing-up-tp23090683p23091755.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
I think this is a bug in the version.
If linux and windows pg_dump are not the same and what can be I do to backup
the database.
Hi,
In next version(1.10), pgAdmin add a new option to ignore version mismatch check.
Beta2 is here:
http://www.postgresql.org/ftp/pgadmin3/release/v1.10.0-beta2/
-----------------------------------------------
Quan Zongliang
quanzongliang@gmail.com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn
Quan Zongliang <quanzongliang@gmail.com> writes:
In next version(1.10), pgAdmin add a new option to ignore version mismatch check.
This is a really bad idea, as it opens you up to the possibility of
silently wrong dumps.
regards, tom lane
On Fri, Apr 17, 2009 at 3:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Quan Zongliang <quanzongliang@gmail.com> writes:
In next version(1.10), pgAdmin add a new option to ignore version mismatch check.
This is a really bad idea, as it opens you up to the possibility of
silently wrong dumps.
It's using the --ignore-version flag and is a non-default option. How
is that any different from pg_dump itself?
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
Dave Page <dpage@pgadmin.org> writes:
On Fri, Apr 17, 2009 at 3:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Quan Zongliang <quanzongliang@gmail.com> writes:
In next version(1.10), pgAdmin add a new option to ignore version mismatch check.
This is a really bad idea, as it opens you up to the possibility of
silently wrong dumps.
It's using the --ignore-version flag and is a non-default option. How
is that any different from pg_dump itself?
As of 8.4, pg_dump ignores --ignore-version altogether, because of the
way it's been rampantly abused. There was never any intention that that
should be a flag to use routinely; it was meant to get you out of
emergency situations where you did not have the right pg_dump available
and were willing to take risks.
regards, tom lane
On Fri, Apr 17, 2009 at 4:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
As of 8.4, pg_dump ignores --ignore-version altogether, because of the
way it's been rampantly abused. There was never any intention that that
should be a flag to use routinely; it was meant to get you out of
emergency situations where you did not have the right pg_dump available
and were willing to take risks.
Right - so it is no different from pg_dump then!
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com