Re: Backup complete

[Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>]

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