postgres

postgres://user:password@host:port/dbname?query (postgresql:// works, too)

URL Query	WithInstance Config	Description
`x-migrations-table`	`MigrationsTable`	Name of the migrations table
`dbname`	`DatabaseName`	The name of the database to connect to
`search_path`		This variable specifies the order in which schemas are searched when an object is referenced by a simple name with no schema specified.
`user`		The user to sign in as
`password`		The user's password
`host`		The host to connect to. Values that start with / are for unix domain sockets. (default is localhost)
`port`		The port to bind to. (default is 5432)
`fallback_application_name`		An application_name to fall back to if one isn't provided.
`connect_timeout`		Maximum wait for connection, in seconds. Zero or not specified means wait indefinitely.
`sslcert`		Cert file location. The file must contain PEM encoded data.
`sslkey`		Key file location. The file must contain PEM encoded data.
`sslrootcert`		The location of the root certificate file. The file must contain PEM encoded data.
`sslmode`		Whether or not to use SSL (disable\|require\|verify-ca\|verify-full)

Upgrading from v1

Write down the current migration version from schema_migrations
DROP TABLE schema_migrations
Wrap your existing migrations in transactions (BEGIN/COMMIT) if you use multiple statements within one migration.
Download and install the latest migrate version.
Force the current migration version with migrate force <current_version>.