-
pg_dump is a nifty utility designed to output a series of SQL statements that describes the schema and data of your database. You can control what goes into your backup by using additional flags.
Backup:pg_dump -h localhost -p 5432 -U postgres -d mydb > backup.sqlRestore:
psql -h localhost -p 5432 -U postgres -d mydb < backup.sql-h is for host.
-p is for port.
-U is for username.
-d is for database.
sasharevzin
/ db_backup_commands.md
Created
June 16, 2023 19:52
— forked from AtulKsol/db_backup_commands.md
Commands to backup & restore database
sasharevzin
/ ruby_google_analytics_server_to_server.md
Created
August 30, 2021 20:49
— forked from joost/ruby_google_analytics_server_to_server.md
Google Analytics API (server-to-server) using Ruby
There are many (old) clients available:
- https://github.com/tpitale/legato (active, supports API v3)
- https://github.com/activenetwork/gattica
- https://github.com/vigetlabs/garb
The Google Analytics API is at v3 (at time of writing).
This example uses Google's Ruby API client to access Analytics. Use https://github.com/google/google-api-ruby-client (Google supported).