mushfiq wrote:
is it not harmful? i do not want to destroy my existing one.
It harmless during the backup; it won't drop anything. Only when you restore the backup will it drop the existing tables. Feel free to omit the '-c' if that's not what you want.
Quote:
where this file will be saved ? in tmp ?
It will be saved to the current directory. If you want to save elsewhere, simply change the filename 'pgsql-backup.gz'.
Quote:
i test the command without -c it still shows pin-back.gz: permission denied
That means you don't have permission to write to the current directory. Try writing the file to a directory that you
do have write access to. I have a feeling you're logged in as the 'postgres' user; this is not necessary, you should be logged in as your usual day-to-day user.