Blog

In this shell script will help you to take the backup of postgresql VIEWS with different file as schema based # Config: DB=”2ndQ” U=enterprisedb export PGPASSWORD=”tcs345″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t -c “select viewname from …

In this shell script will help you to take the backup of postgresql function & procedure with different file as schema based # Config: DB=”tutorialdb” U=enterprisedb export PGPASSWORD=”tcs@345″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ nijam=”/home/Admin/” logfile=”nijam48″.sql /opt/edb/as9.6/bin/psql -d $DB -U $U -t …

Before creating database you have to create tablespace and then you have to give right tablespace name for  database Creation And before creating tablespace you have to check with partion or disk space availability it’s a prerequest for Postgresql tablespace creation …

Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, …

1. Avoid join if possible use subquery instead of join Note : subqueries can be slower than LEFT [OUTER] JOINS, but in my opinion their strength is slightly higher readability. select GPA from Student where sID in (select sID from Apply …

RayaFeeL is a Remote team. RayaFeeL IT Services is a leader in providing PostgreSQL consulting support services, You wouldn’t trust your mission-critical postgres databases to a novice, and that’s why seasoned managers rely on our postgres experts and our proven …

Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (also known as a shared nothing architecture) refers to systems with two or more processors that …

The gprecoverseg utility prepares the segments for recovery and then exits, allowing the Greenplum file replication processes to copy data from the primary to the mirror. During the gprecoverseg execution the following recovery process steps are completed. The down segments are identified. The mirror …

Recovering From Segment FailuresSegment host failures usually cause multiple segment failures: all primary or mirror segments on the host are marked as down and nonoperational. If mirroring is not enabled and a segment goes down, the system automatically becomes nonoperational. …

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 …

PostgreSQL is a feature-rich, object-relational database. RDX’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 required …

what is the postgresql Streaming Replication (SR) ? Streaming Replication (SR) provides the capability to continuously ship and apply the WAL XLOG records to some number of standby servers in order to keep them current. This feature was added to …

  1.  We need to offer a high available architecture for the Postgre layer. (clustered, active active, replication… etc.) We can choose any one of the High Availability Architecture approach a)      High availability in PostgreSQL DB  by using Rep Manager …

About Postgresql Training Course:- In this course you will learn the essential details of PostgreSQL Administration including PostgreSQL architecture, configuration, maintenance, monitoring, backup, recovery, and data movement. This course is designed for people with experience in database administration and who …