still cannot create default user & password

[xar]

pgforge create bilisdb --port 5891
⠹ Checking system requirements...Creating PostgreSQL instance 'bilisdb'...
Creating new instance configuration...
⠸ Creating PostgreSQL instance...Instance configuration:
Name: bilisdb
Version: 17.5
Port: 5891
Data directory: /home/samo/.local/share/pgforge/bilisdb
Checking if port 5891 is available...
Creating instance directories...
Initializing PostgreSQL database...
Using initdb binary: /usr/lib/postgresql/17/bin/initdb
Initializing database cluster in: /home/samo/.local/share/pgforge/bilisdb
Executing: /usr/lib/postgresql/17/bin/initdb -D /home/samo/.local/share/pgforge/bilisdb --auth-local=peer --auth-host=md5 --encoding=UTF8 --locale=en_US.UTF-8
⠧ Creating PostgreSQL instance...Database initialization completed successfully
Creating socket directory...
Creating database and user with password...
Starting temporary PostgreSQL instance on port 5891...
PostgreSQL binary: /usr/lib/postgresql/17/bin/postgres
Data directory: /home/samo/.local/share/pgforge/bilisdb
Temporary PostgreSQL process started with PID: 63533
Waiting for PostgreSQL to become ready on port 5891...
Attempt 1/30: Testing PostgreSQL connection...
Attempt 1/30 failed: Command failed: /usr/lib/postgresql/17/bin/psql -h "/home/samo/.local/share/pgforge/bilisdb/sockets" -p 5891 -U postgres -d postgres -c "SELECT 1"
psql: error: connection to server on socket "/home/samo/.local/share/pgforge/bilisdb/sockets/.s.PGSQL.5891" failed: No such file or directory
Is the server running locally and accepting connections on that socket?

⠋ Creating PostgreSQL instance...Attempt 2/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:24.382 CEST [63544] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:24.382 CEST [63544] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠹ Creating PostgreSQL instance...Attempt 3/30: Testing PostgreSQL connection...
⠸ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:25.412 CEST [63547] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:25.412 CEST [63547] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:25.412 CEST [63547] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠴ Creating PostgreSQL instance...Attempt 4/30: Testing PostgreSQL connection...
⠦ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:26.444 CEST [63550] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:26.444 CEST [63550] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:26.444 CEST [63550] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠇ Creating PostgreSQL instance...Attempt 5/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:27.477 CEST [63553] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:27.477 CEST [63553] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:27.477 CEST [63553] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠏ Creating PostgreSQL instance...Attempt 5/30 failed: Command failed: /usr/lib/postgresql/17/bin/psql -h "/home/samo/.local/share/pgforge/bilisdb/sockets" -p 5891 -U postgres -d postgres -c "SELECT 1"
psql: error: connection to server on socket "/home/samo/.local/share/pgforge/bilisdb/sockets/.s.PGSQL.5891" failed: FATAL: Peer authentication failed for user "postgres"

⠙ Creating PostgreSQL instance...Attempt 6/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:28.509 CEST [63556] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:28.509 CEST [63556] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:28.509 CEST [63556] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠼ Creating PostgreSQL instance...Attempt 7/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:29.537 CEST [63559] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:29.537 CEST [63559] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:29.537 CEST [63559] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠧ Creating PostgreSQL instance...Attempt 8/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:30.566 CEST [63562] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:30.566 CEST [63562] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:30.566 CEST [63562] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠏ Creating PostgreSQL instance...Attempt 9/30: Testing PostgreSQL connection...
⠋ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:31.595 CEST [63565] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:31.595 CEST [63565] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:31.595 CEST [63565] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠹ Creating PostgreSQL instance...Attempt 10/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:32.625 CEST [63568] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:32.625 CEST [63568] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:32.625 CEST [63568] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
Attempt 10/30 failed: Command failed: /usr/lib/postgresql/17/bin/psql -h "/home/samo/.local/share/pgforge/bilisdb/sockets" -p 5891 -U postgres -d postgres -c "SELECT 1"
psql: error: connection to server on socket "/home/samo/.local/share/pgforge/bilisdb/sockets/.s.PGSQL.5891" failed: FATAL: Peer authentication failed for user "postgres"

⠴ Creating PostgreSQL instance...Attempt 11/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:33.655 CEST [63571] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:33.655 CEST [63571] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:33.655 CEST [63571] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠇ Creating PostgreSQL instance...Attempt 12/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:34.681 CEST [63574] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:34.681 CEST [63574] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:34.681 CEST [63574] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠋ Creating PostgreSQL instance...Attempt 13/30: Testing PostgreSQL connection...
⠙ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:35.718 CEST [63580] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:35.718 CEST [63580] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠸ Creating PostgreSQL instance...Attempt 14/30: Testing PostgreSQL connection...
⠼ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:36.735 CEST [63583] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:36.736 CEST [63583] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:36.736 CEST [63583] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠦ Creating PostgreSQL instance...Attempt 15/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:37.759 CEST [63586] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:37.759 CEST [63586] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:37.759 CEST [63586] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
Attempt 15/30 failed: Command failed: /usr/lib/postgresql/17/bin/psql -h "/home/samo/.local/share/pgforge/bilisdb/sockets" -p 5891 -U postgres -d postgres -c "SELECT 1"
psql: error: connection to server on socket "/home/samo/.local/share/pgforge/bilisdb/sockets/.s.PGSQL.5891" failed: FATAL: Peer authentication failed for user "postgres"

⠇ Creating PostgreSQL instance...Attempt 16/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:38.788 CEST [63589] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:38.788 CEST [63589] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:38.788 CEST [63589] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠙ Creating PostgreSQL instance...Attempt 17/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 08:55:39.821 CEST [63592] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:39.821 CEST [63592] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"
⠸ Creating PostgreSQL instance...Attempt 18/30: Testing PostgreSQL connection...
⠼ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 08:55:40.850 CEST [63595] LOG: provided user name (postgres) and authenticated user name (samo) do not match
2025-06-28 08:55:40.850 CEST [63595] FATAL: Peer authentication failed for user "postgres"
2025-06-28 08:55:40.850 CEST [63595] DETAIL: Connection matched file "/home/samo/.local/share/pgforge/bilisdb/pg_hba.conf" line 113: "local all all peer"

@claude

[claude]

Claude finished @xar's task —— View job • claude/issue-46-20250628_065625 • Create PR ➔

---

Todo List

• Examine the current pgforge codebase to understand PostgreSQL instance creation
• Identify the authentication configuration issue in the initdb process
• Fix the pg_hba.conf configuration or authentication method
• Test the fix and commit changes

Analysis

Found the issue! The problem was in the createDatabaseAndUser method in src/instance/manager.ts:219. The tool:

1. Uses initdb with --auth-local=peer which requires system user to match PostgreSQL user
2. Tries to connect as 'postgres' user while running as 'samo' user
3. Peer authentication fails because 'postgres' ≠ 'samo'

Fix Applied

Fixed the authentication flow by:

1. Changed initdb authentication: Using --auth-local=trust during initialization instead of --auth-local=peer
2. Updated pg_hba.conf generation: Changed local connections to use md5 authentication instead of peer
3. Enhanced user creation: Added proper postgres superuser password setup before creating database and user

This allows the initial setup to work with trust authentication, then applies proper password-based authentication for ongoing use.

Resolution

✅ Fixed the PostgreSQL authentication issue

The changes resolve the "Peer authentication failed for user 'postgres'" error by using a proper authentication flow:

• Trust authentication during setup (temporary)
• MD5 password authentication for normal operations (secure)

You should now be able to run pgforge create bilisdb --port 5891 successfully!

---