From: | robert(dot)gravsjo(at)nsgroup(dot)net () |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Consulta about BACKUP DB |
Date: | 2001-02-02 16:50:55 |
Message-ID: | 95eohe$1f14$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In article <Pine(dot)LNX(dot)4(dot)21(dot)0102021023230(dot)20043-100000(at)ideay(dot)net(dot)ni>,
<vlal(at)ideay(dot)net(dot)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(dot)gravsjo(at)nsgroup(dot)net
System developer Cell: +46 (0)708 72 00 46
Work: +46 (0)480 42 46 16
NS Group www.nsgroup.net
From | Date | Subject | |
---|---|---|---|
Next Message | jcmd@acer.com.mx | 2001-02-02 17:11:48 | Re: Consulta about BACKUP DB |
Previous Message | Leland V. Lammert | 2001-02-02 16:29:58 | Re: Dumb Question |