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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin