Nuno Ferreira <nunoadferreira@gmail.com> wrote:
> 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?
You can do (and have to do) that while the database is up and running
with pg_dump and (on the destination) pg_restore or psql. Please read
the documentation for more information here:
http://www.postgresql.org/docs/9.1/interactive/backup.html
You CAN'T copy&paste the files!
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°