Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Wait Based Tuning Step by step with SQL statement Oracle
  • Jai Shree Ram Oracle
  • Nice notes on wait events Oracle
  • create database link syntax Oracle
  • v$backup.status information Oracle
  • More info about /proc folder and its relation with processes. Linux/Unix
  • send email from unix mailx with attachment. Linux/Unix
  • Composite Index creation tip from Vivek Oracle
  • Database logon trigger issue Oracle
  • switchover for primary database Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Reading parameter file and printing Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • on IBM-AIX for display Linux/Unix
  • Which environment is used by currently running process ( Very good) Linux/Unix

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
  • backspace in SQL Plus not working then..? Linux/Unix
  • DBMS_JOB all example Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Running select from V$ views from remote server Linux/Unix
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • Jai Shree Ram Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Histogram information Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme