How to resolve Pups exec errors during Discourse bootstrap

[RGJ (Richard - Communiteq)]

@Thomas_Rother

therefore name: redis and alias: data

I still don’t understand why you rename the one and not the other.
But it’s likely not your problem anyway, since

@RGJ

One very valuable insight that I just had is that hotlinked_media_status is simply the first thing happening in the restore file. If you remove it manually in the existing database the restore will fail on the next statement (CREATE TABLE public.admin_notices).

Most of the time this indicates a permissions problem.

Make sure the user Discourse uses to connect to your database has full rights on your database, including the ability to enumerate tables. Preferably make it the owner.

[Thomas_Rother (Thommie Rother)]

problem solved.

CREATE EXTENSION hstore;
CREATE EXTENSION pg_trgm;

was missing on the new database. Therefore the initial creation of the database on the external server failed. Thanks @Falco