From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Backup complete |
Date: | 2011-07-27 10:38:20 |
Message-ID: | 4E2FEA9C.6070407@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Boris Kolpackov | 2011-07-27 10:48:16 | [ANN] ODB C++ ORM adds support for PostgreSQL |
Previous Message | Adarsh Sharma | 2011-07-27 10:31:41 | Re: Backup complete |