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