Skip site navigation (1) Skip section navigation (2)

Need help on how to backup a table

From: ajcity <victor(dot)aluko(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Need help on how to backup a table
Date: 2008-03-28 06:05:02
Message-ID: 16346381.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-general
 Hi all,
  I am trying to backup a large table with about 6 million rows. I want to
export the data from the table and be able to import it into another table
on a different database server (from pgsql 8.1 to 8.2). I need to export the
data through SQL query 'cause I want to do a gradual backup.
  Does pgsql have a facility for this?
  Thanks in advance for your reply.

   Victor
-- 
View this message in context: http://www.nabble.com/Need-help-on-how-to-backup-a-table-tp16346381p16346381.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Responses

pgsql-general by date

Next:From: Greg SmithDate: 2008-03-28 06:26:46
Subject: Re: PostgreSQL Replication with read-only access to standby DB
Previous:From: Swaminathan SaikumarDate: 2008-03-28 05:29:37
Subject: Re: Using tables in other PostGreSQL database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group