SQWareProduction:postgres:etc:.profile confort: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older edit
m Updated by BatchUser
m Updated by BatchUser
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
File to put aliases $gvsqw_PgBin/../etc/.profile_confort:<br>
File to put aliases $gvsqw_PgBin/../etc/.profile_confort:<br>
Contains confort aliases of SQWareProduction for RDBMS postgres.<br>
Contains confort aliases of SQWareProduction for postgres.<br>
<br>
<br>
Alias explanation:
Alias explanation:
<pre>
<pre>
  put => "echo $lvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname      $gvsqw_Env    ${PG_SID}          (dbSQWare v$gvsqw_EdtVersion GPL v3)\033\\'"
  lspg => 'ps -edf|egrep "bin/[p]ostgres|[p]ostmaster"'
erase => 'stty erase ^H'
  alt => 'cd $gvsqw_RootLog; ls -al'
so => 'set -o emacs'
  dmp => 'cd $gvsqw_RootDump; ls -al'
h => 'history -100'
  pitr => 'cd $gvsqw_RootPitr; ls -al'
ll => 'ls -al'
  dbf => 'cd $gvsqw_RootDbf; ls -al'
lt => 'ls -altr'
  arc => 'cd $gvsqw_ArchiveXlog_dest1; ls -al'
top => '/usr/local/bin/top'
  sqwarchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"
cls => 'clear'
  SqwArchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"
l => 'ls -l'
lrt => 'ls -rtl'
p => 'pwd'
sg => 'size=$(du -sk .|cut -f1);((size=size/1024/1024));echo "$size Go";date +"%d/%m/%Y %H:%M:%S"'
  sm => 'size=$(du -sk .|cut -f1);((size=size/1024));echo "$size Mo";date +"%d/%m/%Y %H:%M:%S"'
dmp => 'cd $gvsqw_RootDump; ls -al';
  dbf => 'cd $gvsqw_RootDbf; ls -al';
  bin => 'cd $gvsqw_PgBin; ls -al';
  lib => 'cd $gvsqw_PgBin/../lib; ls -al';
  men => 'cd $gvsqw_PgBin/../menu; ls -al';
  too => 'cd $gvsqw_PgBin/../tools; ls -al';
  etc => 'cd $gvsqw_PgBin/../etc; ls -al';
cbin => 'cd $gvsqw_PgBin/../bin_cust; ls -al';
clib => 'cd $gvsqw_PgBin/../lib_cust; ls -al';
cmen => 'cd $gvsqw_PgBin/../menu_cust; ls -al';
ctoo => 'cd $gvsqw_PgBin/../tools_cust; ls -al';
cetc => 'cd $gvsqw_PgBin/../etc_cust; ls -al';
hlp => 'cd $gvsqw_PgBin/../help; ls -al';
chlp => 'cd $gvsqw_PgBin/../help_cust; ls -al';
e => '. $gvsqw_PgBin/../tools/sqwpg_SetEnv.ksh'
my => 'postgres $gvsqw_ConnectString'
CFG => 'cd $MYSQL_HOME;vi -R my.cnf'
memcfg => 'cd $MEM_HOME; vi -R etc/postgres-monitor-agent.ini'
err => 'cd $MYSQL_HOME/log; tail -100 $PG_SID.error.log'
memerr => 'cd $MEM_HOME; tail -100 postgres-monitor-agent.$PG_SID.log'
mysp => 'my -e "show processlist"'
cfg => 'cd $gvsqw_RootCfg; ls -al';
log => 'cd $gvsqw_RootAdmin/logs; ls -ltr';
tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr';
</pre>
</pre>
<br>
<br>

Latest revision as of 16:02, 23 February 2025

File to put aliases $gvsqw_PgBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for postgres.

Alias explanation: 

 lspg => 'ps -edf|egrep "bin/[p]ostgres|[p]ostmaster"'
 alt => 'cd $gvsqw_RootLog; ls -al'
 dmp => 'cd $gvsqw_RootDump; ls -al'
 pitr => 'cd $gvsqw_RootPitr; ls -al'
 dbf => 'cd $gvsqw_RootDbf; ls -al'
 arc => 'cd $gvsqw_ArchiveXlog_dest1; ls -al'
 sqwarchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"
 SqwArchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:postgres:etc:.profile_confort&oldid=30125"