Re: What is the size of DB in Postgresql?? - Mailing list pgsql-general

From Poul L. Christiansen
Subject Re: What is the size of DB in Postgresql??
Date
Msg-id 3A1A8EAB.18F0D567@cs.auc.dk
Whole thread Raw
In response to What is the size of DB in Postgresql??  (Ould <ouldm@linuxatbusiness.com>)
List 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

pgsql-general by date:

Previous
From: Ould
Date:
Subject: What is the size of DB in Postgresql??
Next
From: "Adam Lang"
Date:
Subject: Re: I loose my history keys using psql...