How to fix pg_restore error in Postgres 2023 

This isnt a fix. you just typed the sql in the query tool. What if i want the file to run on its own.

Thank you, that was helpful. I was trying to restore the Pagila database. It was mostly trial and error in my case. First, I had to run the pagila-schema script; then, the pagila-insert-data one.

Heyy i am trying to upload a data base but the error is invalid sequence for encoding could you ple help

Yo tambien tengo el mismo problema al hacer restore, pero como esta tambien encriptado al pasarlo al visual studio code tambien me aparece encriptado. Tienes de casualidad más o menos cómo sería el proceso para poder hacer el restore para cuando esta encriptado

someone know which extension for vs code can i downlowad to can see the sql code?

its showing runtime error. What should i do?

in my case the type is showing import data rather than restore. does it follow the same procedure ?

it would've bee great if i could see what you wrote at the right end of the screen but i can't and there's no voice explanation.....thanks anyway

Hello, very good, I was watching your video and it is the same error but when I do what you did, enter with a text editor, copy it and enter option query tool and paste the programming language and give it pley, it gives a syntax error, I am stuck with that, let's see. if you can help me.

Thank you!

Hello, I tried to do what you indicated in the video but it gives me the following syntax error: syntax error at or near "1" LINE 1159: 1 MAIN Localssss Yes 1 2017-03-31 16:05:17-05 ^ SQL state: 42601 Character: 25212

file type not supported. Help me please?

fiz dessa forma e deu certo realizar a correção no meu pc

I have no idea what your solution was.

Thanks! 👏