1.

How To Start/stop Db In Admin Mode?

Answer»

Admin mode: The gpstart with option (-R) is stands for Admin mode or RESTRICTED mode where only super users can connect to database when database OPENED USING this option.

utility mode: Utility mode allows you to connect to only individual segments when started using gpstart -m, for example< to connect to only master instance only:

PGOPTIONS=’-C gp_session_role=utility’ psql

Admin mode: The gpstart with option (-R) is stands for Admin mode or restricted mode where only super users can connect to database when database opened using this option.

utility mode: Utility mode allows you to connect to only individual segments when started using gpstart -m, for example< to connect to only master instance only:

PGOPTIONS=’-c gp_session_role=utility’ psql



Discussion

No Comment Found