I found this while updating pg_embedded version to any 0.8.0+

[helio-frota]

Initially thinking that was related to
Breaking changes - define bootstrap superuser as postgres
https://github.com/theseus-rs/postgresql-embedded/releases/tag/v0.9.0

But it also happens with 0.8.0

[jcrossley3]

I've seen that occasionally, but I don't recall why. I don't see it now on my system. Does deleting your .trustify/ help?

$ rm -rf .trustify/

[helio-frota]

Unfortunately no

[jcrossley3]

Is there something unusual about your OS or filesystem? Tough to debug without steps to reproduce.

[helio-frota]

No, fedora 39 basic xfce etc...
Thanks for jumping into this (also because we need that solved)
have you tried updating to 0.9.0 and see if works ?
thanks

[jcrossley3]

I do see the error with 0.9.0, yes.

[helio-frota]

are we going to dig ?
I'll start

[helio-frota]

searching on internet, the error points to rust std lib...

I found this diff on pg_emb:

git diff v0.7.0 v0.8.0 -- ':!*.lock'

updating to latest the error persists:

➜  trustify git:(update-pg) ✗ cargo run --bin trustd
    Finished dev [unoptimized + debuginfo] target(s) in 0.28s
     Running `target/debug/trustd`
2024-04-29T15:06:57.529926Z  WARN trustd::db: Setting up managed DB; not suitable for production use!
Error: Invalid cross-device link (os error 18)
➜  trustify git:(update-pg) ✗ rustc --version
rustc 1.77.2 (25ef9e3d8 2024-04-09)

[helio-frota]

it will be solved with 👍
rust-lang/rustup#3737 (comment)

[jcrossley3]

This fixes it for me: theseus-rs/postgresql-embedded#58

[helio-frota]

great work the error gone !

➜  trustify git:(update-pg) ✗ cargo run --bin trustd
    Finished dev [unoptimized + debuginfo] target(s) in 0.28s
     Running `target/debug/trustd`
2024-04-29T18:53:34.497093Z  WARN trustd::db: Setting up managed DB; not suitable for production use!
2024-04-29T18:53:34.604099Z  INFO trustd::db: PostgreSQL installed in "/home/heliofrota/Desktop/tc/trustify/.trustify/postgres"
2024-04-29T18:53:34.604200Z  INFO trustd::db: Running on port 39423
2024-04-29T18:53:34.623816Z  INFO trustify_common::db: connect to postgres://trustify:trustify@localhost:39423/trustify
Error: Connection Error: error returned from database: password authentication failed for user "trustify"
Caused by:
	error returned from database: password authentication failed for user "trustify"
	error returned from database: password authentication failed for user "trustify"
	password authentication failed for user "trustify"
➜  trustify git:(update-pg) ✗ cat Cargo.toml | rg postgre
postgresql_embedded = { path = "/home/heliofrota/Desktop/postgresql-embedded/postgresql_embedded/"

[brianheineman]

This should be addressed in https://github.com/theseus-rs/postgresql-embedded/releases/tag/v0.9.1; thanks for the PR!

[jcrossley3]

This should be addressed in https://github.com/theseus-rs/postgresql-embedded/releases/tag/v0.9.1; thanks for the PR!

Yep! Already merged in #222

Thanks for the quick turnaround, @brianheineman