PDA

View Full Version : Transferring data from one postgresql server to another


zdeh98
02-08-02, 02:06
Good day!

Can I transfer data from one postgresql server to another? How?

Thank's. :cool:

eperich
02-08-02, 05:14
be more specific?

1. per pg_dump and copy the files manually
2. replication
3. over a script

beholder242
12-10-03, 23:54
Since the original poster of this question never responded to give additional information, I will revise and extend the original question.

I am looking for a method, preferably a simple one, of INSERTing the data from a table in Server A across the Internet using a secure connection (SSL or SSH) to another table on Server B. Is this possible using already-existing methods, or will I have to write a perl script or C application in order to accomplish this?

Thanks in advance!