Hello, i have a postgres db that is over 7gig. i want to make a backup but the pg_dump command generate a file that is only 301mb in size. here is the command i am running. please help.
PGPASSWORD="mypassword" pg_dump --host=myhost --port=myport --username=myuser --format=c --file=backupdate +%F-%H%M.dump mydb
That will only backup the database mydb. If you have other databases, you will need to back those up individually.
"mydb" is only a place holder i use to ask this question. My actual db is 7gig in size but dump just generates a file that is 301mb inn size. i need to dump the whole 7gig of data
I think you should be able to look at the dump to see whats missing
xbtms
|
24
posts
|
glenn
|
9718
posts
|
PythonAnywhere staff
|
