On Fri, Jun 17, 2005 at 01:21:13PM +0100, Richard Huxton wrote: > What's the problem with creating a superuser called "postgres" on both > machines? Or you could choose not to dump (or restore) ownership > information (--no-owner). The section of the manuals you want is > "PostgreSQL Client Applications" - it covers all the options. > I'd use pg_dump anyway - unless you have hundreds of databases, it makes > it easier to keep by backups separate. I will do that then. Thanks. -- Cheers, Jacob Atzen ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match