> On Jul 11, 2022, at 6:46 PM, Igor Korot wrote:
>
> Hi,
>
>> On Mon, Jul 11, 2022 at 7:56 AM Rob Sargent wrote:
>>
>>> On 7/11/22 06:31, Mladen Gogala wrote:
>>> On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
>
> No, this is my personal project.
>
> Thank you.
>
Hi,
On Mon, Jul 11, 2022 at 7:56 AM Rob Sargent wrote:
>
> On 7/11/22 06:31, Mladen Gogala wrote:
> > On 7/10/22 22:52, Rob Sargent wrote:
> >> Are you alone or on a team?
No, this is my personal project.
Thank you.
> >
> > What are your pronouns?
> >
> This did make me chuckle, but no I am ju
Hi,
Le lun. 11 juil. 2022 à 21:22, Ken Yeung a
écrit :
> In the course of upgrading a bunch of database clusters from 10 to 14
> using pg_upgrade tool, some databases result in the following error
> recorded in pg_upgrade_dump_1.log, such that cluster upgrade fails.
> FATAL: password authentica
Hi All,
Thank you for your valuable comments and suggestions. As it was pointed
out we are using EDB Postgres and the language was mentioned as
'edbspl'. We made to work by setting the search_path variable as follows:
set search_path="$user", public, pg_catalog
And also changed the Operato
In the course of upgrading a bunch of database clusters from 10 to 14 using
pg_upgrade tool, some databases result in the following error recorded in
pg_upgrade_dump_1.log, such that cluster upgrade fails.
FATAL: password authentication failed for user "postgres"
This was done on Microsoft Wind
Hi there,
Out of curiosity.
Is there (as part of the PG development cycle) any public website that
compares the performance of PG versions regarding common use cases? So that
we can (users) can follow the progress of PG over the years, especially
using modern hardware and cloud. DirectIO
Somethi
Hello,
po 11. 7. 2022 v 14:47 odesílatel Pavel Stehule
napsal:
> Hi
>
> It's looks like memory leak
>
As we are collecting some data for Postgres processes, I've found processes
using Rss Anonymous memory allocations:
Some examples:
2022-07-08T14:50:24+0200 Name: postmaster Pid: 31522 RssAnon:
On 7/11/22 06:31, Mladen Gogala wrote:
On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
What are your pronouns?
This did make me chuckle, but no I am just asking whether or not the OP
is currently part of a team.
Hi
It's looks like memory leak
ErrorContext: 8192 total in 1 blocks; 7928 free (5 chunks); 264 used
> Grand total: 1456224 bytes in 195 blocks; 378824 free (165 chunks);
> 1077400 used
> 2022-07-02 14:48:07 CEST [3930]: [3-1] user=,db=,host=,app= ERROR: out of
> memory
> 2022-07-02 14:48:07 CE
On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
What are your pronouns?
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
> On Jul 11, 2022, at 2:50 AM, Aleš Zelený wrote:
>
>
> Hello,
>
> we are experiencing out-of-memory issues after Postygres upgrade from 14.3 to
> 14.4 on CentOS7.
>
> OS: CenotOS7
>
> No OOM killer messages in the syslog. SWAP is disabled.
>
> -bash-4.2$ sysctl -q vm.overcommit_memory
Hello,
we are experiencing out-of-memory issues after Postygres upgrade from 14.3
to 14.4 on CentOS7.
OS: CenotOS7
No OOM killer messages in the syslog. SWAP is disabled.
-bash-4.2$ sysctl -q vm.overcommit_memory
vm.overcommit_memory = 2
[root@sts-uat-pgsql100 ~]# swapon -vs
[root@sts-uat-pgsq
On 10 Jul 2022, at 17:40, Igor Korot wrote:
Hi,
Is there a query I can execute that will give me CREATE TABLE()
command
used to create a table?
Thank you.
I am using the following query for that:
```sql
select
a.attname,
a.attnum,
a.attnotnull,
pg_catalog.fo
13 matches
Mail list logo
