On Wed, 2005-03-30 at 14:28, phil campaigne wrote: > Hi All, > I want to move my development database (7.2.3) to my production server > but the production server database has a different name. > What is the procedure for restoring a database pg_dump to another > machine with a different database name?
pg_dump -h source_host source_dbname |psql -h dest_host dest_dbname ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
