Azure / Azure/azure-quickstart-templates
Postgres on Ubuntu Replication Issue
- 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