https://forum.postgresql.org.pl/viewtopic.php?id=1919 Mon, 13 Jan 2014 08:15:43 +0000 PunBB https://forum.postgresql.org.pl/viewtopic.php?pid=4969#p4969 %s/system.%s.gz" % (port, backupdir, date)) for base in os.popen(get_db_names).readlines(): log("dump rozpoczety dla bazy:%s" % base) base = base.strip() fulldir = backupdir + base if not os.path.exists(fulldir): os.mkdir(fulldir) filename = "%s/%s-%s.sql" % (fulldir, base, date) os.popen("nice -n 19 pg_dump -C -F c -U%s -p%s %s | gzip -9 -c > %s.gz" % (username, port, base, filename)) log("dump %s zakonczony" % base) log("Backup zakonczony.") To usuwa stare backupy. bash-4.1$ cat /var/lib/pgsql/9.1/remove_old_backup.sh #!/bin/bash cd /var/backup/pgdb/ find . -mtime +1 | xargs rm -Rf bash-4.1$]]> Mon, 13 Jan 2014 08:15:43 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4969#p4969 https://forum.postgresql.org.pl/viewtopic.php?pid=4948#p4948 Fri, 13 Dec 2013 20:58:53 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4948#p4948 https://forum.postgresql.org.pl/viewtopic.php?pid=4947#p4947 . To nawet w większości nie są pytania o postgresa tylko o system operacyjny, linuksa, edytor tekstu.]]> Fri, 13 Dec 2013 20:42:40 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4947#p4947 https://forum.postgresql.org.pl/viewtopic.php?pid=4946#p4946 Fri, 13 Dec 2013 20:35:59 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4946#p4946 https://forum.postgresql.org.pl/viewtopic.php?pid=4945#p4945 Fri, 13 Dec 2013 20:35:57 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4945#p4945 https://forum.postgresql.org.pl/viewtopic.php?pid=4944#p4944 Fri, 13 Dec 2013 20:34:30 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4944#p4944 https://forum.postgresql.org.pl/viewtopic.php?pid=4943#p4943 Fri, 13 Dec 2013 20:29:33 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4943#p4943 https://forum.postgresql.org.pl/viewtopic.php?pid=4942#p4942 Fri, 13 Dec 2013 20:28:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4942#p4942 https://forum.postgresql.org.pl/viewtopic.php?pid=4941#p4941 Fri, 13 Dec 2013 20:21:14 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4941#p4941 https://forum.postgresql.org.pl/viewtopic.php?pid=4940#p4940 Fri, 13 Dec 2013 20:19:42 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4940#p4940 https://forum.postgresql.org.pl/viewtopic.php?pid=4939#p4939 Fri, 13 Dec 2013 20:08:28 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4939#p4939 https://forum.postgresql.org.pl/viewtopic.php?pid=4938#p4938 Fri, 13 Dec 2013 20:08:26 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4938#p4938 https://forum.postgresql.org.pl/viewtopic.php?pid=4937#p4937 Fri, 13 Dec 2013 20:06:46 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4937#p4937 https://forum.postgresql.org.pl/viewtopic.php?pid=4936#p4936 Fri, 13 Dec 2013 20:04:34 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4936#p4936 https://forum.postgresql.org.pl/viewtopic.php?pid=4935#p4935 Fri, 13 Dec 2013 20:02:11 +0000 https://forum.postgresql.org.pl/viewtopic.php?pid=4935#p4935