On 14.06.2006, at 14:12 Uhr, A. Kretschmer wrote:
Is there an easy way to copy the content including the table
structure,
indexes and so on from one db to another?
Create the new db with the old db as template.
Thanks, but as far as I can see, I have to disconnect all clients
from the production db to do this and this wasn't an option.
I forgot to mention that. The pg_dump way is fine for me.
cug
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster