From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: lists@itech7.com
To: pgsql-admin@postgresql.org
Subject: Re: Backups
Date: Sat, 20 Feb 2010 11:44:27 -0600
Message-ID: <4B7FCB1B020000250002F40E@gw.wicourts.gov> (raw)
Nilesh Govindarajan wrote:
> I want a script to backup all databases table by table in different
> .sql files.
My first question would be whether they all need to be from the same
point in time? Is it a requirement that if they were all restored
they would provide a database with referential integrity, etc.? Or
is it OK if each table represents a different moment in time?
Either way, you probably want pg_dump. If you don't care about
having these separate files to collectively provide a consistent
image of a moment in time, or you can prevent any modifications while
you are running a set of backups, you could use pg_dump with the -t
option. Otherwise you probably need to use pg_dump (or pg_dumpall)
and parse the output to split it into the required files. Or you
might be able to do pg_dump to the custom format and extract each
table into a separate file.
> Also since it is a script, there has to be some role having read
> access to all tables on all databases. How to grant that ?
If you don't want to use the database superuser and don't already
have some other role with the appropriate rights, you will have to
grant them. It's hard to provide details without more information
about what's already there.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, lists@itech7.com
Subject: Re: Backups
In-Reply-To: <4B7FCB1B020000250002F40E@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox