Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • xargs use Linux/Unix
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • To see mem usage and CPU usage system wide. Linux/Unix
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • chk_space_SID.ksh Linux/Unix
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • Display the top 5 salaries for each department using single SQL Oracle
  • V$ROLLSTAT status is Full Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Check Oracle installed products using one command Oracle
  • shutdown linux Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • cif crons Linux/Unix
  • Find_table_size.sql 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 (395)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (343)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • TNSNAMES entries details Oracle
  • runsql_once.ksh Linux/Unix
  • Session_info.ksh Linux/Unix
  • How to know current SID Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • adding new line after specific pattern using sed Linux/Unix
  • sql_plan9i.sql Oracle
  • find_open_cur.sql Find open cursorts per session Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme