Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • Finding Oracle Patches with opatch Oracle
  • Identical Dblink Issue… Oracle
  • cache buffer chain latch Oracle
  • Oracle Statspack survival Guide Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • plan10g.sql Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • V$INSTANCE of Oracle in MYSQL MYSQL
  • V$transaction notes for finding XID composition. Oracle
  • telnet listening Linux/Unix
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Implementation of key based authentications 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 (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • create database link syntax Oracle
  • Drop specific SQL plan baseline – spm Oracle
  • Jai Shree Ram Oracle
  • Zip and unzip with tar Linux/Unix
  • Export Oracle data and Compress at same time Oracle
  • dbms_job.submit example Oracle
  • Error Handling in Proc Oracle
  • DBMS_Shared_pool pinning triggers Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme