Backup SQL Format using PgAdmin: 1. Right click in database 2. Set Format to “Plain” Restore SQL Format (Plain) in Windows 1. cmd 2. type : psql -h host -U user -p port dbname < file (User use U capslock) example : C:\Program Files\PostgreSQL\9.3\bin>psql -h localhost -U postgres -p 5443 fantasi < c:/fantasy_server.backup Restore SQL Format … Continue reading
You have to provide the ‘Log on as a batch job’ privilege: 1. Go to control panel/administrative tools a. click on “local security policy” b. click on “local policies” c. click on “user rights assignments” d. double click on “log on as a batch job” e. click on “add” and add the user that was … Continue reading