Re: trouble with db-restore

I am surprised and have never heard of this happening.

> Hi,
>
> Yesterday our system-harddisk crashed and i had to restore
> the postgres databases from the backup-tape.
>
> i simply use pg_dumpall with no params for dumping the
> data, but when i used psql for restoring the data,
> every view was created as a table and was filled up
> with the data which the view had been delivered at
> the time of the backup.
>
> it was no problem, because actually we dont use much
> views so i could restored it by hand. but the
> question is, is it possible to backup views, and
> the bigger question for me is, what additional surprises do
> i have to expect from pg_dumpall?
>
> --
> SC-Networks                             www: www.SC-Networks.de
> Web Design, Netzwerke,
> 3D Animation und Multimedia
> Heiko Irrgang                           Tel.: 08856/9392-00
> Im Thal 2                               Fax:  08856/9392-01
>
> 82377 Penzberg                          Mail: Irrgang@SC-Networks.de
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026