Postgres Configuration

Once PostgreSQL is installed, you need to create a user, database, and assign permissions.

1. Create User

Replace your_password with a secure password.

1CREATE USER bindplane WITH PASSWORD 'your_password';

2. Create Database

Create a database named bindplane. You can use a different database name if you prefer.

1CREATE DATABASE bindplane;
2\c bindplane;

3. Grant Permissions

Switch to the database created in step 1 with \c bindplane. Replace bindplane with the name of your database. Once connected, execute the following GRANT commands to give the bindplane user access to the bindplane database. Update the schema and database name if you used a different name.

1GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO bindplane;
2GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO bindplane;
3GRANT ALL PRIVILEGES ON SCHEMA public TO bindplane;