Shulou(Shulou.com)06/01 Report--

Postgresql.cmd

The @ echo offtitle PostgreSQLrem variable sets the if not defined PGSQL set PGSQL=%~dp0if not defined PGLOCALDIR set PGLOCALDIR=%PGSQL%shareif not defined PGDATABASE set PGDATABASE=postgresif not defined PGPORT set PGPORT=5432if not defined PGUSER set PGUSER=postgresrem data directory, sets the if not defined PGDATA set PGDATA=%PGSQL%\ Data\ datarem log as needed, and sets if not defined PGLOG set PGLOG=%PGSQL%\ Data\ log.txtrem to initialize a new database if not exist "% PGDATA%" (echo.) for the first time. Echo is initializing the database for the first time Please wait... "% PGSQL%\ bin\ initdb"-U% PGUSER%-A trust-E utf8-- locale=C > nul) rem starts postgres server echo. "% PGSQL%\ bin\ pg_ctl"-D "% PGDATA%"-l "% PGLOG%"-w startclsecho.echo type\ Q to exit and shut down server echo. "% PGSQL%\ bin\ psql.exe"-- port=%PGPORT%-- dbname= "% PGDATABASE%" -- username= "% PGUSER%" echo. "% PGSQL%\ bin\ pg_ctl"-D "% PGDATA%" stop

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.