Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • Deleting first line and lastline of a file using sed Linux/Unix
  • purge_trc.sh Linux/Unix
  • get_vmstat.ksh Linux/Unix
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Renaming the column name Oracle
  • Renaming Oracle Instance Name Oracle
  • SQL_PLAN.sql for checking real execution plan Oracle
  • ext#.sql Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • Guide to Linux System Command Mastery Linux/Unix
  • Jai Shree Ram Oracle
  • How to know current SID Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Index Range Scan Oracle

Category: POSTGRESQL

Postgres DB user and OS user.

Posted on 25-Dec-202525-Dec-2025 By Admin No Comments on Postgres DB user and OS user.

In PostgreSQL on Linux, it is crucial to understand that the OS user and the database user (often both named postgres) are two completely separate entities with separate credentials. Here is the breakdown of how they interact: 1. Are the passwords the same? No. * OS User (postgres): This is a Linux system account created…

Read More “Postgres DB user and OS user.” »

POSTGRESQL

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Oracle Internal Good Websites 1 Oracle
  • proper cpu stats Linux/Unix
  • SYSOPER Mystery Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • get_vmstat.ksh Linux/Unix
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • alter database backup controlfile to trace Oracle
  • scp with ssh2 Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme