Comments (2)
When you exec into the pod there's a postgres.yml file. Can you check if credentials are set under postgresql.authentication
?
from postgres-operator.
Hi @FxKu, this is how the file looks like -
root@control-plane-database-0:/home/postgres# cat postgres.yml
...
...
...
postgresql:
authentication:
replication:
password: jtSN0HGJTicu14fv0VKjUd0L5hxjvvthwJkCumpixoBNqX5xvQULNNvSkaksP76j
username: standby
superuser:
password: PPusPhzipDjidlNjY2wOcp6GlJ1opre6xtbnDujFWDXwfhGauINz0wRYxnzkQAji
username: postgres
basebackup_fast_xlog:
command: /scripts/basebackup.sh
retries: 2
bin_dir: /usr/lib/postgresql/15/bin
callbacks:
on_role_change: /scripts/on_role_change.sh zalandos true
connect_address: <som_IP_addr>:5432
create_replica_method:
- basebackup_fast_xlog
data_dir: /home/postgres/pgdata/pgroot/data
listen: '*:5432'
name: control-plane-database-0
parameters:
archive_command: /bin/true
bg_mon.history_buckets: 120
bg_mon.listen_address: '::'
extwlist.custom_path: /scripts
extwlist.extensions: btree_gin,btree_gist,citext,extra_window_functions,first_last_agg,hll,hstore,hypopg,intarray,ltree,pgcrypto,pgq,pgq_node,pg_trgm,postgres_fdw,tablefunc,uuid-ossp,pg_partman
log_destination: csvlog
log_directory: ../pg_log
log_file_mode: '0644'
log_filename: postgresql-%u.log
log_rotation_age: 1d
log_truncate_on_rotation: 'on'
logging_collector: 'on'
pg_stat_statements.track_utility: 'off'
shared_buffers: 32MB
shared_preload_libraries: bg_mon,pg_stat_statements,pgextwlist,pg_auth_mon,set_user,pg_cron,pg_stat_kcache
ssl: 'on'
ssl_cert_file: /run/certs/server.crt
ssl_key_file: /run/certs/server.key
pg_hba:
- local all all md5
- hostssl all +zalandos 127.0.0.1/32 pam
- host all all 127.0.0.1/32 md5
- hostssl all +zalandos ::1/128 pam
- host all all ::1/128 md5
- local replication standby trust
- hostssl replication standby all md5
- hostnossl all all all reject
- hostssl all +zalandos all pam
- hostssl all all all md5
pgpass: /run/postgresql/pgpass
use_unix_socket: true
use_unix_socket_repl: true
restapi:
connect_address: <some_IP_addr>:8008
listen: :8008
scope: control-plane-database
from postgres-operator.
Related Issues (20)
- PodDisruptionBudget master label selector Flag not working via Helm HOT 1
- Feature: Inherit annotation from label (or the other way around)
- `Turn a normal cluster into a standby` does not seem to work HOT 1
- Backup job images service account auth to access s3 buckets due to outdated awscli HOT 1
- No ARM64 support on Helm chart HOT 3
- High List API Requests in a S3 Bucket HOT 1
- Major Version Upgrade of Standby Clusters? HOT 2
- Recovery not moving forward after changing clone timestamp
- inherited_annotations / inherited_labels do not update PVCs / PDBs / secrets with labels/annotations if they were created before applying the config HOT 1
- infrastructure_role_secrets field doesn't work as expected.
- postgres-operator-ui:v1.12.0 exec format error on ARM64 HOT 7
- Image postgres-operator:v1.12.0 not able in zalando registry HOT 7
- [UI] /js/build/app.js not found HOT 2
- GCS WAL backup config per cluster
- Pooler: WARNING server login failed: FATAL permission denied for database
- vulnerability reporting for zalando postgres container
- Helm Chart 1.12.1 not available HOT 1
- Postgres Operator Helm Chart Version v1.10.0 HOT 2
- Backups intermittently fail to upload due to "request body too small" error (wal-g > backblaze s3 storage) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgres-operator.