Remove tags psql
article thumbnail

Patroni 3.0 & Citus: Scalable, Highly Available Postgres

The Citus Data

In this blog post, you’ll learn how Patroni 3.0+ In this blog post we will be mostly talking about distributed Citus clusters and PostgreSQL clusters managed by Patroni (or Patroni clusters.) can be used to deploy a highly available Citus database cluster—just by adding a few lines to the Patroni configuration file.

article thumbnail

Getting Started with Docker Run

Linux Academy

tag to our image name using a colon ( : ): $ docker run -i --name python37 python:3.7 If you happen to have psql installed it would look something like this (substitute your Docker host’s IP address for 192.168.99.100 ): $ psql postgres://la_test:secret_password@192.168.99.100:5432/linuxacademy psql (11.1, Debian 10.4-2.pgdg90+1))

Linux 60
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Postgres tips for the average and power user

The Citus Data

Personally I’m a big fan of email, just like blogging. The first email was titled: Random Citus development and psql tips , and from there it piled on to be more and more tips and power user suggestions for Postgres. While the thread is still ongoing here is just a few of the great tips: In psql, tag your queries and use Ctrl+R.

Azure 19
article thumbnail

Metrics for Microservices

Kentik

Using a psql client, our RESTful API, or our portal, a user accesses the KDE’s PostgreSQL-based frontend and runs the following query: SELECT src_as, sum(in_pkts) as f_sum_in_pkts FROM all_devices WHERE i_start_time >= now() - interval'5 min' GROUP BY src_as ORDER BY f_sum_in_pkts DESC LIMIT 10. Metrics tags in Go.

Metrics 40