Advertisement
joaofabioma

inidb PostgreSQL

Dec 15th, 2022 (edited)
1,169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Batch 1.01 KB | Source Code | 0 0
  1. @echo off
  2. cls
  3. set PATHROOT=%~dp0
  4. set PATHBIN=%PATHROOT%bin\\
  5. set PATHDATA=%PATHROOT%data\master\\
  6.  
  7. cd bin
  8. REM rm -f -r -d "%PATHDATA%"  REM para recriar tudo de novo, remover comentario
  9. del /f /q /s "%PATHROOT%start.cmd"
  10. del /f /q /s "%PATHROOT%stop.cmd"
  11. del /f /q /s "%PATHROOT%restart.cmd"
  12. echo postgres>"%PATHROOT%arquivo"
  13. %PATHBIN%initdb -A md5 -D "%PATHDATA%" -E "UTF-8" -g --locale="Portuguese, Brazil" --pwfile="%PATHROOT%arquivo" -U postgres
  14. del /f /q /s "%PATHROOT%arquivo"
  15. takeown /F "%PATHDATA%*.*"
  16. icacls "%PATHDATA%" /grant "Todos":F /T /C /Q
  17. icacls "%PATHDATA%" /grant Administradores:F /T /C /Q
  18. cd ..
  19. echo @echo off>"%PATHROOT%start.cmd"
  20. echo @echo off>"%PATHROOT%stop.cmd"
  21. echo @echo off>"%PATHROOT%restart.cmd"
  22. echo "%PATHBIN%pg_ctl" start -D "%PATHDATA%" -s -w>>"%PATHROOT%start.cmd"
  23. echo "%PATHBIN%pg_ctl" stop -D "%PATHDATA%" -m fast>>"%PATHROOT%stop.cmd"
  24. echo "%PATHBIN%pg_ctl" restart -D "%PATHDATA%">>"%PATHROOT%restart.cmd"
  25. echo exit>>"%PATHROOT%start.cmd"
  26.  
  27. start %PATHROOT%start.cmd
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement