Question on Open PostgreSQL Monitoring

Hello, I am not sure if this is the right email group to ask about Open PostgreSQL Monitoring (https://opm.readthedocs.io/opm-core/index.html). It appears there is no update to this tool since at least 2019. Since members from this email group has lots of expertise on PostgreSQL, I thought I

Question on tablefunc extension

Hello, We downloaded postgresql software from this site, https://www.postgresql.org/ftp/source/v12.1/, as a tar ball file (postgresql-12.1.tar.bz2). So we didn't do install the 'postgresql-contrib' option. Our developers asked that we add on the "tablefunc" extension to the existing postgres

pg_upgrade question

Hi PostgreSQL Admin, I am trying to find out if there is any step by step instruction to reconcile old data dir and upgraded data dir after using "-link" option to do an upgrade. I ran this to do an upgrade from 11.5 to 12.1: pg_upgrade -d /hostname/pg/dev115/data -D /hostname/pg/dev121upg/data

RE: Upgrade check failed from 11.5 to 12.1

/data | grep -i "Bytes per WAL segment" Bytes per WAL segment:16777216 -Original Message- From: Adrian Klaver Sent: Saturday, December 19, 2020 10:28 AM To: Lu, Dan ; Tom Lane Cc: pgsql-gene...@postgresql.org Subject: Re: Upgrade check failed from 11.5 to 1

RE: Upgrade check failed from 11.5 to 12.1

g/NewInstance/data"? -Original Message- From: Tom Lane Sent: Friday, December 18, 2020 4:55 PM To: Lu, Dan Cc: pgsql-gene...@postgresql.org Subject: Re: Upgrade check failed from 11.5 to 12.1 "Lu, Dan" writes: > I am trying to upgrade an instance of PostgreSQL in unix fr

Upgrade check failed from 11.5 to 12.1

Hello PostgreSQL experts, I am trying to upgrade an instance of PostgreSQL in unix from 11.5 to 12.1. I got the following error on upgrade verification step. Is this not allowed? UNIX:> pg_upgrade -d /hostname/pg/dpoc/data -D /hostname/pg/dpoc/data -b /hostname/pg/PostgreSQL-11.5/bin -B /host

Question on removing primary replication node using repmgr?

Hello, I used repmgr extension for Postgresql to setup replication. I want to remove the replication because it appears WAL files are generated even after unregistering the standby instance and putting primary instance in no archivelog mode. Can you help? host:> repmgr -f /home/postgresdbad

Question on banner display after PG initial connection

Hello PostgreSQL Admin, I am fairly new to PostgreSQL. I am a curious question regarding the banner message displayed after connecting to version 12.1 of PostgreSQL. Is there a way to get rid of this line "SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compr

RE: Question on upgrading postgresql from 10.7 to 11.5

Thanks! I was misled by "pg_controldata" keyword and totally ignored the WAL segment size variable. Much appreciated for your help. -Original Message- From: Julien Rouhaud [mailto:rjuju...@gmail.com] Sent: Wednesday, December 25, 2019 10:36 AM To: Lu, Dan Cc:

Question on upgrading postgresql from 10.7 to 11.5

Hello, I am trying to upgrade my PG instance from 10.7 to 11.5. I got an error in doing so. Any idea what I am missing? Example: pg_upgrade -d /hostname/pg/dpoc/data -D /hostname/pg/dpoc115/data -b /hostname/pg/PostgreSQL-10.7/bin -B /hostname/pg/PostgreSQL-11.5/bin -p 5432 -P 9432 -c -v Err

RE: Postgres 10.7 Systemd Startup Issue

Thank you so much for your help! -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, October 14, 2019 2:19 PM To: Lu, Dan Cc: Christopher Browne ; Francisco Olarte ; pgsql-gene...@postgresql.org Subject: Re: Postgres 10.7 Systemd Startup Issue "Lu

RE: Postgres 10.7 Systemd Startup Issue

what options were used to configure the PG instance? We will be taking over administration of existing PG instance, but we would need to know what configuration option was used during build. Your feedback and help is much appreciated. Dan -Original Message- From: Lu, Dan Sent: Friday

RE: postgresql: Help with hstore hextension

Thanks for the information. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, September 05, 2019 12:06 PM To: Lu, Dan Cc: pgsql-gene...@postgresql.org; Kelly, Kevin Subject: Re: postgresql: Help with hstore hextension "Lu, Dan" writes: > We a

postgresql: Help with hstore hextension

Hello, We recently downloaded the "postgresql-10.7.tar.bz2" file from https://ftp.postgresql.org/pub/source/v10.7. We configure our installation as followed: ./configure --prefix=/hostname/pg/PostgreSQL-10.7 --with-systemd We created new database and things are working fine. We are now trying

RE: Postgres 10.7 Systemd Startup Issue

Hello All, I ended up removing all configuration. Re-unzip the binary tar files we downloaded. Re-configure with the option "--with-systemd" and now it is working. We really appreciate all your help! Dan -Original Message----- From: Lu, Dan Sent: Friday, June 07, 2019 10:11 A

RE: Postgres 10.7 Systemd Startup Issue

SQL Server and MySQL in production so far. Dan -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, June 07, 2019 10:04 AM To: Lu, Dan Cc: Christopher Browne ; Francisco Olarte ; Kelly, Kevin ; pgsql-gene...@postgresql.org Subject: Re: Postgres 10.7 Systemd Startup

RE: Postgres 10.7 Systemd Startup Issue

/hostname/pg/PostgreSQL-10.7 3) Start PostgreSQL instance Any more suggestion? Dan From: Lu, Dan Sent: Friday, June 07, 2019 8:46 AM To: 'Christopher Browne' ; Tom Lane Cc: Francisco Olarte ; Kelly, Kevin ; pgsql-gene...@postgresql.org Subject: RE: Postgres 10.7 Systemd Startup Issue Th

RE: Postgres 10.7 Systemd Startup Issue

[mailto:cbbro...@gmail.com] Sent: Thursday, June 06, 2019 9:19 PM To: Tom Lane Cc: Francisco Olarte ; Kelly, Kevin ; pgsql-gene...@postgresql.org; Lu, Dan Subject: Re: Postgres 10.7 Systemd Startup Issue On Thu, Jun 6, 2019, 8:19 PM Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: Francisco

Postgresql backup via LVM snapshot?

Hello, Would you be able to confirm for me that a host level LVM snapshot of the PGDATA directory along with PG_WAL directly via LVM backup is supported way of backup and restore? I read about this here: https://dba.stackexchange.com/questions/145361/backup-standby-database-using-lvm-snapshot

RE: Question on binding VIP to Postgresql instance

uot;*"? -Original Message- From: Chris Coutinho [mailto:c.couti...@redstack.nl] Sent: Tuesday, May 07, 2019 8:40 AM To: Lu, Dan ; David G. Johnston ; Alvaro Aguayo Garcia-Rada ; pgsql-gene...@postgresql.org Subject: RE: Question on binding VIP to Postgresql instance I think getting

Question on binding VIP to Postgresql instance

Good day, Would you be able to help direct me to instruction or implementation step to bind a VIP to a Postgresql instance? I did research and understand that Postgresql does support binding of VIP, but I can't find documentation to implement the solution. Any feedback is greatly appreciated.

Version 11.2 for SLES 12?

Hello, Do you happen to know when version 11.2 will be available for download via rpm option? https://www.postgresql.org/download/linux/suse/ [cid:image001.png@01D4C45C.FD0A6820] IMPORTANT: The information contained in this email and/or its attachments is con

RE: Question on postgresql.conf

like `hostname` derived from Unix shell or I have to hardcode the name of the host like " include /nfs/global/postgres-host123.cnf -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, July 31, 2018 9:52 AM To: Lu, Dan Cc: David G. Johnston ; Alvaro Aguayo G

RE: Question on postgresql.conf

/hostname/postgres/log -o config_file="/nfs/global/postgres-`hostname`.cnf" Machine2: (notice we are using the `hostname` unix variable) pg_ctl start -D /hostname/postgres/data -l /hostname/postgres/log -o config_file="/nfs/global/postgres-`hostname`.cnf" From: Lu, Dan Sent: Tues

RE: Question on postgresql.conf

/postgres-machine3.cnf From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Tuesday, July 31, 2018 1:48 AM To: Alvaro Aguayo Garcia-Rada Cc: pgsql-gene...@postgresql.org; Lu, Dan Subject: Re: Question on postgresql.conf On Monday, July 30, 2018, Alvaro Aguayo Garcia-Rada mailto:aagu

Question on postgresql.conf

Hello PostgreSQL Support Admin, My name is Dan Lu. I am fairly new to PostgreSQL. I have experience working with Oracle/MySQL database. I am going through the PostgreSQL manual and came across a question hoping you can help me. It appears the "postgresql.conf" file is needed by default to s