Re: easy way to copy all DBs and users on a server

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: exciteworks hosting <jtnews(at)exciteworks(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: easy way to copy all DBs and users on a server
Date: 2003-11-13 18:12:57
Message-ID: Pine.LNX.4.33.0311131112420.612-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 12 Nov 2003, exciteworks hosting wrote:

> Is there an easy way to copy all DBs and users on a server to another
> server?
>
> I need to get an exact duplicate.

pg_dump -h source_server|psql -h dest_server

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message banghe 2003-11-13 18:14:05 Re: SQL-Statement
Previous Message Markus Espenhain 2003-11-13 17:23:27 SQL-Statement