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.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to