Re: help database corruption

Sorry I couldn't help you with the problem, but I have been pondering
this question for a while.

How do you get the "backend messages"? Do they get logged somewhere? How
do you turn them on?

Thanks.
Wei

mdc@keko.com.ar wrote:

>hi guys
>
> the database seems to corrupt .
> the messages are
>intent to vacumm:
>
>[postgres@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@defiant postgres]$
>
>
>backend messages
>
> XLogFlush: request 0/109118E8 is not satisfied --- flushed only to 0/108EA9D8
>ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
>el directorio
>ERROR:  _mdfd_getrelnfd: cannot open relation tmpturnos: No existe el fichero o
>el directorio
>
>
>explanation:
>
> the applicatoin create the tmpturnos with
>
>  select into tmpturnos from ....
>
> the table tmpturnos does not exist for database
> if you try
>
> create tmpturnos(...)
>  refuse with databse already exists
> if try
>  drop table tmpturnos
>  refuse with
>   database tmpturnos not exists
>
> any ideas ?
>
>  technical information
>
>   linux mandrake 8.0
>    postgres version 7.3.1
>
> best regards
> MDc
>
>
>
>
>-------------------------------------------------
>¿Todavía no navegás con Keko?
>Hacé click aquí: http://www.keko.com.ar
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
>
>