PostgreSQL

PostgreSQL is an advanced open source database server. You can easily add it to your Lando app by adding an entry to the services key in your app's .lando.yml.

Supported versions

Be Careful Switching Database type, version or credentials

You should be careful switching database types, versions or credentials. In the case of type and version the underlying database files between these things may not be compatible. Ignoring this warning can cause your database service to not start correctly!!! In the case of credentials, these are set when the container is initially created so in order to change them you need to lando destroy && lando start. Note that lando destroy will delete all the data in your database.

You can read more about this here

Using patch versions

While Lando does not "officially" support specifying a patch version of this service you can try specifying one using overrides if you need to. This is not guaranteed to work so use at your own risk and take some care to make sure you are using a debian flavored patch version that also matches up with the major and minor versions of the service that we indicate above in "Supported versions".

Here are all the tags that are available for this service.

Here is an example of overriding the nginx service to use a patched version.

# The name of my app
name: patchversion

# Give me http://patchversion.lndo.site and https://patchversion.lndo.site
proxy:
  appserver:
    - patchversion.lndo.site

# Configure my services
services:

  # Create an nginx service called "appserver"
  appserver:

    # Set this to custom so we can override down the stream
    type: nginx:custom

    # SSL
    ssl: true

    # Override the image with the patch version
    # Note that this needs to be a correct namespace on the docker hub
    overrides:
      services:
        image: nginx:1.12.1

# Quick comamnd to check the nginx version
tooling:
  nginx:
    service: appserver

You can check out the full code for this example over here.

Example

# The name of the app
name: postgres

# Give me http://postgres.lndo.site and https://postgres.lndo.site
proxy:
  html:
    - postgres.lndo.site

# Service configuration
services:

  # Set up a basic webserver running the latest nginx with ssl turned on
  html:
    webroot: www
    type: nginx
    ssl: true

  # Spin up a postgres container called "tswift"
  tswift:

    # Use the latest version of postgres
    type: postgres

    # Optionally allow access to the database at localhost:3307
    # You will need to make sure port 3307 is open on your machine
    #
    # You can also set `portforward: true` to have Lando dynamically assign
    # a port. Unlike specifying an actual port setting this to true will give you
    # a different port every time you restart your app
    portforward: 5444

    # Optionally set the default db credentials
    #
    # Note: You will need to `lando destroy && lando start` to change these if you've
    # already started your app
    # See: https://docs.devwithlando.io/tutorials/lando-info.html
    creds:
      user: trouble
      password: trouble
      database: trouble

    # Optionally load in all the postgres config files into the config directory
    # This is relative to the app root
    # NOTE: these files need to end in .conf
    config:
      confd: confd

You will need to rebuild your app with lando rebuild to apply the changes to this file. You can check out the full code for this example over here.

Getting information

You can get connection and credential information about your database by running lando info from inside your app.

# Navigate to the app
cd /path/to/app

# Get info (app needs to be running to get this)
lando info

{
  "html": {
    "type": "nginx",
    "version": "latest",
    "urls": [
      "https://localhost:32811",
      "http://localhost:32812",
      "http://postgres.lndo.site",
      "https://postgres.lndo.site"
    ]
  },
  "tswift": {
    "type": "postgres",
    "version": "latest",
    "creds": {
      "user": "trouble",
      "password": "trouble",
      "database": "trouble"
    },
    "internal_connection": {
      "host": "tswift",
      "port": 5432
    },
    "external_connection": {
      "host": "localhost",
      "port": 5444
    }
  }
}

results matching ""

    No results matching ""