导出:
/usr/local/pgsql/bin/pg_dump -D -h localhost -U postgres leku > /opt/leku.sql
/usr/local/pgsql/bin/pg_dumpall -D -h localhost -U postgres > all.sql
导入:
createdb -U user database
psql -U user -d database -f dump.sql
不积跬步,无以至千里!
导出:
/usr/local/pgsql/bin/pg_dump -D -h localhost -U postgres leku > /opt/leku.sql
/usr/local/pgsql/bin/pg_dumpall -D -h localhost -U postgres > all.sql
导入:
createdb -U user database
psql -U user -d database -f dump.sql