| From: | Eduardo Morras <emorrasg(at)yahoo(dot)es> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_Restore |
| Date: | 2013-01-30 11:39:15 |
| Message-ID: | 20130130123915.1b023882299024d47c0fe4d8@yahoo.es |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
On Mon, 21 Jan 2013 22:16:00 +0530
bhanu udaya <udayabhanu1984(at)hotmail(dot)com> wrote:
> Hello All,
> Can we achieve this template or pg_Restore in less than 20 minutes time. Any more considerations. Kindly reply. Thanks and RegardsRadha Krishna From: udayabhanu1984(at)hotmail(dot)com
Perhaps you can use the ntfs snapshot feature.
a) Create the db with the data you want
b) Shutdown PostgreSql completly
c) Go to data folder, properties, make a recover point
d) Start PostgreSql
f) Work with it
g) Stop PostgreSql
h) Go to data folder, properties, recover the previous version
i) Go to d)
Don't know exactly the name of the ntfs property, if i remember well it's recover point, but haven't used Windows for a while.
Perhaps other folders should be set to recover.
It's easy with this "feature" shoot your own feet (yes, in plural). If something wrong happens recover from the dump.
HTH
| From | Date | Subject | |
|---|---|---|---|
| Next Message | C. Bensend | 2013-01-30 13:12:26 | Re: pg_Restore |
| Previous Message | Dave Page | 2013-01-24 10:07:30 | Re: pgAdmin on MacOs: Cmd-s types 's' if there is nothing to save |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2013-01-30 12:58:41 | Re: Optimizing select count query which often takes over 10 seconds |
| Previous Message | hamann.w | 2013-01-30 11:33:17 | optimize query? |