Re: Copy database to another machine
| От | Thom Brown |
|---|---|
| Тема | Re: Copy database to another machine |
| Дата | |
| Msg-id | CAA-aLv4yDS4=PVAmx2XDJ1_B8yyVbrojb2J33ftHxoxdZ+=yVw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Copy database to another machine (Nuno Ferreira <nunoadferreira@gmail.com>) |
| Ответы |
Re: Copy database to another machine
|
| Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: