Re: Need Database Backup

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