Skip site navigation (1) Skip section navigation (2)

pg_dump and restore - views

From: "Wang, Marcus" <Marcus(dot)Wang(at)team(dot)telstra(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: pg_dump and restore - views
Date: 2006-04-20 02:09:44
Message-ID: A0615F86CE3CBB47815DAB28CC6C651BFBF0AC@WSMSG2151V.srv.dir.telstra.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,
We've got postgresql 7.4 and a few views. I'm using pg_dump to backup
the database and everything is ok. Recently, we added 5 new views - but
when I restore the dump with psql, out of 5 new views, only 3 is
recreated, 2 are missing. But when I check the dump file - those views
are in the dump, but somehow they are not recreated. While the database
is being restored - I've got error messages for relattioni "view_name"
does not exist. 
I even tried with pg_dumpall and still got the same result - any ideas
to troubleshoot? 

Thanks


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-04-20 02:39:36
Subject: Re: pg_dump and restore - views
Previous:From: Michael Talbot-WilsonDate: 2006-04-19 18:49:08
Subject: Re: Defining the same relation in another database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group