| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Mike Orr <sluggoster(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore |
| Date: | 2011-03-30 21:55:05 |
| Message-ID: | BANLkTikJFWoPBDJ39YffhiAGeXMGaR00Tg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 30, 2011 at 2:56 PM, Mike Orr <sluggoster(at)gmail(dot)com> wrote:
> I'm converting a MySQL webapp to PostgreSQL. I have a backup server
> which is refreshed twice daily with mysqldump/mysql and has a
> continuously-running copy of the webapp. I want to replicate this with
> pg_dump/pg_restore. Ideally I'd like to restore just a few tables,
> without stopping the webapp and closing/reopening its connections. Is
> this possible with pg_restore?
>
Would replication of just those tables give you what you want? If so
look into slony which allows you to replicate individual tables.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Orr | 2011-03-30 23:08:36 | Re: pg_restore |
| Previous Message | John R Pierce | 2011-03-30 21:36:50 | Re: pg_restore |