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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(2 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>
  dmp => 'cd $gvsqw_RootDump; ls -al';
+
lspg => 'ps -edf|egrep "bin/[p]ostgres|[p]ostmaster"'
  pitr => 'cd $gvsqw_RootPitr; ls -al';
+
alt => 'cd $gvsqw_RootLog; ls -al'
  dbf => 'cd $gvsqw_RootDbf; 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"
 
  SqwArchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"
 
  SqwArchmon => "$gvsqw_PgBin/sqwpg_SqwArchmon.ksh"
 
</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"