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

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
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 04:46:15
Message-ID: 1068698775.1719.7.camel@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2003-11-13 at 07:47, exciteworks hosting wrote:
> Is there an easy way to copy all DBs and users on a server to another
> server?

pg_dumpall is a good partner. If i am correct, you can also copy the
entire data directory, provided if both versions are same.

regards,
bhuvaneswaran

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2003-11-13 05:10:11 Re: Taking database offline
Previous Message A.Bhuvaneswaran 2003-11-13 04:42:56 Re: pg_dump still requires password