Azure / Azure/azure-quickstart-templates

Postgres on Ubuntu Replication Issue

Open
#2,103 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

I feel I may be missing something but I had been using the following repo:

https://github.com/Azure/azure-quickstart-templates/tree/master/postgresql-on-ubuntu

I followed all the instructions but couldn't get streaming replication working. It took me a few days as i expected it was something I was doing wrong with permissions but it _seems_ that you do not set the data directory after you have done all your configuration in setup_datadisks.

As soon as I set the data_directory in postgressql.conf in /etc/postgresql/9.3/main to point at the new data directory (data_directory = '/var/lib/kafkadir/main') it all started working.

However, this feels very basic as it simply wouldn't work without this being set so i can't believe I am the first to find it .... is this really a bug or have i done something that would have caused this not to work?

thanks,
steven

Contributor guide

No contributing guide indexed for this repository

Research direction

Inspect the postgresql-on-ubuntu template, starting with setup_datadisks and the PostgreSQL configuration at /etc/postgresql/9.3/main/postgresql.conf. Reproduce the deployment and check whether data_directory is configured for the new data directory. Done means streaming replication works without the reported manual change, or the required configuration is clearly documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, ubuntu
Domain
databases, infrastructure
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.