# 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.

```sql
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.

```sql
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.

```sql
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";
```