Re: What is the size of DB in Postgresql??

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: Ould <ouldm(at)linuxatbusiness(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the size of DB in Postgresql??
Date: 2000-11-21 15:03:07
Message-ID: 3A1A8EAB.18F0D567@cs.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ould wrote:
>
> Hello,
>
> I have 2 questions:
> 1) What is th max size of database we can create in Postegrsql?

See: http://www.postgresql.org/docs/faq-english.html#4.6

"Maximum size for a database? unlimited (60GB databases exist)"

> 2) Suppose I have two simular databases: mydb1, mydb2 (containig the
> same number of table, ...etc.), how I can copy the contents of mydb1
> into mydb2? if mydb2 is on a remote machine, how I can do this?

Use the pg_dumpall command.

Poul L. Christiansen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Stachurski 2000-11-21 15:09:05 Question about creating functions
Previous Message Adam Lang 2000-11-21 15:03:05 Re: I loose my history keys using psql...