Unable to use pg_verify_checksums

Hello, I am using postgres version 11, in the process of upgrade using pg_upgrade I am trying to run checksums on version 11 but getting error pg_verify_checksums: data checksums are not enabled in cluster when trying to enable /pg_verify_checksums: unrecognized option '--enable' I need help on

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

On 11/3/22 18:50, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: It isn't you where using pg_ctl and in the Debian/Ubuntu packaging the better option for that is pg_ctlcluster. I generally use the systemd scripts to start/stop Postgres instances, 

Re: Postgres to edb AS, need conversion?

On 11/3/22 04:44, milist ujang wrote: Hi all, Anyone have experiences or someone from edb can guid about change engine from postgres open source to edb as, di I need to convert the data or simply plug-and-play? Or need run a tool to add catalog table owned by edb as? You'd better ask EDB. -

Re: Postgres to edb AS, need conversion?

So, do I have to perform conversion/migration? On Thursday, November 3, 2022, Abdul Sayeed wrote: > After migration you need to execute below command from SQL Prompt: > > > > vacuum (verbose, analyze); --> to update statistics. > > Rest is good. > > > Regards, > Abdul Sayeed > > > -- > Thanks

autovacuum hung on simple tables

Hi All, I'm still trying to get a better understanding of the autovacuum process. This is a different postgres installation as my previous posts and confusing me in new ways. Still 11.4 running on CentOS 7 and 8 nvme in software raid This issue started with postgres "...not accepting commands t

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> So only "postgres" can edit the files that must be so edited. > > That is not true [sudo vi some-file] which opens [it for editing]. By all means. I didn't bother to spell that out; > It isn't you where using pg_ctl an

Re: shutdown Postgres (standby) host causing timeout on other servers in replication

On 11/3/22 15:55, Joanna Xu wrote: Hi All, We have PostgreSQL master-slave replication configuration with 4 servers. After shutting down one standby server, we found below errors on all other 3 servers and the applications couldn’t access the database due to the timeout. DAO-2 datasour

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

On 2022-11-03 15:37:07 -0700, Adrian Klaver wrote: > On 11/3/22 14:49, Bryn Llewellyn wrote: > > So only "postgres" can edit the files that must be so edited. > > That is not true: > > aklaver@arkansas:~$ whoami > aklaver > > > aklaver@arkansas:~$ sudo vi /etc/postgresql/14/main/pg_hba.conf > [

Re: shutdown Postgres (standby) host causing timeout on other servers in replication

Joanna Xu writes: > We have PostgreSQL master-slave replication configuration with 4 servers. > After shutting down one standby server, we found below errors on all other 3 > servers and the applications couldn't access the database due to the timeout. > DAO-2 datasource connection failure:Ti

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

On 11/3/22 14:49, Bryn Llewellyn wrote: I should make it clear that my VM has four "ordinary" users. Two are present on first use when VM creation finishes: the system administrator (called "parallels") and, of course, "root". The "parallels" user is enabled for "sudo". Installing PG brings "p

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

> david.g.johns...@gmail.com wrote: > > Some repetition of what Adrian just posted ahead... > >> b...@yugabyte.com wrote: >> >> How can it be that the PG doc itself leads you by the hand to a regime where >> you need to use undocumented features? > > The documentation tries to make clear that

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> Adrian gave me this link: >> https://ubuntu.com/server/docs/databases-postgresql >> Of course I'd read that right at the outset. The subtext is loud and clear. >> You need to do some things as the "postgres" user and some thi

shutdown Postgres (standby) host causing timeout on other servers in replication

Hi All, We have PostgreSQL master-slave replication configuration with 4 servers. After shutting down one standby server, we found below errors on all other 3 servers and the applications couldn't access the database due to the timeout. DAO-2 datasource connection failure:Time out waiting for

Re: Some questions about Postgres

Thanks Christophe. Yes that is the article and I read the response as well. On Thu, Nov 3, 2022 at 10:42 AM Christophe Pettus wrote: > > > > On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > > I read an old article comparing MySQL to Postgres and wanted to get > answers to following questions.

Re: Some questions about Postgres

> On Nov 3, 2022, at 10:38, Siddharth Jain wrote: > I read an old article comparing MySQL to Postgres and wanted to get answers > to following questions. Given your questions, I suspect that you read the technical note from Uber about why they switched back to MySQL from PostgreSQL. There

Some questions about Postgres

Hi all, I am new to Postgres. I read an old article comparing MySQL to Postgres and wanted to get answers to following questions. All questions are w.r.t. Postgres 14: - do postgres secondary indexes point directly to tuples on disk? - does postgres use a separate process for each connection? - d

Re: pg_restore error on function

On 11/3/22 09:57, Adrian Klaver wrote: On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to say

Re: pg_restore error on function

"David G. Johnston" writes: > On Thu, Nov 3, 2022 at 8:39 AM Post Gresql wrote: >> Could it be that the >> create function . >> in the dump file does not implicitly create the schema as a >> create table . >> would? > I don't know where you got the idea that a schema is implicitly created via >

Re: pg_restore error on function

On 11/3/22 08:38, Post Gresql wrote: On 2022-11-03 15:43, Adrian Klaver wrote: On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U pos

Re: pg_restore error on function

On Thu, Nov 3, 2022 at 8:39 AM Post Gresql wrote: > > On 2022-11-03 15:43, Adrian Klaver wrote: > > On 11/3/22 07:28, Post Gresql wrote: > >> Hello > >> > >> I first successfully ran > >> > >> pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema > --no-owner -v my_db > >> > >> b

Re: pg_restore error on function

On 2022-11-03 15:43, Adrian Klaver wrote: On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump fa

Re: pg_restore error on function

On 2022-11-03 15:57, Adrian Klaver wrote: On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to

Re: Reducing bandwidth usage of database replication

Sascha Zenglein wrote on 11/2/22 7:56 AM: Hi all, I want to use the postgres-native logical replication to have multiple clients receive and send data to a central database. Real-time is far less important than network usage, and with my current test setup it appears both instances communicate

Re: pg_restore error on function

On 11/3/22 07:45, Ron wrote: On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db What was the *complete* pg_dump command? I'm going to say the above. -- Adrian Klaver adrian.kl

Re: pg_restore error on function

On 11/3/22 09:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to databas

Re: pg_restore error on function

On 11/3/22 07:28, Post Gresql wrote: Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to databas

pg_restore error on function

Hello I first successfully ran pg_dump -U postgres -b -E UTF8 -f my_dump --format=custom -n my_schema --no-owner -v my_db but then pg_restore --single-transaction -v -U postgres -O -e -d my_other_db my_dump failed with pg_restore: connecting to database for restore pg_restore: creating FUNC

Re: unable to install postgreql 13.4

On 11/3/22 01:48, shashidhar Reddy wrote: Hello, I need to install postgresql 13.4 on development server , but getting below errors, please help to resolve this sudo apt-get install postgresql-13.4 Reading package lists... Done Building dependency tree Reading state information... Done E: Un

Re: Postgres to edb AS, need conversion?

After migration you need to execute below command from SQL Prompt: vacuum (verbose, analyze); --> to update statistics. Rest is good. Regards, Abdul Sayeed On Thu, Nov 3, 2022 at 3:15 PM milist ujang wrote: > Hi all, > > Anyone have experiences or someone from edb can guid about change engi

Would postgresql add a pg_sleep_backend() method

Postgresql already pg_cancel_backend and pg_terminate_backend which will stop a backend. Sometimes the system is busy (e.g. disk IO) for a long time, but I don’t want to stop each backend If postgres has a sleep method, I may let some pid just sleep a few times, so disk busy may decend and the m

Postgres to edb AS, need conversion?

Hi all, Anyone have experiences or someone from edb can guid about change engine from postgres open source to edb as, di I need to convert the data or simply plug-and-play? Or need run a tool to add catalog table owned by edb as? -- regards ujang jaenudin | DBA Consultant (Freelancer) http://o

AW: Reducing bandwidth usage of database replication

It is, unfortunately, too much for our requirements. I was able to increase wal_receiver_status_interval so that the publisher only contacts the subscriber every 30 seconds instead of every 10. But I am not able to increase it further. Sascha Zenglein Produktentwicklung [cid:gessler_email_log

Re: unable to install postgreql 13.4

Thank you Julien! On Thu, Nov 3, 2022 at 12:52 PM Julien Rouhaud wrote: > On Thu, Nov 03, 2022 at 12:38:53PM +0530, shashidhar Reddy wrote: > > Hello Julien, > > > > Actually production databases are on version 13.4 and the team needs the > > same version to test something on it, is there a way

Re: unable to install postgreql 13.4

On Thu, Nov 03, 2022 at 12:38:53PM +0530, shashidhar Reddy wrote: > Hello Julien, > > Actually production databases are on version 13.4 and the team needs the > same version to test something on it, is there a way to install the same > version? Ah I see. You can try to use https://apt-archive.po

Re: unable to install postgreql 13.4

Hello Julien, Actually production databases are on version 13.4 and the team needs the same version to test something on it, is there a way to install the same version? On Thu, Nov 3, 2022 at 12:29 PM Julien Rouhaud wrote: > Hi, > > On Thu, Nov 03, 2022 at 12:18:05PM +0530, shashidhar Reddy wro