[vPostMaster] How to move to a new server?

[Jonathan Wilson]

On Thursday 01 November 2007 16:14, Sean Reifschneider wrote:
> On Thu, Nov 01, 2007 at 04:12:41PM -0500, Jonathan Wilson wrote:
> >Where is the "backup and recovery recipe"? Maybe I'm just missing it but I
> >don't see it in the old package's docs and I don't see it on the web site.
>
> http://www.tummy.com/Products/vpostmaster/recipes/
>
> The last two items there.
>
> Sean

Thanks. FYI if you follow the directions on the restore page, the PostresQL DB 
has all the structure but is devoid of users and domains.

So I ended up dropping the "new" database, running "su postgres -c pg_dumpall 
>mail.pgsql" as it suggests on the back-page, and restoring that dump on the 
new server with "createdb vpostmaster" and psql vpostmaster < mail.pgsql.

After that, the vpostmaster interface gave tons of "cannot connect" warnings, 
so I re-ran the setup script /usr/lib/vpostmaster/bin/setup-debian and 
everything seems to be ok now.

	JW

-- 

----------------------
System Administrator - Cedar Creek Software
http://www.cedarcreeksoftware.com