After my recent DB upgrade activity, I was unable to create extension and was failing with the below errors.
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.
After my recent DB upgrade activity, I was unable to create extension and was failing with the below errors.
There are various ways to know since how long PostgreSQL is running.
Below will cover 3 ways to find this.
If you plan to work with date and time data in PostgreSQL, you’ll want to ensure that you’ve set the correct time zone for your location. Fortunately, it’s easy to make this change using the psql command-line interface. In this article, we’ll explain how to connect to PostgreSQL and set the time zone.
Clean up the page-cache :
# sync; echo
1> / proc / sys / vm / drop_caches
Clean dentrie and inode caches:
# sync; echo
2> / proc / sys / vm / drop_caches
To clean the page-cache, dentrie and inode caches:
# sync; echo
3> / proc / sys / vm / drop_caches
# swapoff -a && swapon -a
1) Shutdown the database and its services (pg_ctl stop , sudo service postgresql stop, etc.)
2) sync
3) sudo echo 3> / proc / sys / vm / drop_caches
4) Start the database server
free && sync && echo 3> / proc / sys
/ vm / drop_caches && free
Found this post interesting? Subscribe us 😊😉
Read more
Configure Streaming Replication in PostgreSQL
All about Physical Replication and Log shipping in Postgres
Streaming-Replication Sync and Async, benefits of streaming replication over Log-shipping
Sometimes the database user account is getting locked if the login was tried with the wrong password. In 11g database, the user account will get locked after 10 consequent failed login attempts. Oracle 11g database's default profile makes the database account password lifetime as 3 months and the number of failed login attempts as 10 days. Once these limits are reached, it will lock the account.
The following command can be used to change the default profile to allow an unlimited number of failed login attempt:
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
The following command can be used to change the default profile to allow an unlimited number of days as password lifetime.
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
In my previous post here, I tried to explain how the log shipping works and its advantages. Let's see more about Streaming replication in Postgres.
As a Database Administrator, we always classify various types of schema with specific privileges. In the standard application, there are a few various types of Database Users like Application user, Read-only user, Admin user.
Ora2Pg is Free Software written and maintained by Gilles Darold. Its an Ideal for large migration projects.
3 Reasons to move to PostgreSQL :
Below query can be used
SELECT pg_relation_size(object_id, 'main')/8192);
I tried to enable the pg_stat_statements and Database was unable to start
The
major highlights:
Postgres has made great strides in adding features to match proprietary databases, and it has many complex features that other databases don't have.