Copying data from a table to another database - Mailing list pgsql-general

From Pedro Doria Meunier
Subject Copying data from a table to another database
Date
Msg-id 1211714670.10985.10.camel@213-190-214-90-cmts01.netmadeira.com
Whole thread Raw
Responses Re: Copying data from a table to another database  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Copying data from a table to another database  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Re: Copying data from a table to another database  (Reece Hart <reece@harts.net>)
Re: Copying data from a table to another database  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
Hi all,

This is perhaps a very 'newbie' question but for the life of me, I can't
see a way to do it without resorting to programming... (blush)

The thing is:
I have a table that acts as a historic for some devices activity.
Now I've migrated the entire 'shebang' to another server and need to
update the history table on the new server with data from the old server
for every different record.
As the table on the new server grows exponentially (already nearing 1M
records) I need to do this asap unless I want the entire thing to take
forever... (sweat)

Could someone please lend me a hand here?

Already thankful for any insight,

--
Pedro Doria Meunier <pdoria@netmadeira.com>

Attachment

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: best er modeling tool for postgreSQL
Next
From: Marc
Date:
Subject: Performance Problem - pgsql on MD3000 DAS