We recently performed the cloning of the staging Database from a production database, but unfortunately we faced an issue.
Once the restore is complete, we were not able to stop the database to rename it and perform the post checks.
Sharing knowledge is the ultimate key to gaining knowledge…
The only two things that stay with you for life are you & your knowledge...
Live while you can! Teach & inspire while you could & Smile while you have the teeth.
We recently performed the cloning of the staging Database from a production database, but unfortunately we faced an issue.
Once the restore is complete, we were not able to stop the database to rename it and perform the post checks.
Many times when we kill a session with alter system kill session command ( or Toad )
PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased security.
Official documentation : https://www.postgresql.org/download/linux/redhat/
Lets assume that we have an update, insert or delete statement that running but has not been committed yet. So question is how to show uncommitted transactions ?
While troubleshooting sqlnet issue a week back and we used very same article to read trace files. It was very useful.
Found an interesting event, that helps to open the database with delay option. The event db_open_begin delay (opening database with delay) is undocumented event ( read unsupported )
The DBA can grant you SELECT privileges to the V$ performance views. It's good for instance tuning, but not as effective as SQL Trace or ADVISOR privilege for query tuning.
To successfully run an ALTER SYSTEM command, you don't need to be the DBA, but you do need the ALTER SYSTEM privilege to be granted to you (or to the "user" owning the application through which you connect to the database - which may be different from "you" as the "user" ).
If you have a problem with PostgreSQL, it starts some processes that consume lots of resources. You kill those processes but they will restart after a few minutes.
Later you check the /var/log but there is nothing about this. What does that mean?😟
What is High Availability?
It is the amount of time that a service is available and is usually defined by the business.