tablespace and pg_dump

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: tablespace and pg_dump
Date: 2006-01-17 13:12:18
Message-ID: 20060117131218.GZ1461@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have on my Server around 5000 $USER and each has its own database
which is automaticly created id I add a new $USER with adduser.

The Server has three 2 channel RAID-Controller and it is splitted
into 6 Raid-5 (each 13+2 HDD of 76 GByte)

Now $USER are on different Raid-5 sets and in each $HOME is a
~/pgsql/ where the tablespace for this $USER is.

Now my question: :-)

What happen with the tablespace if I make a "pg_dumpall" and restore
it on another machine where I have for example only ONE diskspace?

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

Browse pgsql-general by date

  From Date Subject
Next Message Martin Krallinger 2006-01-17 13:21:05 full text search
Previous Message Michelle Konzack 2006-01-17 13:12:02 Re: Data loading from a flat file...