On Tue, Jul 18, 2023 at 01:53:23AM +0200, Gert Cuykens wrote:
> Hi, suggest to automatically rename backup_manifest to backup_manifest.old
> like backup_label when postgres start up successfully because it has no use
> anymore for pg_verifybackup after postgres has been started.
Yes, I would
231*TB* seems, to me, an unreasonably large number.
On 7/27/23 02:30, kg.postgre...@olympiakos.com wrote:
Hello,
Is there a known issue with temp file reporting? I have a production db
that is reporting 231TB of temp space usage, which can’t be true.
temp_blks_written in pg_stat_statements
Using asynchronous replication. Production is running on a gaming PC at the
moment because it was to slow on a state of the art hypervisor 128 core 1TB
mem and nvme disk server rack... (where de replicated slave is running on)
I would like to know what number this gaming pc is pulling that
Priess Stefan writes:
> I also need to change the default port from 5433 to 5432
> (--with-pgport=5433). How can I do this using the build.bat toolchain? I
> don't see the pgport parameter in the config_default.pl file.
I don't use MSVC myself, but a quick look at the code suggests that
you
On 7/28/23 07:20, Gert Cuykens wrote:
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Replication or not, why are you running pgbench
On 7/28/23 07:00, Amn Ojee Uw wrote:
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change
On 7/28/23 09:00, Amn Ojee Uw wrote:
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change
On 7/28/23 07:26, Priess Stefan wrote:
Thanks Tom!
I also need to change the default port from 5433 to 5432 (--with-pgport=5433).
How can I do this using the build.bat toolchain? I don't see the pgport
parameter in the config_default.pl file.
1) The default port is 5432.
2) Why do you want
Thanks Tom!
I also need to change the default port from 5433 to 5432 (--with-pgport=5433).
How can I do this using the build.bat toolchain? I don't see the pgport
parameter in the config_default.pl file.
Best,
Stefan
nexus / chili
Stefan Priess
Softwareentwicklung
Tel: +49 6221 18079-10
On 7/27/23 16:45, Adrian Klaver wrote:
On 7/27/23 1:17 PM, Atul Kumar wrote:
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
First of all, my gratitude to Adrian and David for taking the time to
reply to my call for help; a 1k thanks to you kids.
Having stated the above, PostgreSQL provides a default database namely
'postgres'. Taking advantage of this service, I have change the 'psql'
statement to 'psql -d
Priess Stefan writes:
> up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw
> folder which could be used to compile a static postgres.lib using nmake.
> Since Postgres 10 this file has been removed.
Yup. It didn't really work right and there was insufficient interest
Hi, I would like to pgbench the production postgres that is being physical
replicated to a slave. Will I shoot myself in the foot because of the
physical replication if I try pgbench on prodcution postgres.
Thanks
Thank you very much for taking the time to reply to my question.
> The problem is none of the explains you sent match with the description
> above. The last one when you forced the optimizer to go with index scan (SET
> enable_seqscan TO off;) the chosen index seems to be one composed by
On Thu, 2023-07-27 at 20:02 +, Hellen Jiang wrote:
> I am going to upgrade our production database( postgresql 12.10) to
> postgresql 15.3.
> After upgrade to 15.3, Do you have to do re-index?
That is not necessary after a PostgreSQL upgrade.
(It may be necessary if you upgrade the
Hi,
I am trying to understand the evictions statistic in pg_stat_io. I know what
evictions are, so this is not the question.
Given this:
postgres=# select version();
version
Hi all,
up to version 9.6.22 there was a win32.mak file in the src/interfaces/libpw
folder which could be used to compile a static postgres.lib using nmake. Since
Postgres 10 this file has been removed.
Is it still possilbe to build a static postgres.lib for windows ? And if so,
how do I do
Hi,
I am going to upgrade our production database( postgresql 12.10) to postgresql
15.3.
After upgrade to 15.3, Do you have to do re-index?
If I have to do re-index, can I only do re-index on some partitioned tables?
We have a lot of big tables which are partitioned by date, for example, table1
18 matches
Mail list logo