Re: easy way to copy all DBs and users on a server

In an attempt to throw the authorities off his trail, jtnews@exciteworks.com (exciteworks hosting) transmitted:
> Is there an easy way to copy all DBs and users on a server to another
> server?
>
> I need to get an exact duplicate.

How exact is "exact"?

One notion of "exact" would involve stopping the database, building a
tarball that contains all of the data, copying it over and extracting
it.

Another would involve using "pg_dumpall" to dump all of the databases
and users and generating the SQL required to recreate it all.

If you're not sure how those approaches' differences would affect your
system, then it's pretty likely that pg_dumpall is the preferable
answer...
--
output = reverse("gro.gultn" "@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/rdbms.html
If you've done  six impossible things  this morning, why not  round it
off  with breakfast  at  Milliways, the  Restaurant at the  End of the
Universe?