Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Drop tempfiles from database Oracle
  • Rename Tablespace Oracle
  • Implementation of key based authentications Linux/Unix
  • Good Oracle Architecture In Short and point to point Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • scripts to take listener.log backup Linux/Unix
  • Monitor and Trace Unix processes using truss Linux/Unix
  • Shuffle an array PHP/MYSQL/Wordpress
  • catting.sh Linux/Unix
  • More info about /proc folder and its relation with processes. Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • Goldengate document from Porus Oracle
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • Unix command for system configuration 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 (402)
  • 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 (3)
  • Videos (0)

Recent Posts

  • 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
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • oradebug ipcrm ipcs Oracle
  • Some OS level threshold for performance. Linux/Unix
  • Oracle Internal Good Websites 1 Oracle
  • how to find OS block size Oracle
  • Temporary tablespace explaination Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • This is im telling Kishore Oracle
  • Jai Shree Ram Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme