On Thu, 11 Sep 2003, Caroline Yong wrote:
> Is there a way to replicate one-off(a copy of
> duplicate) of an existing Postgres database.
>
> regards,
> caroline
There's obviously the pg_dump utility (or pg_dumpall which also gets all the
global info like db users). You could also try:
createdb -T old-db new-db
as an interesting exercise, if you just want another copy in the same
cluster. I've not done that myself but I don't see why it wouldn't work,
someone else might know differently.
--
Nigel Andrews