postgres backup - data empaty | Railway | Page 1

small solstice Jun 26, 2023, 3:41 PM

#

Hi, I made a copy of the database using the command: "pg_dump -U PGUSER -h PGHOST -p PGPORT -W -F t PGDATABASE > YOUR_FILENAME_HERE". When I restore it locally and query a table, the query comes up empty:

kindred auroraBOT Jun 26, 2023, 3:41 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

sinful foxBOT Jun 26, 2023, 3:41 PM

#

Please provide your project ID or reply with N/A. Thread will automatically be closed if no reply is received within 10 minutes. You can copy your project's id by pressing Ctrl/Cmd + K -> Copy Project ID.

small solstice Jun 26, 2023, 3:56 PM

#

ID:ffe282e7-d7f6-4e3e-818e-c3b6963a4a0d

velvet matrix Jun 26, 2023, 4:32 PM

#

what was the filesize of the dump file?

small solstice Jun 26, 2023, 5:02 PM

#

velvet matrix what was the filesize of the dump file?

Hi, @velvet matrix. is this size

velvet matrix Jun 26, 2023, 5:09 PM

#

are you sure al the credentials are correct when using pg_dump and re_restore?

small solstice Jun 26, 2023, 7:27 PM

#

this was that, I used for pg_dumb

velvet matrix Jun 26, 2023, 7:40 PM

#

are you able to inspect the dump file for the desired data?

small solstice Jun 26, 2023, 8:02 PM

#

thank you very much, I missed to put password to postgres of localhost; since it contains all the credentials that I needed, I can already see the backup in my local machine.

#

#postgres backup - data empaty