PostgreSQL Administration - Re: Copy database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Copy database

Christian Sengstock

2006-01-30, 3:23 am

2006/1/30, Uwe C. Schroeder <uwe@oss4u.com>:
[color=darkred]
>
>
>
> On Monday 23 January 2006 00:49, Krzysztof Szadkowski wrote:

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

Sponsored Links