U, -username=USERNAME database user name (default: "postgres") p, -port=PORT database server port (default: "5432") h, -host=HOSTNAME database server host or socket directory (default: "local socket") Set record separator for unaligned output to zero byte Set field separator for unaligned output to zero byte x, -expanded turn on expanded table output T, -table-attr=TEXT set HTML table tag attributes (e.g., width, border) Record separator for unaligned output (default: newline) P, -pset=VAR set printing option VAR to ARG (see \pset command) csv CSV (Comma-Separated Values) table output modeįield separator for unaligned output (default: "|") A, -no-align unaligned table output mode S, -single-line single-line mode (end of line terminates SQL command) s, -single-step single-step mode (confirm each query) q, -quiet run quietly (no messages, only query output) o, -output=FILENAME send query results to file (or |pipe) n, -no-readline disable enhanced command line editing (readline) L, -log-file=FILENAME send session log to file E, -echo-hidden display queries that internal commands generate e, -echo-queries echo commands sent to server help=variables list special variables, then exit help=commands list backslash commands, then exit X, -no-psqlrc do not read startup file (~/.psqlrc)Įxecute as a single transaction (if non-interactive) V, -version output version information, then exit l, -list list available databases, then exit f, -file=FILENAME execute commands from file, then exit d, -dbname=DBNAME database name to connect to (default: "postgres") c, -command=COMMAND run only single command (SQL or internal) and exit Psql is the PostgreSQL interactive terminal. still point to the old version of the psql client. Now, keep in mind that commands psql, pg_dump etc. The new package should be installed with all its executables in here: /usr/local/pgsql/bin Note: The link below points to postgresql 10.4, you may want to check for newer subversions sudo yum install -y gcc readline-devel zlib-devel We're using VERSION="2018.03" of Amazon Linux AMI in our pipelines. Since none of the previous answers worked for me, I'm adding a solution that let me install the postgresql10 client. May still install step by step all dependencies and the server with: yum install -y Since postgresql10 is not yet available, adding extra yum repo is the only solution per today.Įrror: Package: Note! Amazon Linux 2 provides additional package installation through Amazon Linux Extras Repository ( amazon-linux-extras) ((client only)). Install PostgreSQL Client v10 $ sudo yum install -y postgresql10 Install RHEL 7 yum repo for PostgreSQL $ sudo yum install -y You may run into compatibility issues if you select old version of Amazon Linux (Amazon linux 1) for the below steps, otherwise it should work fine in the latest version Amazon Linux 2.Ĭheck Amazon Linux version $ cat /etc/system-releaseĪmazon Linux release 2.0 (2017.12) LTS Release Candidate Packages/Repos which is designed to work of RedHat will work on Amazon Linux also, Amazon Linux is a minimal-install version of RHEL.
0 Comments
Leave a Reply. |