On Wed, Mar 30, 2011 at 2:56 PM, Mike Orr <sluggoster@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
