Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • temp_use.sql diplays usage of temp ts Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • get_vmstat.ksh for Solaris Oracle
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
  • Oracle Internal Good Websites 1 Oracle
  • checking connectivity between two servers Linux/Unix
  • Search and replace editor command in vi Linux/Unix
  • CPU Core related projections AWS
  • Goog notes on X$ tables Oracle
  • Korn Shell Arithmatic Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Oracle 10g Wait Model Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • Jai Shree Ram Oracle
  • Temporary tablespace explaination 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 (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
  • Rename Tablespace Oracle
  • CPU speed on Linux Linux/Unix
  • When error comes for temporary tablespace with version <= 9i Oracle
  • 10g oem configuration Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • Default User Profile Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme