Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • catall.sh Linux/Unix
  • AWR license Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • How to find password change date for user Oracle
  • chk_space_SID.ksh Linux/Unix
  • How to set Processes Parameter Oracle
  • DB Console Mainenance. Oracle
  • Load SPM baseline from AWR Oracle
  • Add new columns in dataframe Python/PySpark
  • Important Solaris Commands Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • Unix split command to split files 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
  • rm_backup_arch_file.ksh Linux/Unix
  • Important Script Method for tuning Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • Changing Instance Name ( No DB_NAME) Oracle
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • Renaming Global Name GLOBAL_NAME Oracle
  • standard Monitoring – 1 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme