Need help how to manage a couple of daily DB copies.

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Need help how to manage a couple of daily DB copies.
Date: 2013-10-25 01:53:14
Message-ID: 5269CF0A.2070601@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 2013-10-25 01:53:16 Is there something like a limited superuser to give to a db-assistant?
Previous Message Alban Hertroys 2013-10-24 21:18:36 Re: Replication and fsync