should I worry?

From: ohp(at)pyrenet(dot)fr
To: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: should I worry?
Date: 2007-11-02 17:26:35
Message-ID: Pine.UW2.4.53.0711021813510.20356@sun.pyrenet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

I'm now testing 8.3beta2 on a relatively big (10G) database.
I've tried with pg_dymp -Fc/pg_restore and pg_dump/pgsql and get those
errors:

ERROR: trigger "<unnamed>" for relation "objets" already exists
ERROR: trigger "<unnamed>" for relation "perso_objets" already exists
ERROR: trigger "<unnamed>" for relation "objets" already exists
ERROR: trigger "<unnamed>" for relation "objets" already exists
ERROR: trigger "<unnamed>" for relation "messages" already exists
ERROR: trigger "<unnamed>" for relation "messages_dest" already exists
ERROR: trigger "<unnamed>" for relation "messages" already exists
ERROR: trigger "<unnamed>" for relation "messages" already exists
ERROR: trigger "<unnamed>" for relation "messages_exp" already exists
ERROR: trigger "<unnamed>" for relation "positions" already exists
ERROR: trigger "<unnamed>" for relation "positions" already exists
ERROR: trigger "<unnamed>" for relation "positions" already exists
ERROR: trigger "<unnamed>" for relation "positions" already exists
ERROR: trigger "<unnamed>" for relation "positions" already exists
ERROR: trigger "<unnamed>" for relation "type_evt" already exists
ERROR: trigger "<unnamed>" for relation "objet_generique" already exists
ERROR: trigger "<unnamed>" for relation "objet_generique" already exists
ERROR: trigger "<unnamed>" for relation "objets_caracs" already exists
ERROR: trigger "<unnamed>" for relation "competences" already exists
ERROR: trigger "<unnamed>" for relation "race_comp" already exists

I don't remember having those with beta1 and don't know what to look at.

I've tried both 8.2.5 and 8.3beta2 pg_dump.

I'm also playing with checkpoint logging. What should I see? few buffers
dump, little write time, little sync time?

Unrelated, who should I contact to get my password of jaguar in
build_farm, this animal has been set up to test with
-DCLOBBER_CACHE_ALWAYS and I never received the password.

Maybe pgfbuildfarm.org web should include a button to resend account to
the owner.

Just my 0.01$...

Best regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-02 17:29:02 Re: minimal update
Previous Message Pavel Stehule 2007-11-02 17:24:53 Re: V0.1 patch for TODO Item: SQL-language reference parameters by name.