Re: restore multiple tables postgres

Поиск
Список
Период
Сортировка
От akp geek
Тема Re: restore multiple tables postgres
Дата
Msg-id g2q2024a9fb1004140903qff6b3246p503830613e69801d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: restore multiple tables postgres  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Список pgsql-general
Thanks for guidance. If you could share the file, I appreciate it

Regards

On Wed, Apr 14, 2010 at 11:27 AM, Rob Richardson <Rob.Richardson@rad-con.com> wrote:
I often have to create test copies of a production database.   The database has several large tables that contain historical data that is not needed for our system to run, and just wastes time doing backups and restores.  I created two batch files, one for backing up and the other for restoring.  The backup file begins with a command to backup the scheme of the database, and then there is a series of commands to backup the tables I need, once command per table.  The restore file works the same way.  I think a similar idea would help you.  You could trim the batch files (or at least the restore batch file) to give you only the tables you need.
 
If you want, I'd be happy to E-mail you the batch files.
 
RobR


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: auto vacuum
Следующее
От: Jesus arteche
Дата:
Сообщение: autoscale cluster