postgresql

修改序列号

 select setval('$seqname ', max(pf_052_id)) from $table;

SELECT pg_terminate_backend(pid) 
FROM pg_stat_activity 
WHERE pg_stat_activity.datname = '$dbname' 
AND pid <> pg_backend_pid(); 

select * from pg_user_mappings; 

select * from pg_foreign_server; 

select * from pg_extension; 
select * from pg_foreign_data_wrapper; 
select * from pg_foreign_table; 

启动 /usr/local/postgresql-9.3.4/bin/postmaster -D /dbbata/data

createdb $name --encoding=UTF8 --owner=postgres --template=template0 -Upostgres  -p 5433

pg_dump -U postgres -d $dbname> /root/pg_dump/$.bak 

psql -U postgres -d $dbname< /tmp//.bak