Re: Distributing PostGres database to various customers - Mailing list pgsql-general

On 6/11/07, Mike Gould <mgould@allcoast.net> wrote:
> How can we do this with PostGres?  Other than backup and restore or creating
> SQL scripts I haven't been able to find another method.  Some of these
> tables may have over a million rows in them initially if we convert old
> data.

The most portable way is probably pg_dump as plaintext:

  pg_dump -Fp mydatabase >mydatabase.dump

Then restore with:

  cat mydatabase.dump | psql mydatabase

Alexander.