Re: pg_dump question

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Carol Walter" <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump question
Date: 2007-12-07 20:36:39
Message-ID: dcc563d10712071236v3b2187a4ice02c0725cad31b8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Dec 7, 2007 2:18 PM, Carol Walter <walterc(at)indiana(dot)edu> wrote:
> Hello-
>
> I'm trying to do an upgrade of version 8.1 to 8.2.3. The restore is
> failing because of some code that is in some views. If I dump the
> just the schema and then dump just the data, will the views be included?

Well, that really kinda depends.

Are you pg_dumping with 8.2's pg_dump? If not try that.

What exact error messages are you getting?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Listaccount 2007-12-10 15:26:12 Dangerous hint in the PostgreSQL manual
Previous Message Carol Walter 2007-12-07 20:18:05 pg_dump question