README.md in pgdexter-0.5.0 vs README.md in pgdexter-0.5.1
- old
+ new
@@ -10,12 +10,12 @@
First, install [HypoPG](https://github.com/HypoPG/hypopg) on your database server. This doesn’t require a restart.
```sh
cd /tmp
-curl -L https://github.com/HypoPG/hypopg/archive/1.3.1.tar.gz | tar xz
-cd hypopg-1.3.1
+curl -L https://github.com/HypoPG/hypopg/archive/1.4.0.tar.gz | tar xz
+cd hypopg-1.4.0
make
make install # may need sudo
```
And enable it in databases where you want to use Dexter:
@@ -172,30 +172,10 @@
```sh
dexter --interval 60 # seconds
```
-## Examples
-
-Postgres package on Ubuntu 22.04
-
-```sh
-sudo -u postgres dexter -d dbname /var/log/postgresql/postgresql-14-main.log
-```
-
-Homebrew Postgres on Mac ARM
-
-```sh
-dexter -d dbname /opt/homebrew/var/log/postgresql@14.log
-```
-
-Homebrew Postgres on Mac x86-64
-
-```sh
-dexter -d dbname /usr/local/var/log/postgresql@14.log
-```
-
## Analyze
For best results, make sure your tables have been recently analyzed so statistics are up-to-date. You can ask Dexter to analyze tables it comes across that haven’t been analyzed in the past hour with:
```sh
@@ -228,12 +208,11 @@
The `hypopg` extension, which Dexter needs to run, is available on [these providers](https://github.com/ankane/dexter/issues/44).
For other providers, see [this guide](guides/Hosted-Postgres.md). To request a new extension:
-- Amazon RDS - follow the instructions on [this page](https://aws.amazon.com/rds/postgresql/faqs/)
- Google Cloud SQL - vote or comment on [this page](https://issuetracker.google.com/issues/69250435)
-- DigitalOcean Managed Databases - vote or comment on [this page](https://ideas.digitalocean.com/app-framework-services/p/support-hypopg-for-postgres)
+- DigitalOcean Managed Databases - vote or comment on [this page](https://ideas.digitalocean.com/managed-database/p/support-hypopg-for-postgres)
## HypoPG Installation Notes
### Postgres Location