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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
