Re: pg_dump dependencies

From: Eric E <whalesuit(at)bonbon(dot)net>
To: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump dependencies
Date: 2005-01-06 18:26:47
Message-ID: 41DD82E7.1010602@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Michael,
Well, I dumped the database from two different versions of Postgres
(on different machines), using both pg_dump 8.0.0beta2 and pg_dump 7.4.2
(which correspond to the respective server versions). I only restored
on the 8.0.0beta machine, though. Would that make a difference?
I will also poke around in my database to see if perhaps something else
is blocking a proper dump.

Thanks,

EE

Michael Fuhr wrote:

>On Thu, Jan 06, 2005 at 12:10:26PM -0500, Eric E wrote:
>
>
>
>> I have a question about pg_dump. I am backing up a database using
>>pg_dump in text mode, which works perfectly for me, with one exception.
>>I have a view vwDependentView which references another view,
>>vwIndependentView. However, when I feed my dump script to psql, it is
>>attempting to make vwDependentView first and failing.
>>
>>
>
>What version of PostgreSQL are you using? pg_dump tends to improve
>with each release; I couldn't duplicate your problem in 8.0.0rc3
>or 7.4.6.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-06 18:39:16 Re: Query, view join question.
Previous Message Joshua D. Drake 2005-01-06 18:25:10 Re: Question about varchar and text