On Fri, 2 Nov 2007, Heikki Linnakangas wrote: > Date: Fri, 02 Nov 2007 18:11:14 +0000 > From: Heikki Linnakangas <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] should I worry? > > [EMAIL PROTECTED] wrote: > > 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: > > Could you be a bit more specific? The database you tried to restore to > was empty, right? Can you post the dump file (schema-only)? Yes it was empty, Sorry, I can't post the schema, it belongs to one of my customer...
All triggers in the schema are named. So I assume they are triggers for foreign keys. It's hard to tell if all foreign keys have been created after restore is complete... > > > I'm also playing with checkpoint logging. What should I see? few buffers > > dump, little write time, little sync time? > > Depends on how much activity there is. If there's a lot of dirty > buffers, a lot of written buffers and long write time is perfectly normal. > > Thanks for the explanation. 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: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
