Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • get_aix_vmstat.ksh Oracle
  • currwait.sql Oracle
  • sesswait.sql Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • Oracle Data Direct to TAPE Oracle
  • scp with ssh2 Linux/Unix
  • Korn Shell Arithmatic Linux/Unix
  • grep multuple patterns Linux/Unix
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • My Test Case On 21-OCT-2005 Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • When to rebuld B-tree index 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 (149)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • 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.sql23-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
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • Oracle Release Explaination Oracle
  • New OFA for 11g Oracle
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Move WordPress site from one hosting service to other. PHP/MYSQL/Wordpress

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme