View Active SQL Queries
- Use pg_stat_activity table which will show you what activity is currently occurring on the database server
- -bash-4.1$ psql -d dbparty -c "SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity"
- pg_ctl to start/stop
Import SQL Dump into Postgres
- psql databasename < data_base_dump
No comments:
Post a Comment