Tag: PostgreSQL

PostgreSQL connect to database using psql

To connect to PostgreSQL database server using psql command line, run If you have a PostgreSQL user and password, you

postgresql.service: The name org.freedesktop.PolicyKit1 was not provided by any .service files

When i restart postgresql, i get following error This is because you are running the command as user postres. Login

Run PostgreSQL in Docker

To run PostgreSQL on docker, create a directory for saving the data presistant run docker container In above, change the

PostgreSQL Export table into CSV file

To export a table into CSV file, run This will save the CSV file in current directory.

PostgreSQL List all databases

To list all databases in PostgreSQL database, first connect to PostgreSQL database using psql command Now run This will list

PostgreSQL Create Database

To create a database, run Creating user, grant permissions Creating a User and Database using psql

PostgreSQL Delete a Database

To delete a PostgreSQL database, run Example

Backup PostgreSQL Database

To backup PostgreSQL database, run Example PostgreSQL

Create user in PostgreSQL

Method 1 To create user, become user “postgres” with now run Method 2 You can run following commands in psql

pg_ctl

pg_ctl is used to start, stop PostgreSQL server. To start PostgreSQL, run You can also use stop/restart. PostgreSQL

PostgreSQL

PostgreSQL connect to database using psql List all databases in PostgreSQL pg_ctl Creating user in PostgreSQL PostgreSQL Create Database PostgreSQL