Adam Dear wrote:
> Let me ask this question. Is there any other option for moving data
> from one server to another that doesn't involve pg_dump? If I can get
> the data out of this server, and onto my new one I don't care if the old
> server gets fixed. I just need the data. The new server already has
> the table structure, I just need the most current data to put into the
> server.
Yes, you can use COPY table TO STDOUT. This can probably be piped
directly from one server to the other.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.