On Tue, Jan 11, 2011 at 2:00 PM, Bill Moran <wmo...@collaborativefusion.com> wrote: > In response to Victor Hugo dos Santos <listas....@gmail.com>:
Hello Bill, [...] > Here's my recommendation: > 0) Make sure you're getting reliable backups of the database. Try > restoring one to another system. yes.. worked the last week > 1) make sure you're running the latest version of PostgreSQL on the > major branch you're on. i.e. if you're running 8.2.11, upgrade > to 8.2.13 yes.. this the last stable version (8.4.6-0ubuntu10.04) in my SO (ubuntu 10.04) > 2) If the error is happening frequently, restart PostgreSQL and see > if it goes away. There have been some issues with name -> oid > caching when relations are dropped and recreated with the same > name while another connection is caching that mapping. the error, occurred two times (yesterday and today) and I don't restart postgresql eve. Yes, I read one or two documents about the client cache.. But, http://javadave.blogspot.com/2005/06/could-not-open-relation-in-postgresql.html http://groups.google.com/group/pgsql.general/browse_thread/thread/23800ef120ba75b5/d28c63c32d063294%23d28c63c32d063294?pli=1 But, the bacula database only is used by bacula !!! so, we don't have concurrents access to database. > 3) If the problem is still happening. Get a backup, delete your > pg_data directory, re-init the database and restore from > backup. until this moment is not critical (I believe), because the others backups work fine. but, if the problem persist, maybe will be more complicate. :-( thanks -- -- Victor Hugo dos Santos Linux Counter #224399 ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
