play 腳本
摘要: #!/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
#################################
# application: test
# DFILE : pid file
# GDIR : application webapp
# LOGDIR : logs dir
######################
NAME=et-play
TestDIR="/data/webapps/play/test"
GDIR="${TestDIR}/test"
PIDFILE="${TestDIR}/${NAME}.pid"
LOGDIR="${GDIR}/logs"
APP_USER=test
# Timeout in seconds for the shutdown of webapps
APP_SHUTDOWN=30
<
閱讀全文
posted @
2010-03-19 13:22 冰是沒有未來的，因?yàn)樗挠篮銃
編輯
pg_restore
摘要: 1.備份表中的數(shù)據(jù)
D:\Program Files\PostgreSQL-8.3.7\bin\pg_dump.exe -h *.*.*.* -p 5432 -U username -F c -v -f "D:\Program Files\PostgreSQL-8.3.7\bin\sss.backup" -t "\"public\".\"tablename\"" databasename
2. 創(chuàng)建表
CREATE TABLE tablename
(
id bigint,
createtime timestamp without time zone,
modifyname character varying(255),
modify_date timestamp without time zone,
modify_detail character varying(100000),
"name" character varying(255
閱讀全文
posted @
2010-03-11 10:02 冰是沒有未來的，因?yàn)樗挠篮銃
編輯