View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Using database schema for multiple Projeqtor instances in one PostgreSQL database - ProjeQtOr
 

Using database schema for multiple Projeqtor instances in one PostgreSQL database

More
25 Feb 2016 10:00 #1 by wfranck17
Using database schema for multiple Projeqtor instances in one PostgreSQL database was created by wfranck17
With a PostgreSQL database, one can create multiple database schemas.
Ref Doc

Use case :
  • on a given PostGreSQL server, (IP@, Port)
  • each Programme (i.e. MegaProject) is a database.
  • which contains several (ProjQtor) projects.

Schemas would give somes facilities to database administration (backup, access rights, ...)


When accessing tables, you just prefix the database with the Schema name.
select * from mySchema.myTable;

I have tried to use the "table prefix" with a name like 'myProject.' (note the '.' dot ). but with no success. :(
I got a bunch of errors on database creation...
Guess the '.) (dot) character is not welcome in the "table prefix" parameter ? :woohoo:

A workaround is to use different database (PostgreSQL) users (roles), and to define the right schema as the default schema
as in
ALTER USER user_name SET search_path to ...;
The following user(s) said Thank You: babynus
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.030 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form