Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • rm_backup_arch_file.ksh Linux/Unix
  • Sending SQLPLUS output in HTML format Oracle
  • Python class import from different folders Python/PySpark
  • Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
  • chk_space_SID.ksh Linux/Unix
  • To find all disk io ( EMC as well as local) Linux/Unix
  • dbinv.sql Oracle
  • eplan9i.sql Oracle
  • Important Script Method for tuning Oracle
  • Find Plan Hash value fphv.sql Oracle
  • upload.html PHP/MYSQL/Wordpress
  • alter database backup controlfile to trace Oracle
  • Renaming Oracle Instance Name Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • configUOCIOTTO.ora 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 (149)
  • MYSQL (5)
  • Oracle (395)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to calculate PROCESSES parameter Oracle
  • Jai Shree Ram Oracle
  • cache buffer chain latch Oracle
  • Create type and Grant on it. Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • To Find Orphan OS processes. Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • SQL_PLAN.sql for checking real execution plan Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme