Re: [GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread serafin segador
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 al

Re: [GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread Dave Page
On Thu, Jul 9, 2009 at 11:06 AM, serafin segador 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

Re: [GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread serafin segador
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 no

Re: [GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread Frank Heikens
What version of pg_dump and pgAdmin are you using? In PostgreSQL version 8.3 it's reltriggers, in version 8.4 it's relhastriggers. Just run the next query to see the difference: SELECT * FROM pg_class; Using pgAdmin 1.10, I don't have any problemes with 8.3 nor 8.4 Regards, Frank Op 9 jul

[GENERAL] pg_dump PostgreSQL 8.4

2009-07-09 Thread serafin g.segador
hi!. i am trying to migrate my database from 8.3.7 to 8.4 (both versions running on the same server windows 2003, hp ml350 quad core xeon) using pg_dump and restore using pgAdmin III R 1.10.0, this i was able to do. but i cannot seem to make a backup on 8.4. i keep getting the following error me