Creating backup of postgresql database can't find file

Question

I am on Ubuntu 18.04 and I am using Postgresql database. I ran the command

pg_dump dbname > db.bak

but when I do this, it outputs nothing. I tried to supply a path to the backup and the file does not show up.

My exact commands ran are:

sudo -i -u postgres
psql
pg_dump dbname > db.bak
pg_dump dbname > /db.bak

I am also running this from a venv if that makes any difference. — Halloween
– Halloween, Commented May 5, 2020 at 14:12
Oh, can you run the command from the command prompt, and not from within psql? — mechanical_meat
– mechanical_meat, Commented May 5, 2020 at 14:14
From within psql you can type \! pwd to see what the current directory is. — mechanical_meat
– mechanical_meat, Commented May 5, 2020 at 14:15
When running outside of psql I get "connection to database "mydb" failed; FATAL: role "john" does not exist. — Halloween
– Halloween, Commented May 5, 2020 at 14:19
the directory is /var/lib/postgresql. I have searched in and I don't see any backups — Halloween
– Halloween, Commented May 5, 2020 at 14:20

Halloween · Accepted Answer · 2020-05-05 14:31:21Z

2

pg_dump -U myuser -h localhost mydb > db.sql

This worked for me.

answered May 5, 2020 at 14:31

Halloween

4185 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

where is the back located ?