Re: debug issue on postgresql

MARIOTTI, Alessandro (Alessandro) a écrit :
> Well I could shortly describe what's happen on these machines ;
>
> On May 7 2008 at 23:25 an operator performed :
>
> _a configuration change ;
>
> _add a new user on a table named MVNO;
>

None of these could have caused a corruption.

> Customer told us that for “new user” operator add comma “,” symbol.
>
> This is something new for their provisioning procedure (it’s seems they
> never test it )thus as soon as they propagate this updated DB over
> machines of live net these started to discard all the requests and no
> more user was able to work or work properly .
>

> Now they asking us what’s happen so this is the reason why I’m writing
> here .
>

You'll need more info if you want to find out what happened.

> Unfortunately I tried to verify the backup db but the one interesting
> for us is empty :
>
> ls -l 200805*
>
> -rw-r--r-- 1 root root 842840 mag 1 04:03
> 20080501-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842840 mag 2 04:03
> 20080502-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842840 mag 3 04:03
> 20080503-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842840 mag 4 04:03
> 20080504-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842540 mag 5 04:03
> 20080505-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842613 mag 6 04:03
> 20080506-0403-cfg_xxxxxxx.sql
>
> -rw-r--r-- 1 root root 842613 mag 7 04:03
> 20080507-0403-cfg_xxxxxxx.sql
>
> *-rw-r--r-- 1 root root 0 mag 8 04:03
> 20080508-0403-cfg_xxxxxxx.sql*
>
> -rw-r--r-- 1 root root 843960 mag 9 04:03
> 20080509-0403-cfg_xxxxxxx.sql
>

You don't a SQL backup, these won't help you. You need a backup of the
database after the corruption.

> I‘ll try to find it but but even if I can’t provide this back-up for
> company policies reason , could I ask you some feed-back to get
> suggestion to look for on this back-up file?
>

Nope. You didn't give us enough information to at least get started.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com