Forum OpenACS Q&A: Crating new tablespaces

Collapse
1: Crating new tablespaces
Posted by Mathias J. From on 11/14/01 02:10 PM
I have been running the OpenACS-rpm-packages, version 3.2.5. Very
uncomplicated! Now I am creating new tablespaces in order to be able
to run several community-services. I have loaded the datamodel,
running the files land-geo-tables and load-data-model.sql. But there
is a problem: the new tablespace is completely empty, missing basic
datas like user:system in the users table. Where do I find the basic
content to my new tablespace, and how do I copy it into my new tablespace?
Collapse
2: Response to Crating new tablespaces (response to 1)
Posted by Don Baccus on 11/14/01 02:54 PM
If user system is missing something went wrong when you loaded the
datamodel.  Did you keep a log file?

As far as copying an existing database (database, not tablespace, is
the correct PG term for these new data repositories), you can
pg_dump the contents of the old one and use psql to reload it.