Difference between revisions of "Postgresql"

Revision as of 12:13, 17 December 2020

This is a way to test the database connection.

 ./pg_isready -h localhost -p 5432

Log location

./data/log/

The Postgres app live here on OSX

 /Library/PostgreSQL/11

Start

 sudo -u postgres ./bin/pg_ctl -D ./data start

Stop

 sudo -u postgres ./bin/pg_ctl -D ./data stop

FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.

To add PostgreSQL in to your environment path.

 export POSTGRESQL_HOME=/Library/PostgreSQL/11
 PATH=$PATH:$POSTGRESQL_HOME/bin

PSQL will ask for your password every time unless you set it as an environment variable.

 export PGPASSWORD=Password123

To run a command.

 psql -U user_name -d database_name -c "SELECT * FROM tblExample"

To run a file.

 psql -U user_name -d database_name -f ./file.sql

Error Connecting to database FATAL : no pg_hba.conf entry for host I had to add the host ip address into the pg_hba.conf file.

location of file: ./data/pg_hba.conf

Added the following line and then restarted Postgres.

 host    all             all             10.225.41.95/24        md5

@@ Line 18: / Line 18: @@
 FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.
+== Environment Path ==
+To add PostgreSQL in to your environment path.
+  export POSTGRESQL_HOME=/Library/PostgreSQL/11
+  PATH=$PATH:$POSTGRESQL_HOME/bin
+== Run file and commands from CLI ==
+PSQL will ask for your password every time unless you set it as an environment variable.
+  export PGPASSWORD=Password123
+To run a command.
+  psql -U user_name -d database_name -c "SELECT * FROM tblExample"
+To run a file.
+  psql -U user_name -d database_name -f ./file.sql
 == Issues ==