View Single Post

   
  #9 (permalink)  
Old 04-09-2008, 12:23 PM
Tom Lane
 
Posts: n/a
Default Re: Superuser lost access to particular database

Francisco Reyes <lists@stringsutils.com> writes:
> Tom Lane writes:
>> SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
>> so apparently something is fishy about the dependency data. Can you
>> execute this query by hand and get results?


> Nothing happens when I try to run the query.


So pg_dump seems off the hook. Can you run the query, attach to the
backend with gdb, and see what it's doing?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote