![]() Up to this point we have managed to install Postgresql 14 on an Ubuntu server, do some basic configurations then do basic user management. Psql 'postgres://root: :5432/postgres?sslmode=disable' Conclusion Use this command to test that you can connect: psql like Connecting to the instance from remote host Grant all privileges on database app_db_name to app_user Ĭheckout this comprehensive guide on user and permission management in postgres here. Use this to create a database, create a user and grant that user all accesss to that database: create database app_db_name Ĭreate user app_user with encrypted password 'dbpassword' Postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | Postgres=# CREATE ROLE root WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'passwordhere'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |