Still cannot set password

[xar]

@claude please for the sake of god can you fix it properly, ultrathink before you commit to solution you again made fix but it didn't work

we are solving this issue with creating password for past hour already 😖

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=trust --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: 64602
Waiting for PostgreSQL to become ready on port 5891...
Attempt 1/30: Testing PostgreSQL connection...
⠇ Creating PostgreSQL instance...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 09:01:47.914 CEST [64613] FATAL: role "postgres" does not exist
⠸ Creating PostgreSQL instance...Attempt 3/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:48.944 CEST [64616] FATAL: role "postgres" does not exist
⠦ Creating PostgreSQL instance...Attempt 4/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:49.973 CEST [64619] FATAL: role "postgres" does not exist
⠇ Creating PostgreSQL instance...Attempt 5/30: Testing PostgreSQL connection...
⠏ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 09:01:51.000 CEST [64622] FATAL: role "postgres" does not exist
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: role "postgres" does not exist

⠙ Creating PostgreSQL instance...Attempt 6/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:52.023 CEST [64625] FATAL: role "postgres" does not exist
⠼ Creating PostgreSQL instance...Attempt 7/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:53.050 CEST [64629] FATAL: role "postgres" does not exist
⠧ Creating PostgreSQL instance...Attempt 8/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:54.079 CEST [64632] FATAL: role "postgres" does not exist
⠋ Creating PostgreSQL instance...Attempt 9/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:55.104 CEST [64635] FATAL: role "postgres" does not exist
⠹ Creating PostgreSQL instance...Attempt 10/30: Testing PostgreSQL connection...
⠸ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 09:01:56.129 CEST [64638] FATAL: role "postgres" does not exist
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: role "postgres" does not exist

⠴ Creating PostgreSQL instance...Attempt 11/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:57.160 CEST [64641] FATAL: role "postgres" does not exist
⠇ Creating PostgreSQL instance...Attempt 12/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:58.190 CEST [64644] FATAL: role "postgres" does not exist
⠋ Creating PostgreSQL instance...Attempt 13/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:01:59.213 CEST [64647] FATAL: role "postgres" does not exist
⠹ Creating PostgreSQL instance...Attempt 14/30: Testing PostgreSQL connection...
⠸ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 09:02:00.238 CEST [64650] FATAL: role "postgres" does not exist
⠴ Creating PostgreSQL instance...Attempt 15/30: Testing PostgreSQL connection...
⠦ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 09:02:01.272 CEST [64653] FATAL: role "postgres" does not exist
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: role "postgres" does not exist

⠇ Creating PostgreSQL instance...Attempt 16/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:02:02.303 CEST [64656] FATAL: role "postgres" does not exist
⠙ Creating PostgreSQL instance...Attempt 17/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:02:03.329 CEST [64659] FATAL: role "postgres" does not exist
⠼ Creating PostgreSQL instance...Attempt 18/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:02:04.350 CEST [64662] FATAL: role "postgres" does not exist
⠦ Creating PostgreSQL instance...Attempt 19/30: Testing PostgreSQL connection...
⠧ Creating PostgreSQL instance...PostgreSQL stderr: 2025-06-28 09:02:05.376 CEST [64665] FATAL: role "postgres" does not exist
⠏ Creating PostgreSQL instance...Attempt 20/30: Testing PostgreSQL connection...
PostgreSQL stderr: 2025-06-28 09:02:06.402 CEST [64668] FATAL: role "postgres" does not exist
Attempt 20/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: role "postgres" does not exist

⠹ Creating PostgreSQL instance...Attempt 21/30: Testing PostgreSQL connection...

[claude]

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

---

PostgreSQL Password Creation Issue Fixed! ✅

Todo List:

• Read repository setup and understand current PostgreSQL instance creation code
• Identify why the postgres role/user isn't being created during initdb
• Fix the initialization process to ensure postgres user exists
• Commit the fix
• Provide PR creation link

Root Cause:
The issue was in src/instance/manager.ts:452-453. The initdb command used --auth-local=trust --auth-host=md5 but didn't specify a username, so it created a superuser with the system username ("samo") instead of "postgres". When the code tried to connect as "postgres" user, it failed because that role didn't exist.

Fix Applied:
✅ Added --username=postgres parameter to the initdb command in src/instance/manager.ts:452 to explicitly create the postgres superuser role during database cluster initialization.

Testing:
The next time you run pgforge create bilisdb --port 5891, it should work properly as the postgres user will be created during initialization.

---