Skip site navigation (1) Skip section navigation (2)

Re: Copy database to another machine

From: jjurban <jjurban(at)attglobal(dot)net>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Nuno Ferreira <nunoadferreira(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy database to another machine
Date: 2011-10-26 16:54:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Thom Brown wrote:
> On 26 October 2011 14:38, 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?
> 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 

This is on eCS (OS/2) machines.

I have done this many times without problems.

Am I doing something I shouldn't?


In response to


pgsql-novice by date

Next:From: jjurbanDate: 2011-10-26 17:10:13
Subject: Re: Copy database to another machine
Previous:From: Thom BrownDate: 2011-10-26 16:46:06
Subject: Re: Copy database to another machine

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group