PostgreSQL

postgres (postgres variant)

The World's Most Advanced Open Source Relational Database.

The postgres utility is a containerized instance of Postgres useful for local development.

Getting Started

Prerequisites

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Dependencies

Postgres is packaged as a Docker image so you must have Docker installed before running the plugin.

Installation and configuration

  1. Add the postgres utility to your project using
    meltano add
    :
  2. meltano add postgres
  3. Configure the postgres settings using
    meltano config
    :
  4. meltano config postgres set --interactive

Next steps

  1. Launch Postgres:

    meltano invoke --containers postgres:start
    

    Connect with your postgres client at postgresql://warehouse:warehouse@localhost:5432/warehouse.

If you run into any issues, learn how to get help.

Capabilities

This plugin currently has no capabilities defined. If you know the capabilities required by this plugin, please contribute!

Settings

This plugin currently has no settings defined. If you know the settings required by this plugin, please contribute!

Commands

The postgres utility supports the following commands that can be used with
meltano invoke
:

start

  • Equivalent to: start

meltano invoke postgres:start [args...]

Something missing?

This page is generated from a YAML file that you can contribute changes to.

Edit it on GitHub!

Looking for help?

If you're having trouble getting the postgres utility to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the
#plugins-general
channel.
Meltano Community Connector

PostgreSQL is built and maintained by the Meltano community. For connectors that are built, tested, and supported by the Meltano team, explore Meltano Cloud.

  • Expert support — get support from experts who build and support connectors on Meltano Cloud
  • Tested daily — daily monitoring catches issues before they hit your pipelines
  • Low maintenance — API changes, schema drift and breaking changes handled for you

Install

meltano add postgres

Maintenance Status

  • Maintenance Status

Repo

https://github.com/postgres/postgres
  • Stars
  • Forks
  • Last Commit Date
  • Open Issues
  • Open PRs
  • Contributors
  • License

Maintainer

  • Postgres

Meltano Stats

  • Total Executions (Last 3 Months)
  • Projects (Last 3 Months)

Keywords

  • warehouse