> [ADMIN] [PERFORM] First rule of mailing lists: DO NOT CROSS POST. Please stick to one mailing list. I've replied on pgsql-general where your post started out. Please do not reply to the posts on -admin or -perform. My reply follows below. On 25/07/11 15:11, Adarsh Sharma wrote: > I go through the link, so it is impossible to get the data back. > I have following files in my pg_xlog directory : > > 000000010000000700000091 > 000000010000000700000092 > 000000010000000700000093 > 000000010000000700000094 > 000000010000000700000095 > 000000010000000700000096 > 000000010000000700000097 > 000000010000000700000098 > > I think I issued the drop database command 1 month ago. .... and you're asking NOW? Even though "it's urgent"? The first rule of data recovery: As soon as you realize something is wrong, make a copy of everything immediately. Then stop using it. > > I think I issued the drop database command 1 month ago. > From the manual, I understand that my segment files are recycled to newer ones : Correct. Any chance you ever had of recovering your data is almost certainly gone because you restored into it - probably immediately destroying your deleted data - then kept on using the database for another month. If you're willing to spend a lot of money you might be able to recover some of it using hard-drive level overwritten data forensics, but I rather doubt it. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
