thank you all for your assistance. i tried not to be adventurous tweaking
the configuration of a production system except for system upgrade which
has not failed on me before. burned my fingers once. i need to visit the
documentation and study more the admin side of the system.
thanks all.
raffy segador
On Thu, 09 Jul 2009 18:27:35 +0800, Dave Page <dpage@xxxxxxxxxxx> wrote:
On Thu, Jul 9, 2009 at 11:06 AM, serafin segador<rsegador@xxxxxxxxxxxxx>
wrote:
i found where the error is. thanks for the tip.
i have versions 8.3.7 and 8.4 of PostgreSQL running on the same server,
as
well as versions 1.8 and 1.10 of pgAdmin. although i run the backup
routine
for pg8.4 from pgAdmin 1.10, the pdAdmin uses
PostgreSQL\8.3\bin\pg_dump as
default. i now run the backup routine from the command line utility
pointing to the correct version.
Check the PG bin path option and File -> Options.
It also sounds like you disabled the version match check on that
dialogue, otherwise pg_dump 8.3 should have complained about be used
with 8.4.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general