From: | Dan99 <power919(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG_DUMP not working |
Date: | 2007-09-25 16:01:18 |
Message-ID: | 1190736078.048948.205830@o80g2000hse.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sep 25, 11:02 am, alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (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.
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2007-09-25 16:34:02 | Re: lowering impact of checkpoints |
Previous Message | Dan99 | 2007-09-25 15:59:55 | Re: PG_DUMP not working |