Postgresql - unders/mywiki GitHub Wiki

• (awesome-postgres)[https://github.com/dhamaniasad/awesome-postgres]

Articles

• postgresql-magic
• in-postgresql-as-in-life-dont-wait-too-long-to-commit
• 10-How-does-CLUSTER-ON-improve-index-performance.html
• 10-beginner-postgresql-tasks-you-should-know
• sql-vs-nosql-ko-postgres-vs-mongo
• postgresguide
• more-out-of-psql
• postgresql-awesomeness-for-rails-developers

Tutorials

• Thoughtbots Postgres links
• postgresql-command-line-cheat-sheet
• postgresql-awesomeness-for-rails-developers
• smarter-synchronization-of-your-postgresql-development-and-production-dbs
• dear-postgresql-where-are-my-logs.html
• fast postgresql-pagination
• discovering-the-computer-science-behind-postgres-indexes
• configuring - optimizing-your-psql.html

Heroku Postgress articles

• heroku-postgres

HStore

• how-to-persist-hashes-in-rails-applications-with-postgresql

Migrations

• how-to-create-postgres-indexes-concurrently-in rails

Connections (Pooling)

• connection_limit_guidance

Transactions

• PostgreSQL's transaction system is a three-layer system

Charts

• pgcharts
• pghero

Caching

• caching-expensive-queries-with-materialized-views-in-postgresql

Amazon

• rds-postgres-read-replicas
• 3-2-1-backup-of-postgres-on-aws-to-s3-and-offsite-server

Client

• pgweb
• pgcommander

Postgres documentation

• auth-pg-hba-conf
• Secure TCP/IP Connections with SSL

Commands

psql -l -U root # list all databases
psql -U root dbname_test # log into database dbname_test
\help
\h
\l - list all databases
\dt - list all tables in the database
\q 
createdb -Oroot -Eutf8 dbname_development
createdb -Oroot -Eutf8 dbname_test
ps auxwww | grep postgres
lunchy stop postgres
lunchy start postgres

\d - List tables in the database
\d employees - describe a table
createuser -P username

ALTER USER username WITH PASSWORD password