Problems with the Postgres image

[Cesars-dev]

So I am using an old mac (2015) and tried the “everyone else method”

everything seems to be working with n8n but then I try to run the postgres image I get the following error

Error: Database is uninitialized and superuser password is not specified.

You must specify POSTGRES_PASSWORD to a non-empty value for the

superuser. For example, “-e POSTGRES_PASSWORD=password” on “docker run”.

You may also use “POSTGRES_HOST_AUTH_METHOD=trust” to allow all

connections without a password. This is not recommended.

See PostgreSQL documentation about “trust”:

What am I doing wrong? I tried the mac solution and the “everyone else” solution

Also I tried reinstalling the package and I get the following message on my terminal

WARN[0000] The “POSTGRES_HOST” variable is not set. Defaulting to a blank string.

obviously the postgre container is not running, how can I fix this? i dont know a lot about coding or anything related, just trying to play with the workflows for now

Any help will be much appreciated

[interss]

Welcome @Cesars-dev

You need to have ADMINER on your VPS

Because it allows you to view the database data
Then you need to configure the information.

Copy the data from your POSTGRES to your ADMINER

I use DIGITALOCEAN, so my interface looks like this.

Note that the errors that appear to you give you a step-by-step guide on what you need to do to resolve them.

I suggest you share your workflow so we can see how we can help better.

[Cesars-dev]

Hey thanks for replying

I am currently running n8n locally, maybe thats why postgres is not loading properly. is it needed when running locally or only with a VPS?

[interss]

I have never set it up for local use, however, I believe the principle would be the same.

I hope this helps in some way.

[interss]

Please read the documentation below and see if it helps you with your issue.

PGVector Vector Store node documentation | n8n Docs

[interss]

@Cesars-dev If this suggestion solved your problem, please mark my post as the solution (blue box with check mark) so that this ongoing discussion does not distract others who want to find the answer to the original question. Thanks

[Cesars-dev]

actually it was very helpfull, did not solve the problem directly because I am on a different enviroment but I came up with 2 solutions:

1 using SQLite
2 downloading and running a container with PostgreSQL on docker

bot solutions seemed viable but I was able to come up with the solution thanks to your suggestion since I noticed my postgre container was not routed properly (is that the way to say it?)

Anyway, I would like to leave it open for a couple of days in case someone has a more direct solution

[Cesars-dev]

Thanks for the effort, I jut found same inconsistencies trying to install local LLM’s and I believe it has to do with my mac being out of date

Currently have Mac os 12.7 and I faced similar issues trying to download packages via home brew

Basically I need a newer OS, i I will try to work like this for now or will upgrade to windows 11, I dont like windows but my mac is 10 years old lol