Java代码
- ./postgres -D /data/postgresql/ >> logfile 2>&1 &
- sed -i "s/#port = 5432/port = 11780/g" pg_data/postgresql.conf
- netstat -antlp |grep 5432/11780
- kill -15/9 pid
- kill -INT 'head -i /home/sequoiadb/pgsql/pg_data/postgresqlmaster.pid'
- http://www.php100.com/manual/PostgreSQL8/
http://www.php100.com/manual/PostgreSQL8/
Sql代码
- /Volumes/pgAdmin3/pgAdmin3.app/Contents/SharedSupport/pg_dump --host 121.42. *.*--port 5432 --username "postgres" --no-password --format custom --verbose --file "schemaName" "dbName"
Java代码
- /Volumes/pgAdmin3/pgAdmin3.app/Contents/SharedSupport/pg_restore --host ip --port 11780 --username "sdbadmin" --dbname "foo" --no-password --schema lfchat --verbose "/Users/jade/Documents/lfchat_of_postgresql_5432"
Java代码
- postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$ ./pg_dump -n lfchat -d postgres -hlocalhost -p5432 -w -f ./postgresql.dump
- postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$ ls
- clusterdb createuser dropuser logfile pg_basebackup pg_controldata pg_dumpall pg_resetxlog pg_test_fsync pg_xlogdump postmaster vacuumdb
- createdb dropdb ecpg oid2name pgbench pg_ctl pg_isready pg_restore pg_test_timing postgres psql vacuumlo
- createlang droplang initdb pg_archivecleanup pg_config pg_dump pg_receivexlog pg_standby pg_upgrade postgresql.dump reindexdb
- postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$
