On Sep 25, 11:02 am, alvhe...@xxxxxxxxxxxxxxxxx (Alvaro Herrera) wrote: > Dan99 escribió: > > > > > Hi, > > > I found out this morning that I cannot get pg_dump to work at all on > > my database. It refuses to create a dump and instead just freezes. > > When using the verbose option (-v) i get the following output and then > > it stops (it at one point ran for days on end before i even noticed) > > > pg_dump: saving encoding > > pg_dump: saving database definition > > pg_dump: reading schemas > > pg_dump: reading user-defined types > > pg_dump: reading user-defined functions > > pg_dump: reading user-defined aggregate functions > > pg_dump: reading user-defined operators > > pg_dump: reading user-defined operator classes > > pg_dump: reading user-defined tables > > > I think this problem is somehow related to a VIEW problem that I > > have. I created a VIEW of semi-large tables, which did not come back > > with any errors. However, when I go to view it, it never finishes > > loading. Also, I cannot drop this view as this as well never > > finishes. > > Perhaps somebody has a lock on a table or view. Try > > select relation::regclass, database, transaction, pid, mode, granted > from pg_locks; > > Do you see anything related to the view you created? > > -- > Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J > "This is a foot just waiting to be shot" (Andrew Dunstan) > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match I think I fixed my problem. I waited until the weekend when practically nobody was going to be using my site and then just restarted the server. After that I could delete the view and pg_dump worked. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
