Re: Export and import from one postgres server to another

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Alexander Reichstadt <info(at)apfeltaste(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Export and import from one postgres server to another
Date: 2012-05-29 14:13:22
Message-ID: CAF-3MvPnm0Ssdx0a7K+8bsOC5XFK0-jmxRS=FqbZ-WRw++bx2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29 May 2012 14:58, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> Q: Why can't I reload the SQL script I dumped in the SQL window?
>
> A: The following limitations currently exist in SQL script execution:
>
>        * 'psql' commands such as '\connect' will not work at all.

Wait a minute! They use the pg_dump utility to create the dump file
(there are \connect statements and such in it, after all), but they
don't use psql/pg_restore to restore?

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-05-29 15:20:00 Re: Export and import from one postgres server to another
Previous Message Grant Allen 2012-05-29 13:55:06 Re: PG vs MSSQL language comparison ?