Обсуждение: 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 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 > > -- > 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