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.

CREATE USER "bindplane" WITH PASSWORD 'your_password';

2. Create Database

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

CREATE DATABASE "bindplane" ENCODING 'UTF8' TEMPLATE template0;
GRANT CREATE ON DATABASE "bindplane" TO "bindplane";
\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.

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "bindplane";
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO "bindplane";
GRANT ALL PRIVILEGES ON SCHEMA public TO "bindplane";