Today's tip is how to have a lean mean PostgreSQL client machine by only installing the needed tools. Why install all of PostgreSQL when your database server is up in the cloud, managed like a Compose PostgreSQL.
- Postico 1 5 – A Modern Postgresql Client Server Instance
- Postico 1 5 – A Modern Postgresql Client Server Commands
- Postico 1 5 – A Modern Postgresql Client Server Ubuntu
To start postgres in the background using default values, type: $ nohup postgres logfile 2&1 postgres with a specific port, e.g. 1234: $ postgres -p 1234. To connect to this server using psql, specify this port with the -p option: $ psql -p 1234. Or set the environment variable PGPORT: $ export PGPORT=1234 $ psql. Postico - A Modern PostgreSQL Client for OS X (Commercial Software) PSequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly (Commercial Software) SQL Tabs - A Cross Platform Desktop Client for Postgres written in JS; Distributions. Postgres.app - The Easiest Way to Get Started with PostgreSQL.
Most instructions for installing the PostgreSQL tools assume you want the database installed too. It's a reasonable assumption if you're dealing with users who don't have access to PostgreSQL in the cloud or on a remote server.
So, in this PostgreSQL Tip, we'll look at how you can install just psql on Windows, Linux and macOS, allowing you to quickly get up and running and connected to your Compose PostgreSQL service. We'll cover: Opera 63 0 3368 66 street.
- macOS with Homebrew
- Ubuntu 16.04 and 18.04
- Red Hat Enterprise Linux 7 (and others)
- Fedora 27 and 28
- Windows 10
Let's dive in.
macOS with Homebrew
We recommend Homebrew as a package manager for macOS. With Homebrew in place you'll be able to install numerous applications, usually with the programs available in /usr/local/bin. Homebrew's package for the PostgreSQL client tools is the libpq package. Brew makes it easy to install:
There's a small catch though: libpq won't install itself in the /usr/local/bin directory. To make that happen, you need to run:
Which will symlink all the tools, not just libpq, into the /usr/local/bin directory. You're ready to run psql and start connecting now.
Ubuntu 16.04 and 18.04
Linux systems, unlike macOS, have a package manager built in. For Ubuntu (and Debian-based distributions) thats's the apt command. The PostgreSQL client is distributed in the appositely named postgresql-client so all you need to do is run:
This will install the PostgreSQL 10 client, which can happily connect to earlier versions of PostgreSQL.
Red Hat Enterprise Linux 7 (and others)
For Red Hat Enterprise Linux (or RHEL as it's usually written), there's a little more set up to do than Ubuntu. For RHEL, the package manager is yum. First, you need to point yum at the PostgreSQL repository like this:
Yum goes to that URL and configures itself to use that package repository. With that done, you can add packages from it by name:
This installs just the client packages. If you are wondering where to find that repository URL, head to Linux Downloads (Red Hat Family) where you'll find a form which will let you select the PostgreSQL version, platform and architecture and it'll give you the appropriate instructions for that Red Hat variant - that includes CentOS, Scientific Linux, and Oracle Enterprise Linux. It also includes Fedora but read on..
Fedora 27 and 28
Fedora's default repositories already have a PostgreSQL client available from them. So For Fedora 27 and 28 and later, install the PostgreSQL client from the terminal with:
- macOS with Homebrew
- Ubuntu 16.04 and 18.04
- Red Hat Enterprise Linux 7 (and others)
- Fedora 27 and 28
- Windows 10
Let's dive in.
macOS with Homebrew
We recommend Homebrew as a package manager for macOS. With Homebrew in place you'll be able to install numerous applications, usually with the programs available in /usr/local/bin. Homebrew's package for the PostgreSQL client tools is the libpq package. Brew makes it easy to install:
There's a small catch though: libpq won't install itself in the /usr/local/bin directory. To make that happen, you need to run:
Which will symlink all the tools, not just libpq, into the /usr/local/bin directory. You're ready to run psql and start connecting now.
Ubuntu 16.04 and 18.04
Linux systems, unlike macOS, have a package manager built in. For Ubuntu (and Debian-based distributions) thats's the apt command. The PostgreSQL client is distributed in the appositely named postgresql-client so all you need to do is run:
This will install the PostgreSQL 10 client, which can happily connect to earlier versions of PostgreSQL.
Red Hat Enterprise Linux 7 (and others)
For Red Hat Enterprise Linux (or RHEL as it's usually written), there's a little more set up to do than Ubuntu. For RHEL, the package manager is yum. First, you need to point yum at the PostgreSQL repository like this:
Yum goes to that URL and configures itself to use that package repository. With that done, you can add packages from it by name:
This installs just the client packages. If you are wondering where to find that repository URL, head to Linux Downloads (Red Hat Family) where you'll find a form which will let you select the PostgreSQL version, platform and architecture and it'll give you the appropriate instructions for that Red Hat variant - that includes CentOS, Scientific Linux, and Oracle Enterprise Linux. It also includes Fedora but read on..
Fedora 27 and 28
Fedora's default repositories already have a PostgreSQL client available from them. So For Fedora 27 and 28 and later, install the PostgreSQL client from the terminal with:
and that's all you need to do. Export calendars pro 1 9 2.
Windows 10
On Windows 10, there's a bit more work to be done. We currently recommend using the PostgreSQL installer from Enterprise DB. It's a full installation package for PostgreSQL on Windows but you can set it to only install the command line tools like psql. Click on that link and select PostgreSQL 9.6 or 10 and Windows 10 as the platform. Once the executable file is downloaded, run it and you'll see the following options:
Select only the 'Command Line Tools' because we don't need the server installed. After it installs, you'll need to set up your Windows environment variables so that you can use the psql client in the command prompt.
Go to the Control Panel > System and Security > System and select Advanced system settings.
From there you'll see a box called System Properties. Select Environment Variables. A window will appear with the two sets of environment variables. In the top set, marked 'User variables for..' select the PATH entry and then click the Edit button. An edit window will appear. Click New and add the path to the psql client. Your path will depend on where PostgreSQL installed, but typically that would be:
After that, click OK a couple of times to go back to the desktop. Start a new Command Prompt and you should be able to run psql. With no server set and no server running locally, you'll see the following which means that it's working.
Start Connecting ..
Postico 1 5 – A Modern Postgresql Client Server Instance
We've covered setting up the PostgreSQL client for multiple platforms so start connecting. If you have suggestions on what you'd like to see covered in our next PostgreSQL Tips, drop us a line to articles@compose.com and we'll see how we can tip you too.
attributionJan Kahánek via Unsplash
Postico 1 5 – A Modern Postgresql Client Server Commands
Description
Name: Postico
Version: 1.0.10
Release Date: October 13, 2016
Language: English
Developer: Jakob Egger
MAS Rating: 4+
Mac Platform: Intel
OS Version: OS X 10.9 or later
Processor type(s) & speed: 64-bit processor
Web Site: https://eggerapps.at/postico
Mac App Store: https://itunes.apple.com/app/postico/id1031280567?mt=12
Overview:
Postico is a modern database app for your Mac.
Postico is the perfect tool for data entry, analytics, and application development.
– connect to Postgres.app
– connect to PostgreSQL 8.0, 8.1, 8.2, 8.4, 9.0, 9.1, 9.2, 9.3, 9.4, 9.5 and 9.6 servers
– connect to cloud services like Heroku Postgres, Amazon Redshift, Amazon RDS
– connect to other RDBMs that use the PostgreSQL protocol, like CockroachDB
Postico is the perfect app for managing your data. It has great tools for data entry. Filter rows that contain a search term, or set up advanced filters with multiple conditions. Quickly view rows from related tables, and save time by editing multiple rows at once.
For analytics workloads, Postico has a powerful query editor with syntax highlighting and many advanced text editing features. Execute multiple queries at once, or execute them one at a time and export results quickly.
For application developers, Postico offers a full featured table designer. Add, rename and remove columns, set default values, and add column constraints (NOT NULL, UNIQUE, CHECK constraints, foreign keys etc.). Document your database by adding comments to every table, view, column, and constraint.
But the best part of Postico is how well it works. Postico is made on a Mac for a Mac. It works great with all your other Mac apps. Use all the usual keyboard shortcuts. Postico gets the basic things like copy/paste just right, and also supports more advanced features like services for text editing.
What's New in Version 1.0.10:
Postico 1 5 – A Modern Postgresql Client Server Ubuntu
– The 'Open Quickly' now works better across multiple databases. It is also faster, more stable, and has improved ranking of search results.
– Added 'Copy JSON' and 'Copy HTML Table' commands
– Copy INSERT now includes table schema
– Fixed a number of issues where syntax highlighting did not work as expected.
– Fixed an issue where Postico disconnected from the server after an error occurred when using localised error messages
– Add support for deleting and renaming indices in CockroachDB
– Error messages are no longer duplicated in the SQL Query View
– 'Clear Results' command (cmd-K) lets you clear the SQL Query View
– Added a hidden setting to disable restoring the text in the SQL Query View
– Postico now remembers the size & position of the favorites window.
– The bundled version of libpq was updated to version 9.5.4
– Removed bundled libmagic
– Fixed a crash when Postico opens many connections simultaneously (eg. when using the Quick Open command)
– Fixed a crash when displaying error messages on macOS 10.9
