[ph-linux-newbie] postgres database migration

[ph-linux-newbie] postgres database migration: ">

gusto kong i transfer ang postgre database file ko sa >kabilang unit, i know it is possible, kaya lang di ko >pa alam kung paano gagawin. > >can anyone help paano ko ma transfer ang database file >ko. ========================================================= try mo (as postgres user):
1] pg_dump db_name | gzip > filename.dump.gz #dump database
2] scp filename.dump.gz new_server:. #copy file to new_server
3] createdb db_name
4] gunzip -c filename.dump.gz | psql db_name #upload"