As I am not someone with a lot of experience.... (depending on the size of the 'dumpall') I would create a new database to suck up the 'all' then pg_dump the table I really cared about.
Obviously, if the dump_all is a terabyte database this method is inconvenient.... (to say the least). However it will work. Ted --- Lucas Lain <[EMAIL PROTECTED]> wrote: > Hi everybody ... i need to restore only one database > from a pg_dumpall backup > file... how can i do it? > > Thanks a lot ! > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings