createdb --template=sourcedatabase newdatabase will also work (and
probably work faster) if you can kick everyone out of sourcedatabase and
you're doing all this on one machine.
On Sun, Jan 29, 2006 at 07:31:29PM -0800, Uwe C. Schroeder wrote:
> pg_dump -h sourcehost -U sourceuser sourcedatabase |
2006/1/30, Uwe C. Schroeder <[EMAIL PROTECTED]>:
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 po
pg_dump -h sourcehost -U sourceuser sourcedatabase | psql -h desthost -U
destuser destdatabase
you may have to add a parameter for the password depending on your pg_hba.conf
settings. Both databases need to be network enabled and have a pg_hba.conf
entry for the machine you're running this comm
Hi all,
I am looking for a way to copy whole database to another existing
database.
Any suggestions ?
-
Best regards,
Krzysztof Szadkowski
---(end of broadcast)---
TIP 9: In versions below 8.
