Backup file is automatically created by the script written on production server
Backup file is automatically created by the script written on production server and then this backup is updated on the standby server through the script.
there is no direct command to take the backup but i am sending you the link
which can probably help u.
Again, WHAT was the specific syntax that YOU used ??? the pg_dumpall?
Rather than create a single huge backup file with the entire server's contents dumped there, it's often more 'friendly' to create individual database backups.
If it's a single file, copy the backup file to a working file, then delete everything in front of the first portion of text referencing the database name in question, and everything after the last line of SQL that references your target database.
Then, execute the backup SQL work file, using pgadmin or pSQL.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert