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