pg_dump -Dn databasename > mybackupdatabasename.sql
to restore:
create databasename_new
psql -e databasename_new < mybackupdatabasename_new.sql
more information man pg_dump
regards
On Fri, 2 Feb 2001 vlal(at)ideay(dot)net(dot)ni wrote:
{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.
{
{
{