Hello,
In my DB I have a large object over 4GB in size.
I need to get its MD5 or SHA256 from within psql query, i.e. without
exporting it to FS first.
“SELECT md5(lo_get(loid));” doesnt work — “large object is too large”.
Is there any other way to do it?
Regards,
Al
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 agree
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 suppos
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 wan
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 o
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 the
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 t
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
E-
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 t
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 postgre
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
in
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 ms_
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 operatin
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 it
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
19 matches
Mail list logo
