Re: Need Database Backup - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Need Database Backup
Date
Msg-id 55E3115A.5010806@aklaver.com
Whole thread Raw
In response to Re: Need Database Backup  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Need Database Backup
List 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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Need Database Backup
Next
From: Melvin Davidson
Date:
Subject: Re: Need Database Backup