PostgreSQL is a feature-rich, object-relational database. RayaFeeL ’s migration specialists are able to convert data from Oracle, SQL Server, MySQL and DB2 databases to the PostgreSQL platform. After migration, our team provides you with the experience, skill-sets and best practices …
2ndQuadrant.in offers a clear, comprehensive and scalable support package. This helpdesk is specifically designed to protect and secure your PostgreSQL data and databases. 2ndQuadrant.in guarantees fast query support by a confirmed PostgreSQL expert. Our support formulas Basic formula Unlimited calls and …
RayaFeeL, leaders in remote DBA services, offer PostgreSQL support also to their customers. Our demonstrated delivery practices in DBA support services has ensured our customers continue to enhance their infrastructure with all possible database options including PostgreSQL. RayaFeeL’s Postgres DBA …
In this shell script will help you to take the backup of postgresql sequence definition with different or individual file name as schema based. # Config: DB=”postgres” U=enterprisedb export PGPASSWORD=”tcs@345″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t …
First Note Down the server and database information for which server and which database do you want to schecdule backup(crontab) jobs. For example i’m taking following servers and databases for scheduling backup jobs. SERVER IP DATABASE 10.10.10.1 …
This script will be helpful to enabling the audit related parameter automatically all entries in bash profile so you don’t need to set bin, if you type pg_ctl it will automatically update the all postgres path like pgdata,pghome pgdatabase.. create a file …
Physical backups are all-or-nothing – you take a full copy of the database cluster and you can restore all of it. The challenge is to make the backup consistent. Of course, the easiest way to do that would be to …
You can upgrade the postgreSQL Server with following anyone methods Method 1: Required More DownTime pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically …
In this article I will share all the details regarding the upgrade of our databases on Amazon Cloud as well as unveil the reason why we ended up using Bucardofor asynchronous multi-master replication and why we have eventually upgraded our production …
This script is very useful after Issue top command you will get PID which one Process taken More CPU Utilization example for 32696 is the most CPU utilization process means take the PID then run the following script it will …
1.DDL-Data Definition Language, which is used to create and modify the structure of database objects in database. It’s a auto commit. automatically saved when you create,alter,drop,truncate,comment,rename commands issued ALTER – alters the structure of the existing database CREATE – to create database …
This script is useful for what are the query is running more than ‘x’ minutes(your input values) and that query status,you can list out the query as per your timing and query status bash-4.1$ cat bash-4.1$ HOSTNAME=`hostname` PSQL=”/opt/PostgreSQL/9.3/bin/psql” PORT=5432 HOST=”localhost” …
Explain plan is mainly used to how Postgres will execute given a query and also Understanding this tells you how you can optimize your database with indexes to improve performance Most commonly, explain is run on SELECT statements. However, you …
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index …
The REINDEX command rebuilds one or more indices, replacing the previous version of the index. REINDEX can be used in many scenarios, including the following (from Postgres documentation): An index has become corrupted, and no longer contains valid data. Although in theory …
Login with Google