- @ECHO OFF
- @setlocal enableextensions
- @cd /d "%~dp0"
- SET PGPASSWORD=123456
- SET PGPATH=D:\developtools\PostgreSQL\16.2-1\bin\
- SET SVPATH=D:\
- SET PRJDB=kaizhou
- SET DBUSR=postgres
- SET DBDUMP=D:\cqkz_2024-04-19_1748.sql
- %PGPATH%psql -h 127.0.0.1 -p 5432 -U postgres -d %PRJDB% < %DBDUMP%
- #%PGPATH%psql -h 172.168.80.134 -p 5432 -U postgres -d %PRJDB% < %DBDUMP%
- pause
|