Arun, > i have a postgresql database in one system and want to > transfer > the same to another system. i am not finding a way to transfer this > database from one system to another.if i transfer the file in > /var/lib/pgsql/libdatabase them it gives error.how shall i transfer > database. > another thing. how to take up backups of the database on the > system. > pls help me as i am new to postgresql > thanking you Both are accomplished the same way. Please read "pg_dump" and "pg_dumpall" in the online documentation, under "command-line utilities". -Josh
