Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • Find nth max and min. Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Oracle Statspack survival Guide Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • v$backup.status information Oracle
  • New OFA for 11g Oracle
  • Find all users who have DML privileges Oracle
  • Sending email with file attachment. Linux/Unix
  • alter database backup controlfile to trace Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • Restoring a user’s original password 1051962.101 Oracle
  • Export Import with QUERY Oracle
  • catting.sh 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
  • Paste command syntax Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix
  • Small sample shell program Linux/Unix
  • Vivek Tuning for Row Locks. Oracle
  • How to find password change date for user Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • Query to Generate aggregate on every 30 mins. Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme