Export and import from one postgres server to another

Поиск
Список
Период
Сортировка
От Alexander Reichstadt
Тема Export and import from one postgres server to another
Дата
Msg-id 886EBE3D-AAB6-470C-B580-865D0627D3C4@apfeltaste.net
обсуждение исходный текст
Ответы Re: Export and import from one postgres server to another  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Export and import from one postgres server to another  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Export and import from one postgres server to another  (Merlin Moncure <mmoncure@gmail.com>)
Re: Export and import from one postgres server to another  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Deleting, indexes and transactions
Следующее
От: Anthony Bull
Дата:
Сообщение: PostgreSQL disk space reclaiming