question on streaming replication

Hi, I have postgres edb 9.6 version, i have below query to solve it out. i have configured streaming replication having master and slave node on same server just to test it. All worked fine but when i made slave service stop, and create some test databases in master, after then i made slave ser

how to check PEM version

Hi, I have installed pem in centos 7, now i want to check the version of PEM using sql query. Please let me know, how should i do that. My postgres version is 11.8 Regards, Atul

pgbouncer installation example (Step by step)

Hi Team, Please share a clean example of installing, configuring and testing pgBouncer. Your official links are not organized so I need an example of PgBouncer with organized steps. Regards, Atul

remgr installation and configuration steps required

Hi, I have 3 different servers, i want to configure streaming replication (1 master and 2 slaves) using repmanager. Please share the installation and configuration steps for the same. Note: the steps should be organized. Regards, Atul

database shutting down

Hi, I am configuring repmgr, so in postgresql.conf when i changed the parameter share_preload_libraries='repmgr', my database server is not starting. When i comment that parameter, database server started. Please help why that parameter is stopping database to start. Regards, Atul

High CPU utilization

Hi, I have high CPU utilization on my server, when I checked pg_stat_activity , I found that I am attaching here as an attachment. I am unbale to catch the actual cause. Please help me in rectifying so that CPU consumption can be reduced. Regards, Atul

psql asks for password despite configuring trust authentication

hi, My problem is, that I am always asked for password when trying to interact with the database or access it, although the authentication is set to trust for all users and databases. Please help. Regards, Atul

archive command in streaming replication in windows server

hi, I am trying to configure streaming replication on windows server. i have postgres version 10 after successful installation of postgres, I create a archive directory "C:\Program Files\PostgreSQL\10\archive_files" and here in archive_flies, I need to copy the wal files. in postgresql conf fi

Re: archive command in streaming replication in windows server

e(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. 0 file(s) copied. Please help. Regards, Atul On 10/30/20, Andreas Kretschm

identify partitioning columns and best practices of partitioning in prod enviornments

Hi, I want to about best practices of partitioning in prod environments and how to identify partitioning columns. Regards, Atul

autovacuum recommendations for Large tables

Hi, I have a large table having no. of live tuples approx 7690798868 and no. of dead tuples approx 114917737. So Please share autovacuum tuning recommendations for this table so that our time can be spent better than repeatedly vacuuming large tables. Please help. Regards, Atul

Re: autovacuum recommendations for Large tables

-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> > <#m_-4472748644679516424_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > On Mon, Nov 16, 2020 at 8:20 PM Atul Kumar wrote: > >> Ok, >> >> Right Now the autovacuum setting for th

vacuum vs vacuum full

Hi, We have a table of 3113GB, and we are planning to vacuum it in non business hours i.e. 12AM to 4AM, So my queries are: 1. What should be perform on the table Vacuum or Vacuum full ? 2. Do we need to perform Analyze also? 3. Will the operation be completed in the given time frame? how to check

maintenance_work_mem

Hi, I have below queries: 1. How do i check the maintenance_work_mem for current session, before setting some other value for this parameter for the same session. 2. and How do I set maintenance_work_mem for a session only, and how will it be "rollback" once my maintainance work is done, Do I ne

meaning of (to prevent wraparound) ..??

Hi, I have autovacuum running in background from last 30-40 minutes but I noticed that it is with "(to prevent wraparound)" say for example autovacuum: VACUUM trk.move (to prevent wraparound). So what is the meaning of "(to prevent wraparound)" here ? Will it impact the autovacuum anyhow ? Plea

Re: meaning of (to prevent wraparound) ..??

vacuum is doing it’s job — most likely no need to be > alarmed here based on this alone. The autovacuum is helping avoid a txid > limit. This is part of PostgreSQL MVCC. You may check that section of the > documentation for more information on this. > > On Wed, Nov 25, 2020 at 22:54 At

error on connecting port 5432

Hi, When I m creating a test db user using below command using root OS user sudo -u postgres createuser -p 5432 --pwprompt testuser I am getting the attached error of port. But my postgres services are running fine on port 5432, I am sharing the screenshot of that also. So please help me in le

Re: error on connecting port 5432

AM, Atul Kumar wrote: > >> Hi, >> >> When I m creating a test db user using below command using root OS user >> sudo -u postgres createuser -p 5432 --pwprompt testuser >> >> I am getting the attached error of port. >> >> But my postgres servi

Re: error on connecting port 5432

hi, There is no directory of postgresql in /var/run. Please help me out. Regards, Atul On 12/1/20, Tom Lane wrote: > Atul Kumar writes: >> Just to clarify that I am at root OS user, trying to create a test user >> using postgres user(-u) with create user command. > >

Re: error on connecting port 5432

not throw such error. Please help me. Regards, Atul On 12/1/20, Tom Lane wrote: > Atul Kumar writes: >> Just to clarify that I am at root OS user, trying to create a test user >> using postgres user(-u) with create user command. > > Given the reference to /var/run/p

Required checkpoints occurs too frequently

Hi, We are getting this alert frequently "Required checkpoints occurs too frequently" on postgres version 11.8 The RAM of the server is 16 GB. and we have already set the max_wal_size= 4096 MB min_wal_size= 192 MB. Please help me in optimizing the same to avoid this alert. Regards, Atul

"Required checkpoints occurs too frequently"

Hi, We are getting this alert frequently "Required checkpoints occurs too frequently" on postgres version 11.8 The RAM of the server is 16 GB. and we have already set the max_wal_size= 4096 MB min_wal_size= 192 MB. Please help me in optimizing the same to avoid this alert. Regards, Atul

Re: "Required checkpoints occurs too frequently"

Ok I m sorry, I had no idea of it. On Friday, December 11, 2020, Stephen Frost wrote: > Greetings, > > * Atul Kumar (akumar14...@gmail.com) wrote: > > Please help me in optimizing the same to avoid this alert. > > Please don't post the same question to multiple

protect data of postgres database

Hi, How can I protect my data by using any security on my postgres database. Please help me. Regards, Atul

Re: PostgreSQL HA

Use xdb, simpler and better On Saturday, December 26, 2020, venkata786 k wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Regards, >

alter system command

hi, I have set archive_command like below: alter system set archive_command ='pgbackrest --stanza=main archive-push %'; then I reloaded the conf file select pg_reload_conf(); now when i checked it using the show command like it gave me correct output postgres=# show archive_command;

postgres optimization

Hi, I am new to postgres and I find optimization as a challenge in postgres being a newbee. As I am unable to understand explain plan and its components like merge join, hash join, loop join etc. I get totally confused about how to read it and how to understand what thing is making my query slow

migration from postgres to enterprosedb

Hi, I have postgres setup of having version postgres 9.5 and I want to migrate it to enterprisedb 10. So Please help me for the same as I am newbee for postgres migration. Regards, Atul

upgrade postgres 9.5 to 9.6

Hi, I want to upgrade my server from postgres 9.5 to 9.6, but my DB size is in TBs and I want to do it in minimum downtime (2-3 hours) so please help me how should I perform it. Please share the document, if possible, it will be grateful. Regards, Atul

Re: upgrade postgres 9.5 to 9.6

; > Regards, > Enrico > > On Fri, 15 Jan 2021 18:47:51 +0530 > Atul Kumar wrote: > > > Hi, > > > > I want to upgrade my server from postgres 9.5 to 9.6, but my DB size > > is in TBs and I want to do it in minimum downtime (2-3 hours) so > > please hel

Re: Accounting for between table correlation

Hi Alexander, As per Ron, you are not supposed to ask your questions here. As According to him, we should keep on doing research on internet rather than asking for support directly even you have done enough research and until unless “Ron” won’t be satisfied you have to do keep on researching.

Re: Accounting for between table correlation

help. It would be helpful for all of us. Regards Atul On Friday, January 15, 2021, o1bigtenor wrote: > On Fri, Jan 15, 2021 at 9:29 AM Atul Kumar wrote: > > > > Hi Alexander, > > > > As per Ron, you are not supposed to ask your questions here. > > > >

Re: Best tools to monitor and fine tune postgres

Hi o1bigtenor, Now what will you say about below query that he should have come with some research before asking here ? On Friday, January 15, 2021, svsn raju wrote: > Hi All, > > Can someone please suggest some tools to monitor and tune postgres > > > Sent from Yahoo Mail on Android >

Re: Best tools to monitor and fine tune postgres

. Johnston wrote: > On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar wrote: > >> Hi o1bigtenor, >> >> Now what will you say about below query that he should have come with >> some research before asking here ? >> > > Yes. The question gets asked frequently so if

Re: Best tools to monitor and fine tune postgres

repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”. On Friday, January 15, 2021, Atul Kumar wrote: > Again Thanks alot David for ur response. > > You expect everyone to be perfect which cannot happen. > > And related to thread, if someone

Re: Best tools to monitor and fine tune postgres

Yes you are right. And it seems for those that ignore queries to answer. Your mates have already said that they ignore answering repeated questions. On Friday, January 15, 2021, Hemil Ruparel wrote: > http://catb.org/~esr/faqs/smart-questions.html > > On Fri, Jan 15, 2021 at 9:58 PM A

Re: Best tools to monitor and fine tune postgres

author’s time. And I have no doubt that you will waste more time of yours as well as of us by giving some kore excuses. On Saturday, January 16, 2021, Adrian Klaver wrote: > On 1/15/21 8:28 AM, Atul Kumar wrote: > >> And basically you are improving your knowledge as you are exp

upgrade using logical replication

Hi, We are planning to upgrade from postgres 9.5 to postgres 10, on centos version 6.8, We have a database of around 400GBs. We need to perform the upgrade activity with minimum downtime (around 1-2 hours). We are thinking of logical replication for the same. but The issue is we already have co

pljava": ERROR

Hi, When I was trying to upgrade from postgres 9.5 to postgres 10 using command su - enterprisedb/usr/edb/as10/bin/pg_upgrade -d /data/apps/ppas/9.5/data -D /data/edb/as10/data -U enterprisedb -b /usr/ppas-9.5/bin/ -B /usr/edb/as10/bin/ -p 5444 -P 5445 --check I got below error: could not load

vacuum is time consuming

Hi, We have DB of 400GBs, Server RAM is 160GBs. CPU consumption is 1-3% only. We have configured maintenance_work_mem to 10GBs and restarted the postgres service. We have done upgrade from postgres 9.5 to 9.6, then when we run vacuum analyze on database, it is taking more than 5 hours and stil

Re: vacuum is time consuming

Ok Martin, I got ur ur point of max limit of maintenance_work_mem is 1 GB but there is nothing mentioned about the same in postgresql.conf as remarks for this specific parameter. Is there any other option to increase the speed of vacuum? Regards Atul On Tuesday, February 2, 2021, Martín Mar

vacuumdb not letting me connect to db

Hi, I have 160 GB of RAM, postgres 9.6 is running on the server. after upgrade I ran the below command: "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300 --analyze-only after running that command I was not able to connect the database using psql for few minutes. After 20-

Re: vacuumdb not letting me connect to db

, February 4, 2021, Laurenz Albe wrote: > On Thu, 2021-02-04 at 16:56 +0530, Atul Kumar wrote: > > I have 160 GB of RAM, postgres 9.6 is running on the server. > > > > after upgrade I ran the below command: > > > > "/usr/edb/as9.6/bin/vacuumdb" -U 'enterpr

Re: vacuumdb not letting me connect to db

There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck. On Thursday, February 4, 2021, Ravi Krishna wrote: > >The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption) > >but I don’t understand one thing here that if max_co

Re: vacuumdb not letting me connect to db

There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck. On Thursday, February 4, 2021, Ron wrote: > On 2/4/21 5:26 AM, Atul Kumar wrote: > > Hi, > > I have 160 GB of RAM, postgres 9.6 is running on the server. > >

Re: vacuumdb not letting me connect to db

ok, How do I resolve it ? Any suggestions ? On 2/5/21, Ron wrote: > Your problem screams "IO saturation". > > On 2/4/21 12:07 PM, Atul Kumar wrote: >> There is no error message, when I try to connect the database while >> running vacuumdb with 30

Re: vacuumdb not letting me connect to db

Hi Gavan, Thanks for providing the details, I need more clarification on this as how should I analyze that what should be ideal no. of connections should we set to avoid IO overhead based on the available hardware resources. How to do this calculation ? Note: even during 300 threads, my RAM util

delete old cluster after pg_upgrade with -k option

Hi, I have upgrade the postgres cluster from 9.5 to 9.6 using pg_upgarde utility with -k option. Now I just wanted to be confirmed that is it safe to run delete_old_cluster.sh file as we have used -k option that must created hard links with old cluster. Suggestions are welcome.

Streaming replication between different OS

Hi, I have postgres 9.6 cluster running on Centos 6.8, so I just wanted to know that can I configure streaming replication with same postgres version i.e 9.6 running on centos 7. Suggestions are welcome as the Centos versions are different one is 6.8 and second one is 7. Also please let me know

Re: Streaming replication between different OS

Hi Tom, As I am new to postgres, could you help me to in how to check collation and what is de_DE locale ? Regards On Monday, February 22, 2021, Tom Lane wrote: > Ganesh Korde writes: > > On Mon, 22 Feb 2021, 11:48 am Atul Kumar, wrote: > >> I have postgres 9.6

getting tables list of other schema too

Hi, I have postgres 9.6 cluster running on centos 7 machine. when I set search_path to any user made schema with below command [enterprisedb@stg-edb02 ~ 01:51:39]$ psql edb edb=# \c test set search_path to college; and after listing the tables with command \dt, we should get list of tables of

Re: getting tables list of other schema too

t; > HTH, > Thomas > > Le mer. 24 févr. 2021 à 08:54, Atul Kumar a écrit : > >> Hi, >> >> I have postgres 9.6 cluster running on centos 7 machine. >> >> when I set search_path to any user made schema with below command >> >> [enterprisedb@stg-ed

Re: getting tables list of other schema too

I am sorry but I am not clear from your response, as I have created another instance with same version 9.6 but there no system schema or its tables are visible. Please help. On 2/24/21, Francisco Olarte wrote: > On Wed, Feb 24, 2021 at 12:12 PM Francisco Olarte > wrote: >> AFAIK dt list "t

Re: How to know how much CPU, RAM is used by existing 1 database

I hope the below link helps... https://www.enterprisedb.com/blog/monitor-cpu-and-memory-percentage-used-each-process-postgresqlppas-91 On 10/26/22, Rob Sargent wrote: > On 10/26/22 08:26, Yi Sun wrote: >> >> >> On Wed, 26 Oct 2022 at 18:10, jian he >> wrote: >> >> >> >> On Wed, Oct 26, 2022

postgres large database backup

Hi, I have a 10TB database running on postgres 11 version running on centos 7 "on premises", I need to schedule the backup of this database in a faster way. The scheduled backup will be used for PITR purposes. So please let me know how I should do it in a quicker backup for my 10TB database ? Is

confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

Hi, Could someone help me in telling the difference between these three parameters 1. max_standby_archive_delay 2. max_standby_streaming_delay 3. recovery_min_apply_delay My basic motive is to make the standby database server to be delayed to apply the changes on itself, if any data has been acc

Backup schema without data

Hi, Please help me in telling that how I can take the backup of one single schema without its data using pg_dump utility ? So far, I could not find anything suitable for doing so. Regards, Atul

Replicate data from one standby server to another standby

Hi, I have Configured "sync" streaming replication to replicate the data from one primary node to one slave node. Now I want one to add one more node as slave that will replicate the data from previously created slave replica (not from primary replica as we do traditionally). So please let me k

Query to find RDS endpoint

Hi, Could someone help me in sharing a postgresql query to fetch the RDS endpoint ? Postgres version 14.6. I tried to search but couldn't find it. Regards.

strange behavior of .pgpass file

Hi, I found some strange behaviour of postgres superuser password in my existing cluster, below is the basic outline of the setup. 1. version - postgres 12 2. replication - streaming replication async 3. OS- centos7 4. One Master, One Standby I have identical pgpass files on both server postgres

Re: strange behavior of .pgpass file

Please suggest. On Wed, 21 Jun 2023, 02:02 Atul Kumar, wrote: > Th both pgpass files contains details as below: > > *:5432:*:postgres: > > I couldn't find anything wrong there in pgpass. > > and if the issue would have been with .pgpass file only then I would not >

2 master 3 standby replication

Hi, Do we have any solution to Configure an architecture of replication having 2 master nodes and 3 standby nodes replicating the data from any of the 2 master ? Please let me know if you have any link/ dedicated document. Regards, Atul

Re: 2 master 3 standby replication

Hi, Please help me with the query I raised. Regards. On Fri, 23 Jun 2023, 00:12 Atul Kumar, wrote: > Hi, > > Do we have any solution to Configure an architecture of replication having > 2 master nodes and 3 standby nodes replicating the data from any of the 2 > master ? >

connect postgres using url

HI, Could you please help me in telling how I can connect my postgres database using http url ? What steps need to be taken care of ? Please share any referral link, if possible. Regards, Atul

Wrong passwords allowed

Hi, I am having a strange issue that I have a postgres intance running on version 12 in centos 7. So whenever I am trying to login in the database using psql -W option, I am entering the wrong passwords for that user, even after that I am logging in the database. So could you help me in telling

password error in batch script

Hi, I have a password Vl=SO*CIz%A83FQF that is working fine like that in the command prompt but when it is being used in a batch file it is giving me an error of wrong password, the password is something looks like that in batch script. set "PGPASSWORD=Vl=SO*CIz%A83FQF" Could you please help me

log_statement vs log_min_duration_statement

Hi, I have a query about parameters and log_statement my postgres version is 12 and running on centos 7 my log_statement is set to "DDL". and log_min_duration_statement is set to "1ms" so technically it should log "ONLY DDLs" that take more than 1ms. but to my surprise, postgres is logging D

log wal file transfer in error logs

Hi, I need to log all wal files that are getting transferred to all standby servers in the postgresql error logs. I also need to log those wal files that are being applied in standbys. My postgres version is 12 and running on centos 7. I am unable to understand the proper parameters in the post

Re: log wal file transfer in error logs

db error logs. Regard On Wed, Oct 11, 2023 at 10:29 PM Atul Kumar wrote: > Yss, I meant streamed, I need to log those wal files that are getting > streamed and replayed on standby servers in error logs of primary as well > as standby servers. > > So that I can cross check that

logs are not getting logged in error logs

Hi, I have postgres 12 running on centos 7. i have configured streaming replication having one primary and one standby. It is strange to see that the logs are not getting generated on standby. I have checked the log directory using show command and it shows the correct output. I also intention

purpose of an entry in pg_hba.conf file

Hi, As you know already, pg_hba.conf file always has the below entry after successful installation of postgres. hostall all 127.0.0.1/32trust Please let me know what is the exact purpose of this entry and what would be the impact of removing it on other

issue with remote backup

Hi, I have the postgres12 version running on centos7. In pg_hba.conf file I have an entry like below: hostall all /32md5 So from the above entry, I understand that all users can connect to all databases from the remote ip. But when I use pg_basebackup f

Re: purpose of an entry in pg_hba.conf file

authentication. Whether that impacts any particular one/thing > depends on your personal setup. > > David J. > > On Thu, Oct 26, 2023 at 11:04 AM Atul Kumar wrote: > >> Hi, >> >> Could you elaborate more as it seems that your response doesn't satisfy

Re: purpose of an entry in pg_hba.conf file

Please share the required link having such information in detail, It would be more helpful to me. Regards. On Fri, Oct 27, 2023 at 12:16 AM Christophe Pettus wrote: > > > > On Oct 26, 2023, at 11:44, Atul Kumar wrote: > > There is already one line to serve your stated

meaning of CIDR mask in pg_hba.conf

Hi, I have postgres version 12 running on centos 7. I found an entry in my pg_hba.conf entry as given below under IPV4 connections: host all all /0 md5 I could not understand the meaning of "/0" here. as I know that each IPV4 there are total 4 octets and each octet will be read based on

missing client_hostname

Hi, I have postgres 12 running in centos7. I recently have configured streaming replication from master to standby using below command: /usr/bin/pg_basebackup -h -p 5432 -U replication -D /path/of/data/directory/ -Fp -R -Xs -P -c fast It was successfully configured but when I query pg_stat_rep

Re: missing client_hostname

I have already enabled log_hostname, still *client_hostname is not showing up.* Do you think that just because I use ip instead of hostname while using pg_basebackup could be the reason for it ? Regards, Atul On Wed, Nov 1, 2023 at 11:23 PM Christoph Moench-Tegeder wrote: > ## Atul Ku

Re: missing client_hostname

ication -D /path/of/data/directory/ -Fp -R -Xs -P -c fast Regards. On Wed, Nov 1, 2023 at 11:46 PM Mateusz Henicz wrote: > Did you reconnect your replica after enabling log_hostname? If not, then > do it and check again. > > śr., 1 lis 2023, 19:03 użytkownik Atul Kumar > nap

strange behavior of pg_hba.conf file

Hi, I have postgres 12 running in centos 7, recently I changed the authentication of entries of pg_hba.conf to scram-sh-256 for localhost. Since then I have started getting the below error: no pg_hba.conf entry for host "::1", user "postgres", database "postgres The entry of pg_hba.conf is l

Re: strange behavior of pg_hba.conf file

d to local connections only and when I pass the hostname or ip of the server it works fine without any issue. Regards. On Wed, Nov 22, 2023 at 10:31 PM Atul Kumar wrote: > The entries that I changed were to replace the md5 with scram-sha-256 and > remove unnecessary remote IPs. > >

Re: strange behavior of pg_hba.conf file

that error while using the above two commands. Regards. On Wed, Nov 22, 2023 at 10:45 PM Adrian Klaver wrote: > On 11/22/23 09:03, Atul Kumar wrote: > > The entries that I changed were to replace the md5 with scram-sha-256 > > and remove unnecessary remote IPs. >

Re: strange behavior of pg_hba.conf file

Please can you share any command for due diligence whether ip is resolved to ipv6 ?. On Wed, Nov 22, 2023 at 11:25 PM Andreas Kretschmer wrote: > > > Am 22.11.23 um 18:44 schrieb Atul Kumar: > > I am giving this command > > psql -d postgres -U postgres -p 5432 -h localhos

IPV6 issue

I have postgres 12 running in centos 7 on my two machines, recently I changed the authentication of entries of pg_hba.conf to scram-sha-256 for localhost. Since then in my one machine, I have started getting the below error when I use command "psql postgres" no pg_hba.conf entry for host "::1", u

Re: IPV6 issue

ng locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? So DO I need to restart the postgres service or is there any other workaround? Regards. On Fri, Nov 24, 2023 at 1:08 AM Ron Johnson wrote: > On Thu, Nov 23, 2023 at 2:18 PM At

Re: IPV6 issue

listen_address is set to '*', version= psql (12.15, server 12.15.19) Regards. On Tue, Nov 28, 2023 at 2:01 AM Adrian Klaver wrote: > On 11/27/23 12:11, Atul Kumar wrote: > > Hi, > > > > I found that localhost was set to .bash_profile and when I removed

Re: IPV6 issue

Hi, unix_socket_directories is set to default i.e. /tmp and I could see the socket in /tmp directory. Regards. On Tue, Nov 28, 2023 at 2:11 AM Tom Lane wrote: > Adrian Klaver writes: > > On 11/27/23 12:11, Atul Kumar wrote: > >> I found that localhost was set to .bash_

Re: IPV6 issue

I Don't know how postgres was installed, How do I check if I have more than one version of psql installed ? Regards. On Tue, Nov 28, 2023 at 6:26 AM Adrian Klaver wrote: > On 11/27/23 16:42, Atul Kumar wrote: > > Hi, > > > > unix_socket_directories is set to default

replication strange behavior

Hi, I have postgres 12 running in centos 7. I have configured streaming replication between one master and one standby server. In the pg_hba.conf file of the master server, I have put the standby server's hostname instead of IP and due to which replication got broken and I started getting below

Re: replication strange behavior

localhost.localdomain localhost6 localhost6.localdomain6 .domainname hostname Regards. On Fri, Dec 1, 2023 at 3:33 AM Ron Johnson wrote: > On Thu, Nov 30, 2023 at 3:41 PM Atul Kumar wrote: > >> Hi, >> >> I have postgres 12 running in centos 7. >> >> I have configured stre

Parameter value in RDS

Hi, I am new to RDS postgres, I have version 14 running on it with m7g.large I found that lots of parameters has DBInstanceClassMemory written, so what exactly is the value of this variable ? How should I calculate it? Regards.

unbale to list schema

Hi, I am not able to find any solution to list all schemas in all databases at once, to check the structure of the whole cluster. As I need to give a few privileges to a user to all databases, their schemas and schemas' objects (tables sequences etc.). Please let me know if there is any solution

permission denied on socket

Hi, I have postgres 13 running on centos 7. I am facing an issue while trying to connect the cluster using the below command. -bash-4.2$ psql postgres psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: Permission denied Is the server running locally and accepting

Re: permission denied on socket

I checked the permissions on /tmp directory and it shows "drwxrwxrwt." already, do I need to check something else as well ? Regards. On Fri, Jan 26, 2024 at 3:00 AM Tom Lane wrote: > Ron Johnson writes: > > On Thu, Jan 25, 2024 at 3:32 PM Adrian Klaver > > > wrote: > >> Best guess is you are

issue with reading hostname

Hi, I have postgresql version 15 running on centos7. I have below query that reads hostname from /tmp directory: psql postgres -A -t -p 5432 -h /tmp/ -c 'SELECT pg_is_in_recovery();' so below are my questions: 1. Is the psql client reading the socket file that resides in the /tmp directory t

Re: issue with reading hostname

Can we edit the socket to change the hostname in it ? Regards. On Tue, Apr 23, 2024 at 2:41 AM Ron Johnson wrote: > On Mon, Apr 22, 2024 at 4:14 PM Atul Kumar wrote: > >> Hi, >> >> I have postgresql version 15 running on centos7. >> >> I have below

Re: issue with reading hostname

I mean, Once I change the hostname then how will the socket read the new hostname ? Does it require a postgres service restart ? On Tue, Apr 23, 2024 at 3:19 AM Adrian Klaver wrote: > On 4/22/24 14:37, Atul Kumar wrote: > > Can we edit the socket to change the hostname in it ? >

default privileges are npt working

Hi, I have a postgres instance running on version 15 in centos7. I have created a custom database and revoked all public privileges from that database. Then I have created a custom schema in that custom database. Now I have created one writer *user* and one reader *user *by postgres superuser a

Re: ERROR: could not start WAL streaming: ERROR: replication slot "XXX" does not exist

As per your error, it seems replication slot has been dropped. On Saturday, March 27, 2021, FOUTE K. Jaurès wrote: > Hello EveryOne, > > How can I solve Issue. ??? > > > > *ERROR: could not start WAL streaming: ERROR: replication slot "XXX" > does not exist2021-03-27 11:48:33.012 WAT [1090] LO

trigger impacting insertion of records

Hi, I have simple table having structure like given below: \d bp_ach_trans Table "bonzipay.bp_ach_trans" Column | Type | Modifiers ++---

idle_in_transaction_session_timeout

Hi, I have postgres 9.5 version running on my machine. When I am trying to find out the parameter idle_in_transaction_session_timeout it is showing me below error: postgres=# show idle_in_transaction_session_timeout; ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeo

  1   2   >