On Mon, May 28, 2012 at 10:27 PM, Alexander Reichstadt <i...@apfeltaste.net> wrote: > I am trying to "simply" export my postgres database from one server and then > import it into another. I thought I could use PhpPgAdmin, but the hints on > the web don't seem to work. One said to simply get a dump from one > phpPgAdmin, the go to the other server, select the database, click the SQL > button and then select the dump file. When I do this the import fails because > the dump file begins with a \connect statement. The escape char doesn't seem > to go through the web frontend or something. But without the connect > statement it ends up telling me no database selected. Please, can someone let > me know how to do this?
This will help you http://www.postgresql.org/docs/9.1/static/app-pgdump.html -- Sergey Konoplev a database and software architect http://www.linkedin.com/in/grayhemp Jabber: gray...@gmail.com Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
