On Wed, Mar 30, 2011 at 2:56 PM, Mike Orr <sluggoster@gmail.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.