Transferring data from one postgresql server to another [Archive]

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!