Can't run sql query trying to create a postgreSQL Database | Railway | Page 1

dense starBOT Apr 12, 2023, 11:16 PM

#

Project ID: 4b8c2a06-3558-485f-a3a2-ea8afa7e9787

#

You might find these helpful:

mint ruin Apr 12, 2023, 11:21 PM

#

4b8c2a06-3558-485f-a3a2-ea8afa7e9787

mint ruin Apr 12, 2023, 11:41 PM

#

grizzled kernel Apr 13, 2023, 12:24 AM

#

that is absolutely not a valid query

mint ruin Apr 13, 2023, 12:45 AM

#

now im doing it one by one and it running okay

#

until this line

#

COPY public.categorias (id_categoria, nombre) FROM stdin; 1 Dormitorio 2 Comedor 3 Cocina 4 Oficina 5 Living 6 Infantil - syntax error at or near "1"

#

COPY public.categorias (id_categoria, nombre) FROM stdin;
1 Dormitorio
2 Comedor
3 Cocina
4 Oficina
5 Living
6 Infantil
.

mint ruin Apr 13, 2023, 12:45 AM

#

mint ruin COPY public.categorias (id_categoria, nombre) FROM stdin; 1 Dormitorio 2 Comedor...

this is the error

#

im pastingit from my sql file so i dont undertaand whatsa wrong?

grizzled kernel Apr 13, 2023, 12:50 AM

#

that's not a valid query either

mint ruin Apr 13, 2023, 12:50 AM

#

why?

#

im taking it from the query that was made automatically by doing a backup from postgresql

grizzled kernel Apr 13, 2023, 12:53 AM

#

you want to to use pg_restore

mint ruin Apr 13, 2023, 12:53 AM

#

what do you mean?

grizzled kernel Apr 13, 2023, 12:53 AM

#

https://www.postgresql.org/docs/current/app-pgrestore.html

mint ruin Apr 13, 2023, 12:54 AM

#

ahhhh yes!! is did a dump

#

so the dump generated me an script with the full query

#

So now i need to do a restore in the query?

grizzled kernel Apr 13, 2023, 12:55 AM

#

did you use pg_dump?

grizzled kernel Apr 13, 2023, 12:55 AM

#

grizzled kernel did you use pg_dump?

?

mint ruin Apr 13, 2023, 12:56 AM

#

Yes

grizzled kernel Apr 13, 2023, 12:56 AM

#

then use pg_restore

mint ruin Apr 13, 2023, 12:56 AM

#

i was checking

#

and that command will make me another file with a different query?

grizzled kernel Apr 13, 2023, 12:57 AM

#

no, it restore the database from the dump

grizzled kernel Apr 13, 2023, 12:57 AM

#

grizzled kernel <https://www.postgresql.org/docs/current/app-pgrestore.html>

^
read please

mint ruin Apr 13, 2023, 12:59 AM

#

okay, cool i will check it now thanks for the help 😉

mint ruin Apr 13, 2023, 1:22 AM

#

pg_restore -U <Username> -d <database_name> <file_path>.sql

#

is this correct doing it from my pc?

#

DATABASE_URL
PGDATABASE = database_name?
PGHOST
PGPASSWORD
PGPORT
PGUSER = Username?

grizzled kernel Apr 13, 2023, 1:37 AM

#

https://simplebackups.com/blog/postgresql-pgdump-and-pgrestore-guide-examples/

mint ruin Apr 13, 2023, 2:39 AM

#

C:\Program Files\PostgreSQL\15\bin>pg_restore -U postgres -d railway mueblesmayo.sql
pg_restore: error: input file does not appear to be a valid archiver

grizzled kernel Apr 13, 2023, 2:42 AM

#

oh you have a .sql file, in that case you want psql

#

https://www.postgresql.org/docs/current/app-psql.html

mint ruin Apr 13, 2023, 3:01 AM

#

i dont really understand what are the steps i need to follow 😦

#

I have my database created in my pg admin 4 in my computer

#

i did a pg_dump in my computer so now i have a file with the sql code to create that database

#

but now, what i need to do to create that database in railway

grizzled kernel Apr 13, 2023, 3:05 AM

#

you have a .sql file, so you need psql

#

maybe watch some youtube videos?

mint ruin Apr 13, 2023, 3:08 AM

#

I solved it, sorry for bothering i was just mixing all

#

the way you told me was ok, thanks again and sorry

#Can't run sql query trying to create a postgreSQL Database