Export and import from one postgres server to another - Mailing list pgsql-general

Hi,

I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could
usePhpPgAdmin, but the hints on the web don't seem to work. One said to simply get a dump from one phpPgAdmin, the go
tothe other server, select the database, click the SQL button and then select the dump file. When I do this the import
failsbecause the dump file begins with a \connect statement. The escape char doesn't seem to go through the web
frontendor something. But without the connect statement it ends up telling me no database selected. Please, can someone
letme know how to do this? 

Thanks
Alex
Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deleting, indexes and transactions
Next
From: Anthony Bull
Date:
Subject: PostgreSQL disk space reclaiming