it following link :
> https://www.crunchydata.com/blog/postgres-wal-files-and-sequuence-numbers
>
>
> Thanks
>
> Kashif Zeeshan
>
>
>
> On Tue, Apr 8, 2025 at 4:44 PM Atul Kumar wrote:
>
>> In streaming replication What is the way to check which "WAL file" is
>> currently in use in primary and in standby ?
>>
>>
>> Regards.
>>
>
In streaming replication What is the way to check which "WAL file" is
currently in use in primary and in standby ?
Regards.
nk about using PgBackRest instead of
> something you wrote yourself.
>
> On Fri, Mar 7, 2025 at 2:47 PM Atul Kumar wrote:
>
>> I want to check and compare the speed wal file generation process and
>> archival process.
>>
>> So I want to check how many wal file got cre
025 at 10:59 AM Atul Kumar wrote:
>
>> Hi,
>>
>> Please could you help me by sharing any redhat linux command through
>> which I can count the no. of wal files and no. of ".ready" files generated
>> in last 10 minutes.
>>
>
> What problem are
Hi,
Please could you help me by sharing any redhat linux command through which
I can count the no. of wal files and no. of ".ready" files generated in
last 10 minutes.
Regards,
Atul
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
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 ?
>
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
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
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
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
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
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.
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
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
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
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_
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
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
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
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
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.
>
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.
>
>
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ?
>
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
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
>
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
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.
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
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
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
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
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
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
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
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
>
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.
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
>
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
Hi,
I have one query like below :
SELECT
m.iMemberId "memberId",
m.cFirstName "firstName",
m.cLastName "lastName",
m.cFirstName || ' '
: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
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
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
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
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
Hi,
I have one query like below :
SELECT
m.iMemberId "memberId",
m.cFirstName "firstName",
m.cLastName "lastName",
m.cFirstName || ' '
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 ?
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
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
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:
> [...]
>
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
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
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
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
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
, 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
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
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
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
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
#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
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
Hi,
I have simple table having structure like given below:
\d bp_ach_trans
Table "bonzipay.bp_ach_trans"
Column | Type |
Modifiers
++---
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
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
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
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
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
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
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.
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
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
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.
>
>
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
, 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
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-
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
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
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
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
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
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
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
. 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
1 - 100 of 133 matches
Mail list logo
