postgresql db take backup and restore with data

Question

i would like to take backup and restore of my postgresql database automatically.

i have below bat commands to take back up of my database

F:
cd F:\softwares\postgresql-12.1-3-windows-x64-binaries\pgsql\bin
pg_dump.exe -U postgres -s fuelman > E:\fuel_man_prod_backup\prod.sql
cmd /k

but i am getting

pg_dump: error: too many command-line arguments (first is "-s")

also i need to take both schema structure with data.

Edit :- removed password -W

-s means schema only. And when only have a backup of the schema, you don't have the data. And it looks like a \ is missing in your command, but I'm not familiar with Windows — Frank Heikens, Dec 29 '22 at 13:59

score 1 · Accepted Answer · answered Dec 29 '22 at 14:13

1

"Too many command line" probably is due to -W option; the string "postgres" after -W is interpreted as db name, so following -s gives error. Anyway, when running pg_dump from a script you must not use -W; use .pgpass file or set PGPASSWORD environment variable (look at pg_dump: too many command line arguments for more details).
As for Frank Heikens comment, if you need to dump both object definition and data, avoid -s option. pg_dump documentation is quite clear.

answered Dec 29 '22 at 14:13

gile

yeah i removed -w and now it takes dump of object definition, but i need to enter password manually, is there a ways to take password input from cmd automatically? – pappu_kutty Dec 29 '22 at 14:19
ok got it .pgpass would work.. – pappu_kutty Dec 29 '22 at 14:21
As already written: use .pgpass file or set PGPASSWORD environment variable – gile Dec 29 '22 at 14:21

1 Answers1