From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
---|---|
To: | "Andreas" <maps(dot)on(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Need help how to manage a couple of daily DB copies. |
Date: | 2013-10-25 02:06:25 |
Message-ID: | 07e1ffe89c03de19eb5b928311710ea7.squirrel@sq.gransy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 25 Říjen 2013, 3:53, Andreas wrote:
> Hi,
>
> I'd like to set up a DB-Server that keeps copies of our productive db
> for an external db-assistant.
> He should prepare chores on the test-server and mail the sql scripts to
> me.
> I'll look over those scripts and run them against the productive db
> myself.
>
> So I'd like to have a daily cron job dump the main db, rename the
> test-db to something with a date in it.
> Like test_db --> test_db_20131024
> Create a new test_db and import the dump of the main db.
>
> So far no problem but how could I limit the number of test_dbs to 5?
> I'd like to keep those test_dbs 5 days and then drop them.
Hi,
I assume that's something that needs to be done by your script, there's
certainly nothing in PostgreSQL itself to do that.
You may for example run a daily cron script that lists all databases on
the test server, parses the database name and drops those older than 5
days.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-10-25 02:07:24 | Re: Need help how to manage a couple of daily DB copies. |
Previous Message | Michael Paquier | 2013-10-25 02:05:15 | Re: Is there something like a limited superuser to give to a db-assistant? |