Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Add new columns in dataframe Python/PySpark
  • Set Role explaination. Oracle
  • age_alert.ksh aging out alert.log Linux/Unix
  • Debugging Shell FIles Linux/Unix
  • v$backup.status information Oracle
  • setting prompt display with .profile Linux/Unix
  • oracle 10g on linux Linux/Unix
  • Single character replacement in Unix Linux/Unix
  • create a folder in multiple places Linux/Unix
  • longtx.sql Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • Sample WW22 listener.ora Oracle
  • CPU Core related projections AWS
  • Oracle Material from OTN Oracle
  • move_arch_files.ksh 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
  • backspace in SQL Plus not working then..? Linux/Unix
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • myfile Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Facts about SCN and Rollback Segment Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme