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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
