set session_replication_role = 'replica'; about lireddit HOT 9 CLOSED

Will do, thanks, Ben :)
p.s. just want to say that I have been subscribed to your channel for years now, even though you made a video on how you sleep enough for dev productivity and have time and motivation for everything I want to tell you that it still amazes me that you can create so many YT videos and share all that knowledge/experience.
Stay safe and keep up the good work.

from lireddit.

2 fixes I found. #1 is probably the most preferable

1. make sure the postgres user has superuser privileges - ALTER USER myuser WITH SUPERUSER;
2. in the mikro-orm.config, in the migrations section, add the disableForeignKeys option
   export default {
   migrations: {
   path: path.join(__dirname, './migrations'),
   pattern: /^[\w-]+\d+.[tj]s$/,
   disableForeignKeys: false,
   },
   ...

from lireddit.

did you try deleting the dist folder and rebuilding the project?

from lireddit.

Yes, still the same output, even cloned your branch, run your code with my small db changes and still the same issue :(
Probably something wrong with my postgresql :|

from lireddit.

just saw this

from lireddit.

try creating a new postgres user and give it permissions to the db https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e

from lireddit.

@benawad sorry if I am boring, I got it to work
In case anyone else is having this issue in the future, my solution was that in the mikro-orm.config file
in the DB configuration, I put my default root user as my Postgres user and it works


Something with the permissions/roles was off , maybe it is just my local machine

from lireddit.

@kurtzilla Looks like a clean and elegant solution, thanks for the info

from lireddit.

@kurtzilla Thanks! the #1 worked for me.

from lireddit.