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(at)keko(dot)com(dot)ar wrote:

>hi guys
>
> 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]$
>
>
>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(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>
>
>
>
>