Re: Copy database to another machine

Thom Brown wrote:
> 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.
>
I have zipped the contents of PGSDATA (the entire database)  to a zip
file, copied that file to a memory stick, then unzipped it to another
machine.

This is on eCS (OS/2) machines.

I have done this many times without problems.

Am I doing something I shouldn't?

John