Difference between revisions of "SQWareProduction:postgres:etc:.profile"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | Sample file for .profile $ | + | Sample file for .profile $gvsqw_PgBin/../etc/.profile:<br> |
Sample of lines to add to .profile of postgres users.<br> | Sample of lines to add to .profile of postgres users.<br> | ||
<br> | <br> | ||
| Line 6: | Line 6: | ||
#!/bin/ksh | #!/bin/ksh | ||
################################################################### | ################################################################### | ||
| − | # SQWareProduction for Postgres module of dbSQWare | + | # SQWareProduction for Postgres module of dbSQWare |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
# | # | ||
# dbSQWare is distributed in the hope that it will be useful, | # dbSQWare is distributed in the hope that it will be useful, | ||
# but WITHOUT ANY WARRANTY; without even the implied warranty of | # but WITHOUT ANY WARRANTY; without even the implied warranty of | ||
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE. See the | # MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE. See the | ||
| − | # | + | # CGU/CGA for more details. |
# | # | ||
| − | # You should have received a copy of the | + | # You should have received a copy of the CGU/CGA |
| − | # along with this program. If not, see <http://www. | + | # along with this program. If not, see <http://www.dbsqware.com/licenses/>. |
# | # | ||
# For information : contact@dbsqware.com or www.dbsqware.com | # For information : contact@dbsqware.com or www.dbsqware.com | ||
################################################################### | ################################################################### | ||
## @Synopsis template .profile for unix users Postgres | ## @Synopsis template .profile for unix users Postgres | ||
| − | ## @Copyright Copyright 2010- | + | ## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com) |
| − | |||
| − | |||
| − | |||
| − | |||
| + | export PATH=/usr/pgsql-12/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH | ||
| + | export PGDATA=/pgdata/$PG_SID/data | ||
| + | export PGHOST=/var/run/postgresql/$PG_SID | ||
| + | export PGPORT=5432 | ||
| + | export LANG='en_US.UTF-8' | ||
| + | |||
| + | #dbSQWare | ||
| + | export gvsqw_Env='PRD' | ||
export gvsqw_PgBin=$HOME/SQWareProduction/postgres/bin | export gvsqw_PgBin=$HOME/SQWareProduction/postgres/bin | ||
| − | + | lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?) | |
| − | + | if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ] | |
| − | + | then | |
| − | export PATH= | + | . $gvsqw_PgBin/../etc/.profile_confort |
| + | fi | ||
| + | |||
| + | ################################################################### | ||
| + | ################################################################### | ||
| + | ## Multi instance | ||
| + | |||
| + | export PATH=/usr/pgsql-12/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH | ||
| + | export LANG='en_US.UTF-8' | ||
| − | + | lvsqw_Instance=$1 | |
| − | export gvsqw_Env='' | + | export PG_SID=$lvsqw_Instance |
| + | case $lvsqw_Instance in | ||
| + | PG_110) | ||
| + | export PATH=/usr/pgsql-11/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-11/lib:$LD_LIBRARY_PATH | ||
| + | export PGDATA=/pgdata/$PG_SID/data | ||
| + | export PGHOST=/var/run/postgresql/$PG_SID | ||
| + | export PGPORT=5441 | ||
| + | ;; | ||
| + | PG_120) | ||
| + | export PATH=/usr/pgsql-12/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH | ||
| + | export PGDATA=/pgdata/$PG_SID/data | ||
| + | export PGHOST=/var/run/postgresql/$PG_SID | ||
| + | export PGPORT=5442 | ||
| + | ;; | ||
| + | PG_130) | ||
| + | export PATH=/usr/pgsql-13/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH | ||
| + | export PGDATA=/pgdata/$PG_SID/data | ||
| + | export PGHOST=/var/run/postgresql/$PG_SID | ||
| + | export PGPORT=5443 | ||
| + | ;; | ||
| + | PG_140) | ||
| + | export PATH=/usr/pgsql-14/bin:$PATH | ||
| + | export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH | ||
| + | export PGDATA=/pgdata/$PG_SID/data | ||
| + | export PGHOST=/var/run/postgresql/$PG_SID | ||
| + | export PGPORT=5444 | ||
| + | ;; | ||
| + | *) | ||
| + | export PG_SID="NoSID" | ||
| + | unset PGDATA | ||
| + | unset PGHOST | ||
| + | unset PGPORT | ||
| + | ;; | ||
| + | esac | ||
| + | |||
| + | export gvsqw_Env='PRD' | ||
| + | export gvsqw_PgBin=$HOME/SQWareProduction/postgres/bin | ||
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?) | lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?) | ||
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ] | if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ] | ||
then | then | ||
| − | + | . $gvsqw_PgBin/../etc/.profile_confort | |
fi | fi | ||
| + | |||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 22:19, 25 February 2024
Sample file for .profile $gvsqw_PgBin/../etc/.profile:
Sample of lines to add to .profile of postgres users.
File content:
#!/bin/ksh
###################################################################
# SQWareProduction for Postgres module of dbSQWare
#
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE. See the
# CGU/CGA for more details.
#
# You should have received a copy of the CGU/CGA
# along with this program. If not, see <http://www.dbsqware.com/licenses/>.
#
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis template .profile for unix users Postgres
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
export PATH=/usr/pgsql-12/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH
export PGDATA=/pgdata/$PG_SID/data
export PGHOST=/var/run/postgresql/$PG_SID
export PGPORT=5432
export LANG='en_US.UTF-8'
#dbSQWare
export gvsqw_Env='PRD'
export gvsqw_PgBin=$HOME/SQWareProduction/postgres/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ]
then
. $gvsqw_PgBin/../etc/.profile_confort
fi
###################################################################
###################################################################
## Multi instance
export PATH=/usr/pgsql-12/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH
export LANG='en_US.UTF-8'
lvsqw_Instance=$1
export PG_SID=$lvsqw_Instance
case $lvsqw_Instance in
PG_110)
export PATH=/usr/pgsql-11/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-11/lib:$LD_LIBRARY_PATH
export PGDATA=/pgdata/$PG_SID/data
export PGHOST=/var/run/postgresql/$PG_SID
export PGPORT=5441
;;
PG_120)
export PATH=/usr/pgsql-12/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH
export PGDATA=/pgdata/$PG_SID/data
export PGHOST=/var/run/postgresql/$PG_SID
export PGPORT=5442
;;
PG_130)
export PATH=/usr/pgsql-13/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH
export PGDATA=/pgdata/$PG_SID/data
export PGHOST=/var/run/postgresql/$PG_SID
export PGPORT=5443
;;
PG_140)
export PATH=/usr/pgsql-14/bin:$PATH
export LD_LIBRARY_PATH=/usr/pgsql-12/lib:$LD_LIBRARY_PATH
export PGDATA=/pgdata/$PG_SID/data
export PGHOST=/var/run/postgresql/$PG_SID
export PGPORT=5444
;;
*)
export PG_SID="NoSID"
unset PGDATA
unset PGHOST
unset PGPORT
;;
esac
export gvsqw_Env='PRD'
export gvsqw_PgBin=$HOME/SQWareProduction/postgres/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_PgBin/../etc/.profile_confort ]
then
. $gvsqw_PgBin/../etc/.profile_confort
fi
