בעיה במיזוג שני פורומים

[cocococosti (Constanza Abarca)]

@McFly

The error is psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

Probably, psql is trying to use your current system user (root) which doesn’t exist in Postgres. You may need to specify the user when running psql: psql -U postgres

And then check this step:

@neil

If you’re running the import in an official Docker container (recommended), you will need to reset the postgres password to provide it to the script, otherwise you may encounter an error that the postgres user cannot access the database.

To change the password:

sudo -u postgres psql
\password postgres
(enter the new password)
\q