Explore PostgreSQL on Experts Exchange

Expert Solutions for Your Tech Problems


PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its...

Read more
  • 2.7K Content
  • 1.1K Contributors

Expert Spotlight
Chief Technology Ninja

A Tech Start-up Owner 24x7x365 :) ... Geeky, Matrix Fan, Love To Travel And Explore Exotic Places.

Research Solution

upgrade the PostgreSQL bundled with Alfresco community 5.0 ourselves to latest PostgreSQL



We are using alfresco community 5.0 and the PostgreSQL DB using(bundled with Alfresco standalone


ClickHouse: One Year!

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.

This is a cool tool to help visualize explain plans in …

This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Troubleshooting Solution

Self hosting OpenStreetMap OSM and Layers

If we self hosted the full OSM database and what ever else is needed, could we be 100% independent …
Research Solution

update all statistic and rebuilding all index of a PostgresQL 9.3 database



for PostgreSQL 9.3.x usually how you guy automated the index rebuild?

I see this link

Troubleshooting Solution

Does the vpxd.log contain the VCSA postgres DB table with tasks and events info?

byStan J

I am in a conversation with VMware support about events and logs in order to locate a reason why

Troubleshooting Solution

want to backup postgres database and elasticsearch from production


Hi Experts,

      I want to backup Postgres database and copy the elasticsearch index to zip file

Troubleshooting Solution

embedded postgresql to be exempted fr CIS hardening & how to onboard it to SOC


Our GIS (Geospatial Info System) vendor replied me that 

"their ArcGIS Data Store is a PostgreSQL

Research Solution

PostgreSQL HA and DR guide


Any compressive HA and DR guide for PostgreSQL?

I know from MySQL, MariaDB and PXC that this kind …
Troubleshooting Solution

What am i doing wrong specify a Date field as a parameter

I have the script below that should take screen values , put them through a processor
and then write …
Troubleshooting Solution

Tableau app is down please help


Hello Experts, I need your help.

I manage a Tableau app (Version 2019.4.19, postegresql ) hosted on a

Advice Solution

Does anyone know how to refresh a non-prod Aurora Postgres from Production Aurora  Postgres where non-prod cannot access Prod?


Does anyone know how to refresh a non-prod Aurora Postgres from Production Aurora  Postgres where

Troubleshooting Solution

How do I resolve Error 42883 function does not exist while writing to database

I am working in postgresql database with Dapper .environment
I have a windows form  that tries to …
Troubleshooting Solution

How to drop a user from a postgres db

Hello experts,
I have made a mistake while creating a user in a postgres db, I added an extra space …
Troubleshooting Solution

PostgreSQL access in container

Probably a dumb newbie question but I don't seem to find an easy answer googling it.

I have …
Troubleshooting Solution

Passing variable into Procedure


I would like to include the ' when I pass in a variable into function.  I am using …
Research Solution

Set up Postgresql role/ security with access to a schema


I am trying to build an application using remote developers. I would like to protect certain …
Troubleshooting Solution

psql not taking password from pgpass file

I ran the command - strace psql -U postgres -h db -U seenter -d seenter
It gave the following output …
Troubleshooting Solution

move hundreds of partitions of a table to new tablespace with exit script

    I need to move many partitions of a particular table to a new tablespace with 'alter …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more