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 command on. 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 ? > > --------------------------------------------- > Best regards, > Krzysztof Szadkowski > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- UC -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax: +1 707 568 6416
