Re: backup postgres database

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
:>