Thank you Christophe I am very clear now. And post your email researched
various vendors and will get in touch with them.
Thanks,Prashant
On Tuesday, November 26, 2024, 11:42 AM, Christophe Pettus
wrote:
Hello,
I think there is a fundamental misunderstanding here about how PostgreSQL's
li
Hi Christophe,Thank you so much for the response. One of my client is also
requesting details of licensed version of PostgreSQL. Could you please guide me
cost of PostgreSQL license which they want to get installed on their (client’s)
on premise server. Not sure how pricing works for enterprise
Hi Team,
I have tried to configure DB switch over using repmgr. Post updated repmgr
file then tried to register in primary db but getting the below error.
Kindly check and let me know to fix the issue.
*Error:*
[postgres@post1 bin]$ ./repmgr -f /var/lib/pgsql/repmgr.conf primary
register
ERROR:
Hello,
I think there is a fundamental misunderstanding here about how PostgreSQL's
licensing works.
You do not pay for the community version of PostgreSQL. The license
specifically states it is available without a fee. It's free. No one collects
money for the community version of PostgreSQL
On 11/25/24 19:07, shashidhar Reddy wrote:
Hi Adrian,
Thank you for your response.
I don't think index corrupted as I can generate the ddl script from the
What DDL script?
index and the index is still in use when we query.
See Tom Lanes post for more detail. Short version the index will
This would help me. I will try out the pg_rewind and rsync options.
On Mon, 25 Nov 2024 at 15:19, Ilya Anfimov wrote:
> On Sun, Nov 24, 2024 at 09:35:15PM +0530, Subhash Udata wrote:
> >Dear PostgreSQL Community,
> >
> >I have a production database setup with a primary server and a stand
Hi Adrian,
Thank you for your response.
I don't think index corrupted as I can generate the ddl script from the
index and the index is still in use when we query.
To rebuild the index we are still removing duplicate entries. But nothing
found in logs.
On Mon, 25 Nov, 2024, 9:30 pm Adrian Klaver
> As a superuser, rename pg_stat_reset inside one of the commonly affected
databases:
> alter function pg_stat_reset rename to
hey_stop_running_pg_stat_reset_already;
> Then see who starts complaining. Additionally, your server log will get
helpful entries like this:
Thanks for the tip Greg - tha
On Mon, 2024-11-25 at 22:47 +, Clay Jackson (cjackson) wrote:
>
> Are you willing to sign up for "maintaining" PostgreSQL in your
> environment, INCLUDING things like patching, finding and fixing
> bugs, upgrades, backup and recovery, and off-hours support?
>
Not sure what your point is, you
On Fri, 2024-11-22 at 05:40 +, prashant sinha wrote:
> Hello There,
> I am looking to install PostgreSQL on a Microsoft Azure cloud VM
> for a product I am developing for business purpose. Is there a free
> version of PostgreSQL available which I can use without buying any
> licenses? In case I
Thanks, Ron! Exactly my points!
I do not want to “discount” the community in ANY way.In fact, I’m a huge
fan of Open Source, as long as everyone, including “management”, is bought into
community support concept.
I’ve seen the “wrong side” of “What do you mean, ‘You posted something to the
On Mon, Nov 25, 2024 at 5:47 PM Clay Jackson (cjackson) <
clay.jack...@quest.com> wrote:
[snip]
> Are you willing to sign up for "maintaining" PostgreSQL in your
> environment, INCLUDING things like patching, finding and fixing bugs,
> upgrades, backup and recovery, and off-hours support?
Azure'
On 11/25/24 14:47, Clay Jackson (cjackson) wrote:
Christophe is spot on when it comes to the PostgreSQL software.
Not trying to be "snarky" or condescending, but there are some other considerations. "Open
Source" or "Free" does not mean "without cost".
No matter where you decide to host the
Christophe is spot on when it comes to the PostgreSQL software.
Not trying to be "snarky" or condescending, but there are some other
considerations. "Open Source" or "Free" does not mean "without cost".
No matter where you decide to host the software, there will be storage,
compute, and netwo
> On Nov 21, 2024, at 21:40, prashant sinha wrote:
> Is there a free version of PostgreSQL available which I can use without
> buying any licenses? In case I want to self install and manage the database?
> Just need guidance if I can install the available version from site for
> business pur
Hello There,I am looking to install PostgreSQL on a Microsoft Azure cloud VM
for a product I am developing for business purpose. Is there a free version of
PostgreSQL available which I can use without buying any licenses? In case I
want to self install and manage the database? Just need guidance
shashidhar Reddy writes:
> The issue is a unique key constraint with two columns one is character
> another is integer. At some point the unique key did not work as I see
> duplicate values with these two columns combination and it happened on
> multiple servers on multiple databases on same table
On 11/25/24 00:44, shashidhar Reddy wrote:
Hi Ajit,
Thank you for your reply!
The result of the query is same across all servers and yes streaming
replication does not have any issue but the question is how did
duplicate values entered when there unique key in place.
Corrupted index?
Have
On Mon, 2024-11-25 at 06:08 +, Shaun Robinson wrote:
> I'm currently testing an application with Postgres 17.2 and am getting an
> error
> when creating a materialized view which works in version 16 and below. The sql
> works fine running as a query, but adding the create materialized view bre
On Sun, Nov 24, 2024 at 09:35:15PM +0530, Subhash Udata wrote:
>Dear PostgreSQL Community,
>
>I have a production database setup with a primary server and a standby
>server. The database is currently running on PostgreSQL 15.0, and I plan
>to upgrade both servers to 15.9.
>
>I
Hi David,
I've created a basic example which produces the issue for me and the SQL is
below.
Thanks
Shaun
create table diagnosisTest
(
id serial primary key,
icd_code varchar(10)
);
create table encounterTest
(
id serial primary key,
dx1 integer,
dx2 integer,
dx3 integer,
dx4 integer,
dx5 inte
On Mon, 25 Nov 2024, 06:08 Shaun Robinson,
wrote:
> Hi,
>
> I'm currently testing an application with Postgres 17.2 and am getting an
> error when creating a materialized view which works in version 16 and
> below. The sql works fine running as a query, but adding the
> create materialized view b
If all syntax correct while creating unique key or composite unique key than
there is no chances of fail. In my experience I m facing same issue but it’s
rear case, if any extra space in data (insert query) than duplicate data
inserted. Please chk thorough insert query . May be the issue not sur
Hi Ajit,
Thank you for your reply!
The result of the query is same across all servers and yes streaming
replication does not have any issue but the question is how did duplicate
values entered when there unique key in place.
On Mon, 25 Nov, 2024, 1:21 pm ajit wangkhem,
wrote:
> Output should
Put wal log in the restore directory and check during start postgresql
consumed or not. If consumed then no issue. Instead of risk free create
recovery.conf or standby.signal and put restore_command in that above file
and see whether consumed or not. If consumed its ok.
On Mon, Nov 25, 2024 at 11:
25 matches
Mail list logo
