KhodeN · January 28, 2016 09:37
diff --git a/dump.sh b/dump.sh
 #!/bin/bash

 now=$(date +"%Y-%m-%d_%H:%M")
 cd /projects/datamarket
 pg_dump -U postgres dm | gzip > backups/dm_dump_$now.sql.gz

 # use this row to backup every hour
 # crontab -e
 # * */1 * * * /projects/datamarket/dump.sh

 # set password for ~/.pgpass (chmod 600)
 # localhost:5432:*:postgres:myPassword
	#!/bin/bash

	now=$(date +"%Y-%m-%d_%H:%M")
	cd /projects/datamarket
	pg_dump -U postgres dm \| gzip > backups/dm_dump_$now.sql.gz

	# use this row to backup every hour
	# crontab -e
	# * /1 * * /projects/datamarket/dump.sh

	# set password for ~/.pgpass (chmod 600)
	# localhost:5432:*:postgres:myPassword