Re: Consulta about BACKUP DB

In article <Pine.LNX.4.21.0102021023230.20043-100000@ideay.net.ni>,
    <vlal@ideay.net.ni> writes:
> Hi all,
>
> I going to cahge machine, but I need to make backup of my database, my
> version of postgresql is: 6.5.3 now my version will be 7.0.
>
> How can I to make the backup of tables, index and data?
>
> Thanks in advanced.
>
>

Try
pg_dump databasename > datbase_dumpfile
to dump the database. Then create an empty database on the new server
and run
cat database_dumpfile | psql -d newdatabasename

I don't know what os your on, but this works for me on linux (SuSE 7.0).

regards
robert gravsjo

--
  Robert Gravsjö      robert.gravsjo@nsgroup.net
  System developer    Cell: +46 (0)708 72 00 46
                      Work: +46 (0)480 42 46 16
  NS Group            www.nsgroup.net