Re: Unable to dump database using pg_dump

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.