On 27/07/2011 10:51, Adarsh Sharma wrote: > Dear all, > > I take backup of postgres databases with pg_dump command. > But it didn't take backup of all sequences,views & functions in > different databases. That's because you told it to backup only the postgres database. pg_dump only dumps a single database. If you want to backup all databases in the cluster, use pg_dumpall. You should read up on the two commands in the documentation: http://www.postgresql.org/docs/9.0/static/reference-client.html Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
