| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, muralihw03(at)rediffmail(dot)com, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Need Database Backup |
| Date: | 2015-08-30 14:21:14 |
| Message-ID: | 55E3115A.5010806@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/30/2015 07:13 AM, Melvin Davidson wrote:
> You need to recreate the database to reload the data into so
>
> from the windows command line:
> C:\PostgresDB\bin\createdb.exe -U postgres <your db name>;
That assumes Postgres is running, which at this point seems not to be
the case or at least is unproven.
>
> Then to restore the data from the sql backup
> C:\PostgresDB\bin\pg_restore.exe -U postgres <the sql backup file>
This will not work if the *.sql is a plain text file.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2015-08-30 14:27:04 | Re: Need Database Backup |
| Previous Message | Melvin Davidson | 2015-08-30 14:13:53 | Re: Need Database Backup |