Running Python Flask

Postgresql


Created: 2023-12-21 | Modified: 2024-11-09

Create database, user and grant permissions

Create database, and user for login

sudo -u postgres psql

CREATE DATABASE "database_name";
CREATE ROLE "username";
ALTER ROLE "username" WITH LOGIN;
ALTER USER "username" WITH PASSWORD 'change_me';
GRANT SELECT ON "table_name" TO "username";

Replace database_name, username, change_me and talbe_name

DB backup / restore

Comments













(Will await approval before becoming public)