To change the data directory location for PostgreSQL after installation, you'll need to move the existing data to the new location and update PostgreSQL's configuration to use the new directory. Here’s a step-by-step guide to achieve that: 1. Stop PostgreSQL service : First, stop the PostgreSQL service to ensure no data is being accessed or written during the move. sudo systemctl stop postgresql-15 2. Create the new data directory : Create the new directory where you want to move your PostgreSQL data, and set the appropriate permissions for the postgres user. sudo mkdir -p /new/postgres/pg_data sudo chown postgres:postgres /new/postgres/pg_data sudo chmod 700 /new/postgres/pg_data 3. Move the existing data : Move your existing data from the old directory to the new directory. This step will ensure all your current databases and configurations are preserved. sudo rsync -av --progress /var/lib/pgsql/15/data/ /new/postgres/pg_data/ The rsync command helps preserve permission...
****** AWR ****** Run the following query to display the AWR settings. By default, the INTERVAL equals to 1 hour and the RETENTION equals to 8 days. col SNAP_INTERVAL format a20 col RETENTION format a20 col TOPNSQL format a10 SELECT SNAP_INTERVAL, RETENTION, TOPNSQL FROM DBA_HIST_WR_CONTROL; SNAP_INTERVAL RETENTION TOPNSQL -------------------- -------------------- ---------- +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT Modify the INTERVAL setting to 30 minutes. BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(INTERVAL => 30); END; / PL/SQL procedure successfully completed. SELECT SNAP_INTERVAL, RETENTION, TOPNSQL FROM DBA_HIST_WR_CONTROL; SNAP_INTERVAL RETENTION ...
GIT Download : https://git-scm.com/downloads Click the one above link to down load the Git software. Installation: Click on the machine OS supported, for windows click on the download for windows. Click on the OS bit version as per your PC or laptop supported, it will download. Checking the GIT version. GIT -HUB account Creation: Click on this link : https://github.com/ Open Gmail account check mail from GitHub for code and enter the code. GIT HUB Account creation is completed :---- Account creation END -----: Create a Repository: (or) :----C reate Repository END -----: GIT ARCHITECTURE: GIT configuration: git config --global user.name "Sainath Kota" git config --global user.email "sainath.kota@gmail.com" Remove an entry in global configuration: git config --global --unset user.name git config --global --uns...
Comments
Post a Comment