[GeoNetwork-users] Move tables in other shema

Georges_H · May 22, 2015, 1:21pm

Hi

I have installed GN3 on Postgres, all is fine. Installed in the "public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

fgravin · May 22, 2015, 1:44pm

Hi,

You could set the search_path to make your schema accessible without a
prefix.

ALTER DATABASE myDB SET search_path = geonetwork,public ;

On Fri, May 22, 2015 at 3:21 PM, Georges H <georges.hinot@anonymised.com> wrote:

Hi

I have installed GN3 on Postgres, all is fine. Installed in the "public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
Application Monitoring Software and Tool - ManageEngine Applications Manager
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
GeoNetwork - Geographic Metadata Catalog download | SourceForge.net

--
Florent Gravin
Camptocamp - Chambéry
0479444492

Georges_H · May 22, 2015, 2:51pm

OK thanks

But I have run this command, after having moved the table "users", and the
connexion do not run on GN.

Is it important to move all the tables on my geonetwork schema before run
this command ?

2015-05-22 15:44 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com>:

Hi,

You could set the search_path to make your schema accessible without a
prefix.

ALTER DATABASE myDB SET search_path = geonetwork,public ;

On Fri, May 22, 2015 at 3:21 PM, Georges H <georges.hinot@anonymised.com>
wrote:

Hi

I have installed GN3 on Postgres, all is fine. Installed in the "public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

fgravin · May 26, 2015, 8:16am

Hi,

Is it important to move all the tables on my geonetwork schema before run

this command ?

No it should'nt, but what error do you have exactly ?

On Fri, May 22, 2015 at 4:51 PM, Georges H <georges.hinot@anonymised.com> wrote:

OK thanks

But I have run this command, after having moved the table "users", and the
connexion do not run on GN.

Is it important to move all the tables on my geonetwork schema before run
this command ?

2015-05-22 15:44 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com>:

Hi,

You could set the search_path to make your schema accessible without a
prefix.

ALTER DATABASE myDB SET search_path = geonetwork,public ;

On Fri, May 22, 2015 at 3:21 PM, Georges H <georges.hinot@anonymised.com>
wrote:

Hi

I have installed GN3 on Postgres, all is fine. Installed in the "public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
Application Monitoring Software and Tool - ManageEngine Applications Manager
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

--
Florent Gravin
Camptocamp - Chambéry
0479444492

Georges_H · May 26, 2015, 9:15am

OK, I go to retry with another GN3 and another Postgres, in oldest version.

But my first error was about "Lucene index", which, I think, refused to
re-create them.

2015-05-26 10:16 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com>:

Hi,

Is it important to move all the tables on my geonetwork schema before run

this command ?

No it should'nt, but what error do you have exactly ?

On Fri, May 22, 2015 at 4:51 PM, Georges H <georges.hinot@anonymised.com>
wrote:

OK thanks

But I have run this command, after having moved the table "users", and
the connexion do not run on GN.

Is it important to move all the tables on my geonetwork schema before run
this command ?

2015-05-22 15:44 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com>
:

Hi,

You could set the search_path to make your schema accessible without a
prefix.

ALTER DATABASE myDB SET search_path = geonetwork,public ;

On Fri, May 22, 2015 at 3:21 PM, Georges H <georges.hinot@anonymised.com>
wrote:

Hi

I have installed GN3 on Postgres, all is fine. Installed in the "public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

Georges_H · May 26, 2015, 9:57am

OK ! I think it is necessary to restart the VM after have to move tables in
other schema.

2015-05-26 11:15 GMT+02:00 Georges H <georges.hinot@anonymised.com>:

OK, I go to retry with another GN3 and another Postgres, in oldest version.

But my first error was about "Lucene index", which, I think, refused to
re-create them.

2015-05-26 10:16 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com>:

Hi,

Is it important to move all the tables on my geonetwork schema before run

this command ?

No it should'nt, but what error do you have exactly ?

On Fri, May 22, 2015 at 4:51 PM, Georges H <georges.hinot@anonymised.com>
wrote:

OK thanks

But I have run this command, after having moved the table "users", and
the connexion do not run on GN.

Is it important to move all the tables on my geonetwork schema before
run this command ?

2015-05-22 15:44 GMT+02:00 Florent Gravin <florent.gravin@anonymised.com
>:

Hi,

You could set the search_path to make your schema accessible without a
prefix.

ALTER DATABASE myDB SET search_path = geonetwork,public ;

On Fri, May 22, 2015 at 3:21 PM, Georges H <georges.hinot@anonymised.com>
wrote:

Hi

I have installed GN3 on Postgres, all is fine. Installed in the
"public"
schema of Postgres.

But I would move tables in other shema, I have done it with just a
table
("user"), but without success, GN do not run like this

Is it possible ?

Thank you !

------------------------------------------------------------------------------
One dashboard for servers and applications across
Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable
Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

--
Florent Gravin
Camptocamp - Chambéry
0479444492

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>

--
*Georges Hinot*
*CNRS - DRIIHM - UMS BBEES (3468)*
Musée d'Histoire Naturelle de Paris, Maison Buffon
Géomaticien - Administrateur BDD - Intégrateur
georges.hinot@anonymised.com
georges.hinot@anonymised.com
*Tél : 01 40 79 80 44*
*Tél : 06 47 61 84 92*
Le nouveau site DRIIHM-ROHM ! <http://driihm.fr>