Notes on Installing PostgreSQL on All Platforms: /home/_Documentation

×

The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!

Notes on Installing PostgreSQL on All Platforms

_Documentation

Notes on Installing PostgreSQL on All Platforms

Notes on Installing PostgreSQL on All Platforms

If you are using PostgreSQL, you will need to increase the join collapse limit. Edit postgresql.conf and change the following line:

# join_collapse_limit = 8

to

join_collapse_limit = 10

If you do not do this step, you may see the following error when running complex queries: org.postgresql.util.PSQLException: ERROR: failed to build any 8-way joins

Pages

Documentation Home

Laboratory Data

Research Studies

Tutorial: Security

Projects and Folders

Installation Basics

Install LabKey Server (Windows Graphical Installer)

Install LabKey Manually

Install a Remote Pipeline Server via the Windows Installer

PremiumStats Install

Supported Technologies

Troubleshoot Installation

Common Install Tasks

Install Microsoft SQL Server

Install PostgreSQL (Windows)

Install PostgreSQL (Linux, Unix or Macintosh)

Install LabKey Server on Solaris

Notes on Installing PostgreSQL on All Platforms

Install and Set Up R

Install SAS/SHARE for Integration with LabKey Server

Configure Webapp Memory

Set Up Robots.txt and Sitemaps

GROUP_CONCAT Install

Example Setups and Configurations

Backup and Maintenance

Staging, Test and Production Servers

Products and Services

expand all collapse all