postgresql-tips.md

PostgreSQL Command Lines

$ brew install postgresql                                     # Install PostgreSQL

$ /usr/local/opt/postgres/bin/createuser -s postgres          # Create postgres role
$ psql -U postgres                                            # Connect to PostgreSQL
postgres=# \password postgres                                 # Set/change password for postgres

$ brew services start postgresql                              # Start PostgreSQL server

$ createdb database_name                                      # Create a new database
$ psql database_name < dump_file.sql                          # Restore previous backup
$ pg_dump database_name > dump_file.sql                       # Backup database