github.com/scraniel/migrate@v0.0.0-20230320185700-339088f36cee/database/yugabytedb/README.md (about)

     1  # yugabytedb
     2  
     3  `yugabytedb://user:password@host:port/dbname?query` (`yugabyte://`, and `ysql://` work, too)
     4  
     5  | URL Query  | WithInstance Config | Description |
     6  |------------|---------------------|-------------|
     7  | `x-migrations-table` | `MigrationsTable` | Name of the migrations table |
     8  | `x-lock-table` | `LockTable` | Name of the table which maintains the migration lock |
     9  | `x-force-lock` | `ForceLock` | Force lock acquisition to fix faulty migrations which may not have released the schema lock (Boolean, default is `false`) |
    10  | `x-max-retries` | `MaxRetries` | How many times retry queries on retryable errors (40001, 40P01, 08006, XX000). Default is 10 |
    11  | `x-max-retry-interval` | `MaxRetryInterval` | Interval between retries increases exponentially. This option specifies maximum duration between retries. Default is 15s |
    12  | `x-max-retry-elapsed-time` | `MaxRetryElapsedTime` | Total retries timeout. Default is 30s |
    13  | `dbname` | `DatabaseName` | The name of the database to connect to |
    14  | `user` | | The user to sign in as |
    15  | `password` | | The user's password |
    16  | `host` | | The host to connect to. Values that start with / are for unix domain sockets. (default is localhost) |
    17  | `port` | | The port to bind to. (default is 5432) |
    18  | `connect_timeout` | | Maximum wait for connection, in seconds. Zero or not specified means wait indefinitely. |
    19  | `sslcert` | | Cert file location. The file must contain PEM encoded data. |
    20  | `sslkey` | | Key file location. The file must contain PEM encoded data. |
    21  | `sslrootcert` | | The location of the root certificate file. The file must contain PEM encoded data. |
    22  | `sslmode` | | Whether or not to use SSL (disable\|require\|verify-ca\|verify-full) |