Il giorno mar 28 mag 2024 alle ore 18:40 Christian Schröder
ha scritto:
> Our PostgreSQL version is "PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled
> by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit". The database server
> is a dedicated server with 15 GB RAM (and 4 cores, if this matter
HI Kashif,
The VIP 10.127.1.18 is accessible from the leader node (ha0002) only but
not from the standby nodes (ha0001 and ha0003).
Thanks
Vijay
On Thu, May 30, 2024 at 9:17 AM Kashif Zeeshan
wrote:
> Hi Vijay
>
> The log shows that all the nodes are able to communicate now (master,
> standby
Please refer to the following links for help
https://access.redhat.com/solutions/3500401
https://stackoverflow.com/questions/72778135/install-llvm-toolset-10-0-or-newer-in-centos7
Regards
Kashif Zeeshan
Bitnine Global
On Thu, May 30, 2024 at 8:50 AM Kashif Zeeshan
wrote:
> Hi Sumit
>
> Please
Hi Sumit
Please make sure Developer Toolset Repo is enable, the package is not
getting installed as its not being found due to the missing Repo.
Regards
Kashif Zeeshan
Bitnine Global
On Wed, May 29, 2024 at 10:10 PM Sumit Kochar
wrote:
> Hi Muhammad,
>
>
>
> Tried to install as per step2 menti
Hi Vijay
The log shows that all the nodes are able to communicate now (master,
standby and standby1) and now what are the issue you are facing?
Regards
Kashif Zeeshan
On Thu, May 30, 2024 at 2:00 AM vijay patil
wrote:
> Thanks Muhammad !
>
> Here i uploaded details.
>
> Thanks
> Vijay
>
> On W
you can use ODBC with Windev, so the best is the Postgresql connector
https://www.postgresql.org/ftp/odbc/releases/
Atte
JRBM
El mié, 29 may 2024 a las 14:46, José Mello Júnior (<
jose.mello.jun...@gmail.com>) escribió:
>
> Em qua., 29 de mai. de 2024, 15:41, Adrian Klaver <
> adrian.kla...@akla
=?utf-8?B?Q2hyaXN0aWFuIFNjaHLDtmRlcg==?= writes:
> # ipcs -m
> -- Shared Memory Segments
> keyshmid owner perms bytes nattch status
> 0x04000194 35 postgres 60056 19
> I am surprised to see this since I would have expected mu
Thanks Muhammad !
Here i uploaded details.
Thanks
Vijay
On Wed, May 29, 2024 at 10:58 AM Muhammad Imtiaz
wrote:
> Hi,
>
> Can you please provide the Pgpool logs? Additionally, in a distributed
> environment, ensure that Pgpool is properly configured. You can follow
> these documented steps to
Hi Adrian,
After modifying the pgpool.conf configuration to correct a subnet mistake,
Previously, the wrong subnet was specified as /26, and it has now been
corrected to /24. The configuration changes were as follows:
Previous Configuration:
delegate_ip = '10.127.1.18'
if_up_cmd = '/sbin/ip
Hi Francisco,
Thank you for your advice. I used "ipcs" to get more readable information about
the shared memory:
# ipcs -m -l --human
-- Shared Memory Limits
max number of segments = 4096
max seg size = 16E
max total shared memory = 16E
min seg size = 1B
# ipcs -m
-- Shared Me
Em qua., 29 de mai. de 2024, 15:41, Adrian Klaver
escreveu:
> On 5/29/24 11:18, José Mello Júnior wrote:
>
> Again reply to list by using Reply All.
> Ccing list.
> > For my projects in 32 bits, the language of PC-SOFT (wlanguage) use.
>
> Are you talking about this?:
>
> https://windev.com/pcsof
On 5/29/24 11:18, José Mello Júnior wrote:
Again reply to list by using Reply All.
Ccing list.
For my projects in 32 bits, the language of PC-SOFT (wlanguage) use.
Are you talking about this?:
https://windev.com/pcsoft/index.html
Em qua., 29 de mai. de 2024, 15:09, Adrian Klaver
mailto:ad
On 5/29/24 10:59 AM, José Mello Júnior wrote:
Reply to list also.
Ccing list.
Sorry, for windows
That is the OS, what I am after is what client on Windows do you need
the DLL for?
Em qua., 29 de mai. de 2024, 14:53, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> escreveu:
On 5/29/24 10:49 AM, José Mello Júnior wrote:
Where do i found this dll for acess postgresql 15?
Access Postgres using what client?
--
Adrian Klaver
adrian.kla...@aklaver.com
Where do i found this dll for acess postgresql 15?
Hi Muhammad,
Tried to install as per step2 mentioned, but got message - No package
llvm-toolset-7 available.
Log reference below:
[root@hostip tds_fdw-2.0.3]# yum list installed | grep llvm-toolset
This system is not registered with Spacewalk server.
You can use rhn_register to register.
Spacew
On Wed, 2024-05-29 at 14:36 +0200, Alexander Staubo wrote:
> > On 29 May 2024, at 02:53, Tom Lane wrote:
> > I'm unpersuaded by the idea that ANALYZE should count dead tuples.
> > Since those are going to go away pretty soon, we would risk
> > estimating on the basis of no-longer-relevant stats an
On 5/28/24 22:15, vijay patil wrote:
Hi Adrian,
After modifying the pgpool.conf configuration to correct a subnet
mistake, Previously, the wrong subnet was specified as /26, and it has
now been corrected to /24. The configuration changes were as follows:
This seems to be a networking issue:
On Wed, May 29, 2024 at 6:29 AM ISHAN CHHANGANI . <
f20200...@hyderabad.bits-pilani.ac.in> wrote:
> Is there some code within Postgres that resets/removes the signals in case
> a query hits any error?
>
See the comment and call to disable_all_timeouts() in postgres.c, part of
the cleanup-after-ex
> On 29 May 2024, at 02:53, Tom Lane wrote:
>
> Alexander Staubo writes:
>> (2) Set up schema. It's important to create the index before insertion, in
>> order to provoke a
>> situation where the indexes have dead tuples:
>> ...
>> (4) Then ensure all tuples are dead except one:
>
>>DELETE
On a particular query, I start an alarm (say for 5 sec) using RegisterTimeout ,
and when the alarm rings, I log something.
This works fine.
But if I run a query with a syntax error between the time duration, then the
alarm never rings.
Is there some code within Postgres that resets/removes the si
Greetings,
While configuring ORG_FWD.
I hope you are setting path like server name and absolute path to file on
your network share and network share has appropriate permissions.
'\\remote_server\path\to\file.xlsx' on network share
Create user mapping if required.
check your config through
ogr_f
Hi,
I'm running into a problem connecting to a foreign server with my
Postgres database. I am using the OGR_FDW trying to connect to an Excel
"XLSX". I had this database on another server, and the foreign server
was set up and working properly there. I am trying to change the path
to the f
Greetings,
The error message you encountered, "could not fork autovacuum worker
process: Cannot allocate memory," indicates that your PostgreSQL server
attempted to start an autovacuum worker process but failed because the
system ran out of memory.
Steps to verify.
1 Check system available memory
Hi Christian:
On Wed, 29 May 2024 at 00:59, Christian Schröder
wrote:
> Thank you for your advice. I used "ipcs" to get more readable information
> about the shared memory:
...
> As far as I understand, there is no upper limit to the size of the shared
> memory. The database only holds a single
On Wed, 29 May 2024 at 12:53, Tom Lane wrote:
> It would be interesting to see a non-artificial example that took
> into account when the last auto-vacuum and auto-analyze really
> happened, so we could see if there's any less-fragile way of
> dealing with this situation.
I think we need to find
On Wed, 2024-05-29 at 01:34 +0530, yudhi s wrote:
> > The only way you can have no delay in replication AND no canceled queries is
> > if you use two different standby servers with different settings for
> > "max_standby_streaming_delay". One of the server is for HA, the other for
> > your long-ru
27 matches
Mail list logo
