| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | <mdc(at)keko(dot)com(dot)ar> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, <mdc_marcelo(at)yahoo(dot)com> |
| Subject: | Re: help database corruption |
| Date: | 2003-05-07 19:16:27 |
| Message-ID: | 20030507121304.D29598-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 7 May 2003 mdc(at)keko(dot)com(dot)ar wrote:
> the database seems to corrupt .
> the messages are
> intent to vacumm:
>
> [postgres(at)defiant postgres]$ /usr/local/pgsql/bin/vacuumdb -a
> Vacuuming EstacionVasconiaDevelop
> ERROR: _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
> el directorio
> vacuumdb: vacuum EstacionVasconiaDevelop failed
> [postgres(at)defiant postgres]$
Hmm, is there a pg_class entry for tmpturnos? If so, is there actually a
file in the database directory with the name of its relfilenode?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mdc | 2003-05-07 19:34:14 | |
| Previous Message | Richard Huxton | 2003-05-07 19:10:49 | Re: "too clever" when creating SQL functions |