diff options
| -rw-r--r-- | gentoobrowse/datasources/postgres-web.xml | 10 | ||||
| -rw-r--r-- | gentoobrowse/datasources/postgres.xml | 10 |
2 files changed, 10 insertions, 10 deletions
diff --git a/gentoobrowse/datasources/postgres-web.xml b/gentoobrowse/datasources/postgres-web.xml index 0825e30..1770c41 100644 --- a/gentoobrowse/datasources/postgres-web.xml +++ b/gentoobrowse/datasources/postgres-web.xml @@ -1,10 +1,10 @@ <?xml version="1.0"?> <project2:rdbmsdatasource xmlns:project2="http://project2.randomdan.homeip.net" name="postgres-web"> <readonly preferlocal="true"> - <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> - <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=apache;Database=gentoo;Password=gentoo;</dsn> + <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> </readonly> - <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=apache;Database=gentoo;Password=gentoo;</masterdsn> + <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=apache;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</masterdsn> </project2:rdbmsdatasource> diff --git a/gentoobrowse/datasources/postgres.xml b/gentoobrowse/datasources/postgres.xml index b48a434..448892a 100644 --- a/gentoobrowse/datasources/postgres.xml +++ b/gentoobrowse/datasources/postgres.xml @@ -1,10 +1,10 @@ <?xml version="1.0"?> <project2:rdbmsdatasource xmlns:project2="http://project2.randomdan.homeip.net" name="postgres"> <readonly preferlocal="true"> - <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> - <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</dsn> + <dsn host="firebrand">Driver=postgresql;ServerName=firebrand.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="defiant">Driver=postgresql;ServerName=defiant.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="akira">Driver=postgresql;ServerName=akira.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> + <dsn host="riogrande">Driver=postgresql;ServerName=riogrande.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</dsn> </readonly> - <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;</masterdsn> + <masterdsn>Driver=postgresql;ServerName=postgresql.random.lan;Username=gentoo;Database=gentoo;Password=gentoo;ConnSettings=SET search_path=gentoobrowse,public;</masterdsn> </project2:rdbmsdatasource> |