In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (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?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
