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: 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 ? >

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

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: 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

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

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

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.

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

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: 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

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

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

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

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: 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

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

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. > >

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: 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 ? >

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: 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 >

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

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.

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

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

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

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

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

PostgreSQL's Max Identifier Length in Amazon RDS

Hi, Could someone help me in telling : how to increase Max Identifier Length in amazon RDS.running instance on postgres 10 ? I couldn't find the blog related to it so far, So kindly suggest. Regards, Atul

java.lang.ClassNotFoundException: batchprint.Batch

Hi, I have a function with below definition: CREATE OR REPLACE FUNCTION onesam.batchprint_individual( p1 character varying, p2 character varying, p3 character varying, p4 boolean, p5 boolean, p6 character varying, p7 integer, p8 integer) RETURNS integer LANGUAGE 'javau' COST 100 V

Re:

Hi, You can try to make a batch script in windows for taking incremental backup and schedule it in windows scheduler. Regards Atul On Friday, August 27, 2021, obi reddy wrote: > Hi everyone. > > how to take incremental backup in postgresql windows machine. > > > Thank you And Regards >

pganalyze setup

Hi, Could you provide me any link or blog to install and configure pganalyze setup on centos 7 machine. Also please let me whether pganalyze is an open source or not. Regards.

Re: optimization issue

Hi, Could you suggest me how should I teduce the heap blocks to optimise the query ? Regards. On Thursday, July 8, 2021, Atul Kumar wrote: > Hi, > > I have one query like below : > > > SELECT >

Re: optimization issue

Hi Lewis, I am new to postgres. Could you tell me how should I put the result on an analyzed temp table at least ? Please suggest. Regards. On Thursday, July 8, 2021, Michael Lewis wrote: > ((current_setting('env.groupid'::text))::integer)::numeric > > If you pass this value in directl

optimization issue

Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '

Re: number of wal file is not reduced.

:18:14PM +0530, Atul Kumar wrote: >> I have postgres 9.6 running server on centos 7, the number of wal file >> in pg_xlog directory is above 4000 so to save some disk space, I >> thought of reducing to 100. > ... >> Please suggest when the number of wal files will be redu

wal_keep_segments and max_wal_size

hi, (on postgres 9.6) I was just practicing to make my no. of wal files in pg_xlog directory to be the same/equal as I pass on wal_keep_segments paramater. say for example show wal_keep_segments; wal_keep_segments --- 125 so I want my wal files should not be grow in numbers mo

number of wal file is not reduced.

Hi, I have postgres 9.6 running server on centos 7, the number of wal file in pg_xlog directory is above 4000 so to save some disk space, I thought of reducing to 100. but there is no reduction in numbers. Please not that there is no replication is configured, the server is independent. What I

Re:

Index Cond: ((icontainerid = '15257396'::numeric) AND (imemberid = m.imemberid)) Buffers: shared hit=75 Planning time: 7.206 ms Execution time: 6741.891 ms (56 rows) The query I shared has been calling one function also (function name: getGroupId()) Below

Re:

newregeventid, l_newseasonid, false ); :new.iregeventid := l_newregeventid; :new.iseasonid := l_newseasonid; --} END IF; END$trigger$ samparticipantctimestamp BEFORE INSERT ON sam_participant FOR EACH ROW $trigger$BEGIN :NEW.dCreatedTime

[no subject]

Hi, I have one query like below : SELECT m.iMemberId "memberId", m.cFirstName "firstName", m.cLastName "lastName", m.cFirstName || ' '

user privileges

Hi, My question can be silly but I need to ask that if a user is created without login privilege then what is the use of below command why don't postgres prompt error on it CREATE ROLE nolog_user WITH PASSWORD 'pass1'; as the user is created with login privileges then what is the use such user ?

clear cache in postgresql

Hi, I have an postgres 10 instance on RDS. Sometimes I run a Postgres query it takes 30 seconds. Then, I immediately run the same query and it takes 2 seconds. It appears that Postgres has some sort of caching. Can I somehow see what that cache is holding? Can I force all caches to be cleared for

Re: query issue

Items"."userId" = '5d230d67bd99c5001b1ae757'::text) AND ("UserFeedItems"."itemType" <> ALL ('{WELCOME_POST,UPLOAD_CONTACTS,BROADCAST_POST}'::text[]))) Rows Removed by Filter: 15478 Buffers: shared hit=4838 read=37

Re: query issue

well with these parameters. Regards. On 6/15/21, Jehan-Guillaume de Rorthais wrote: > On Tue, 15 Jun 2021 16:12:11 +0530 > Atul Kumar wrote: > >> Hi, >> >> I have postgres 10 running on RDS instance. >> >> I have query below: > [...] >

query issue

Hi, I have postgres 10 running on RDS instance. I have query below: select * from "op_KFDaBAZDSXc4YYts9"."UserFeedItems" where (("itemType" not in ('WELCOME_POST', 'UPLOAD_CONTACTS', 'BROADCAST_POST')) and ("userId" = '5d230d67bd99c5001b1ae757' and "is_deleted" in (true, false))) order by "score

Re: base directory size getting increased

at 17:48 +0530, Atul Kumar wrote: > > initially pgsql_tmp size was 87 GB and after execution of query it was > > started increasinng beyond 87GBs so yes, pgsql_tmp directory size is > > getting increased while exporting data into csv file. > > > > But once I rolled ba

Re: base directory size getting increased

Hi Sir, I don’t think there is any old connection connected as there is no process I found from pg_stat_activity. Is there any other way to trace out such sessions. Regards Atul On Monday, June 7, 2021, Ravi Krishna wrote: > > > > initially pgsql_tmp size was 87 GB and after execution

Re: base directory size getting increased

telling how do I clean that 87GB of space of pgsql_tmp directory. Regards, Atul On 6/7/21, Laurenz Albe wrote: > On Mon, 2021-06-07 at 16:11 +0530, Atul Kumar wrote: >> I have a query from which I am trying to export the data into a csv >> file(around 10 lakhs record) but

base directory size getting increased

Hi, I have a query from which I am trying to export the data into a csv file(around 10 lakhs record) but when I am doing so the base sub directory size of data directory is getting increased. can someone help me in telling 'why base sub directory size is getting increased'? my postgres version

Re: strange behavior of WAL files

, Tom Lane wrote: > Atul Kumar writes: >> once old WAL files of pg_xlog directory are archived in >> '/nfslogs/wal/' directory then these WAL files are getting generated >> with the same name in pg_xlog directory. > > Are you sure you are describing the behav

Re: strange behavior of WAL files

On 6/4/21, Tom Lane wrote: > Atul Kumar writes: >> once old WAL files of pg_xlog directory are archived in >> '/nfslogs/wal/' directory then these WAL files are getting generated >> with the same name in pg_xlog directory. > > Are you sure you a

Re: strange behavior of WAL files

my query is Why is this happening ? please help me with your suggestions. Regards. On 6/4/21, Jehan-Guillaume de Rorthais wrote: > On Fri, 4 Jun 2021 15:39:30 +0530 > Atul Kumar wrote: > >> HI, >> >> We have a centos 6 enviornment where postgres 9.6 is runni

strange behavior of WAL files

HI, We have a centos 6 enviornment where postgres 9.6 is running on it. We have strange behavior of WAL files of pg_xlog directory As we have set archive_command to archive WAL files at different location and the archive_command is working fine. So strange behavior is : We have a WAL file say

Re: idle_in_transaction_session_timeout

ok, But what is the workaround of this parameter in postgres 9.5, ,I need to increase the time of "idle in transaction" transactions. Regards, Atul On 5/7/21, luis.robe...@siscobra.com.br wrote: > > - Mensagem original ----- >> De: "Atul Kuma

Re: trigger impacting insertion of records

#PostGreSQL: idle in transaction^^2021-05-06 18:06:12 PDT^^bonzipay^^usmliv1^^127.0.0.1(38435)^^60949111.16a5^^2021-05-06 18:00:01 PDTLOG: unexpected EOF on client connection with an open transaction Please suggest the solution to troubleshoot it more. Rega

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

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 ++---

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

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: 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

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: 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

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

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.

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

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

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

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

, 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

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: 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

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

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

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

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

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

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

. 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

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: 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: 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: 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

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

  1   2   >