Il 26/10/2011 15:38, Nuno Ferreira ha scritto:
> Good afternoon,
>
> I'm trying to copy one database from one machine to another. How can I
> do it?
> Can I just simply copy and paste the files? I need to close the
> database first or I can copy the files with it open?
>
> -
I'm a noob too, but I think I can help in this case.
I've moved from a server to another.
For me pg_dumpall (official postgre manual page 480) went fine.
Actually it copies the whole cluster at once, I had three little
databases and their users (roles) moved from a 32bit machine running
postgre 9.0 to a 64bit one running 9.1.
Hope this helps