Re: [ADMIN] Error: missing chunk number for toast value

2010-08-17 Thread Kevin Grittner
Kevin Kempter wrote: > # select * from comments; > ERROR: missing chunk number 0 for toast value 1274882 in > pg_toast_49234 > > > I tried this: > > # reindex table pg_toast.pg_toast_49234; > REINDEX > > > but the error still persists. > > Thoughts? Your database is corrupted. Any idea

[ADMIN] Error: missing chunk number for toast value

2010-08-17 Thread Kevin Kempter
Hi All; We're seeing this error in our 8.3.9 database: # select * from comments; ERROR: missing chunk number 0 for toast value 1274882 in pg_toast_49234 I tried this: # reindex table pg_toast.pg_toast_49234; REINDEX but the error still persists. Thoughts? -- Sent via pgsql-admin mailing

Re: [ADMIN] TopMemoryContext - Configuration Mistake?

2010-08-17 Thread Edoardo Innocenti
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelben

[ADMIN] installing Postgres 8.3 msi getting `Error` = 2888

2010-08-17 Thread emmanuel clark
hi I'm trying to install Postgres 8.3 msi. On the 3rd page ie. Initialize database cluster. when we click "Next" button, the page hangs. On the log file. the following error displays. Can anyone please tell me what to do. Action ended 17:28:56: CostFinalize. Return value 1. MSI (c) (4C:38) [17:2

Re: [ADMIN] SQL statements not printed in pgpool log

2010-08-17 Thread Gnanakumar
Any ideas/suggestions? -Original Message- From: Gnanakumar [mailto:gna...@zoniac.com] Sent: Friday, August 13, 2010 6:54 PM To: pgsql-admin@postgresql.org Subject: SQL statements not printed in pgpool log Hi, Our production server is running PostgreSQL v8.2.3 on Red Hat Enterprise Linux

Re: [ADMIN] TopMemoryContext - Configuration Mistake?

2010-08-17 Thread Tom Lane
Edoardo Innocenti writes: > Query Plan: > "HashAggregate (cost=4910.06..4910.19 rows=1 width=659)" Hm ... the planner seems to think that this is a small query that isn't going to take long, which is a bit at odds with the fact that you're running out of memory. I suspect that these rowcount est

Re: [ADMIN] TopMemoryContext - Configuration Mistake?

2010-08-17 Thread Edoardo Innocenti
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelben