| From: | Harshad Adalkonda <adalkondaharshad(at)gmail(dot)com> |
|---|---|
| To: | shyamkant(dot)dhamke(at)wipro(dot)com |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Command to take only schema backup |
| Date: | 2014-12-18 07:25:37 |
| Message-ID: | CANnQH_gh=RWTGHhHcgEG1LSMSXL7Y5r131n1+RP0gAbBEsAn5w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Dec 18, 2014 at 11:08 AM, <shyamkant(dot)dhamke(at)wipro(dot)com> wrote:
>
> Hi,
>
>
>
> Please let me know the command/option to take the backup of schema using
> PGadmin.
>
>
>
> Regards
>
> Shyamkant
>
Hi Shyamkant,
In pgAdmin schema backup option is disabled for custom, tar, directory
format
so you need to select plain text format to take schema backup.
This backup only takes schema dump no data will be there.
Example:
Right click on *Database* select *Backup* In file option *Format* as *Plain*
& in *dump option 1* check *only schema *and click on *Backup.*
*---*
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harshad Adalkonda | 2014-12-18 13:04:45 | Re: Logfile purge |
| Previous Message | Scott Marlowe | 2014-12-18 06:24:08 | Re: Logfile purge |