postgres backup - data empaty
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:
9 Replies
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.ID:ffe282e7-d7f6-4e3e-818e-c3b6963a4a0d
what was the filesize of the dump file?
Hi, @Brody. is this size
are you sure al the credentials are correct when using pg_dump and re_restore?
this was that, I used for pg_dumb
are you able to inspect the dump file for the desired data?
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.
