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