Thread: tablespace and pg_dump

tablespace and pg_dump

From
Michelle Konzack
Date:
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)