Hello,
You could use:
# pg_dump database > backup_file
So, on the another system:
# psql -d database -f backup_file
I think it will solve your problem...
See ya,
Marcelo Pereira
-- Remember that only God and Esc+:w saves.
__
(_.\ Marcelo Pereira |
/ / ___ |
/ (_/ _ \__ Matematica/99 - IMECC |
_______\____/_\___)___Unicamp_______________/
--- arun kv, with his fast fingers, wrote:
:> hello sir,
:> 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
:> Arun
:>
:>
:> ---------------------------(end of broadcast)---------------------------
:> TIP 4: Don't 'kill -9' the postmaster
:>