Re: Backup complete

> I take backup of postgres databases with pg_dump command.
> But it didn't take backup of all sequences,views & functions in
> different databases.
>
> I want to know how we can complete backup so we can get complete data
> after restoring from a single file.
>
> I faced errors when dumping data from one system to another , if the
> same sequence doesn't exist in the other system.

Check out pg_dumpall:

http://www.postgresql.org/docs/current/interactive/app-pg-dumpall.html

Benny


--
"Open your door, or I open your wall."
                                 -- Seen on an image on fukung.net