On 26 October 2011 14:38, 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?
No, you can't copy and paste the files, but you can do it in one step:
pg_dump -t table_to_dump source_database_name | psql destination_database_name
Assuming the table does't already exist in the destination, it will
create and populate the table in the destination database.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company