| From: | Christian Sengstock <csengstock(at)gmail(dot)com> |
|---|---|
| To: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, Krzysztof Szadkowski <kszadkow(at)eldip(dot)lodz(dot)pl>, pgsql-admin-owner(at)postgresql(dot)org |
| Subject: | Re: Copy database |
| Date: | 2006-01-30 08:04:49 |
| Message-ID: | febbf1590601300004h30e62be1k@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
2006/1/30, Uwe C. Schroeder <uwe(at)oss4u(dot)com>:
>
>
>
> On Monday 23 January 2006 00:49, Krzysztof Szadkowski wrote:
> > Hi all,
> >
> > I am looking for a way to copy whole database to another existing
> > database.
> > Any suggestions ?
Sometimes you want to copy the whole DBMS to another machine where the same
postgres version is running. You can just copy the ./data directory, check
the permissions (chown -R postgres ./data) and run postmaster with this data
directory (postmaster ... -d ./data).
Note: Like that, you can't copy a certain database. You have to use the same
postgres version for that...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh O'Brien | 2006-01-30 14:47:05 | upgrade issue |
| Previous Message | Uwe C. Schroeder | 2006-01-30 03:31:29 | Re: Copy database |