Nuno Ferreira <nunoadferreira(at)gmail(dot)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:
You CAN'T copy&paste the files!
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°
In response to
pgsql-novice by date
|Next:||From: Thom Brown||Date: 2011-10-26 16:46:06|
|Subject: Re: Copy database to another machine|
|Previous:||From: Dagan||Date: 2011-10-26 14:10:43|
|Subject: Re: Debian upgrade from 9.0 to 9.1?|