> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
