On 27/07/2011 11:31, Adarsh Sharma wrote: > Raymond O'Donnell wrote: >> 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. >> >> > Thanks Raymond, I know that but did it take the backups of procedures & > views too. > > > Adarsh Hi Adarsh, Yes, pg_dump backs up everything - schema and data. If you need to convince yourself, use the -s option to dump just the schema and examine the output. 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
