Re: log_statement setting

On Thu, Aug 19, 2021 at 1:55 PM Jayadevan M wrote: > > Thank you. Follow up question- If it is set to different values for different > users/databases, how can I get those values? For example, > I have a server with 4 databases. If I just query pg_settings, I get only one > value. The value yo

Re: log_statement setting

On Wed, Aug 18, 2021 at 9:36 PM Bruce Momjian wrote: > On Wed, Aug 18, 2021 at 09:34:08PM +0530, Jayadevan M wrote: > > Hello all, > > > > A doubt on the setting 'log_statement'. Is it possible to set this at > database > > /user level? > > Sure, ALTER USER/DATABASE ... SET. > Thank you. Follow

Re: Serious Assistance with PostgreSQL True Infinite Arbitrary Precision Maths.

On Wed, Aug 18, 2021 at 7:34 PM A Z wrote: > The library that I have been using so far is ttmath, in GNU C++. That > library > is High Precision, in the end, and does seem to be high precision enough, > accurate enough and fast enough for my programs. > I'm guessing from the silence, and my sub

Re: Serious Assistance with PostgreSQL True Infinite Arbitrary Precision Maths.

'What I am trying to find is PostgreSQL support for High Precision numbers, running inside the database engine itself. PostgreSQL, presently at default, has only got limited function support, on the range of a double.' My needs for High Precision Arithmetic require new types and logic inside Post

Re: Licensing

On Wed, Aug 18, 2021 at 12:47:26PM -0700, Bryan Boone wrote: > Ah okay thank you. I think what was confusing me was the “without fee”. > > I wasn’t sure if that meant we could distribute it, but only if we did not > charge a fee for it. But I guess that means that PostgreSQL will not charge >

Re: Postgres Migration error - Need help

Why are you connecting to Postgres in the first place? Ora2Pg should connect to Oracle and produce a SQL script to re-create PostgreSQL version of the Oracle schema. As for the error below, you're probably using an old version of DBD::Pg. Check it using CPAN and upgrade if necessary. Regards

Re: Licensing

Ah okay thank you. I think what was confusing me was the “without fee”. I wasn’t sure if that meant we could distribute it, but only if we did not charge a fee for it. But I guess that means that PostgreSQL will not charge a fee to us to distribute it. Thanks > On Aug 18, 2021, at 12:13 PM

Re: Licensing

On Wed, Aug 18, 2021 at 03:13:51PM -0400, Mladen Gogala wrote: > For a six-pack of Sam Adams Boston Lager or Molson Canadian Lager per > website, I hereby grant thee the right to use PostgreSQL with any customer, > to your heart's content. Please note that I don't accept Budweiser or Miller > produ

Re: PostgreSQL Automatic Failover Windows Server

On Wed, Aug 18, 2021 at 11:57:24PM +0530, Vijaykumar Jain wrote: > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. >   > There is no automatic failover solution provided with core postgresql. (maybe > EDB provides in windows but ...) >

Re: Licensing

For a six-pack of Sam Adams Boston Lager or Molson Canadian Lager per website, I hereby grant thee the right to use PostgreSQL with any customer, to your heart's content. Please note that I don't accept Budweiser or Miller products. On 8/18/21 2:39 PM, Bryan Boone wrote: Hello Everyone.  I h

Re: Licensing

On 8/18/21 11:39 AM, Bryan Boone wrote: Hello Everyone.  I have a question about licensing with PostgeSQL. I work for a small company and we design websites for customers of ours.  I read the license that is listed here. https://www.postgresql.org/about/licence/ However, I am still confus

Re: Licensing

Bryan Boone wrote on 8/18/21 11:39 AM: Can someone tell me if I am able to use PostgreSQL for the small company I work for? Yes, you are.

Licensing

Hello Everyone. I have a question about licensing with PostgeSQL. I work for a small company and we design websites for customers of ours. I read the license that is listed here. https://www.postgresql.org/about/licence/ However, I am still confuse

Re: PostgreSQL Automatic Failover Windows Server

> > > I want to know in detail about PostgreSQL Automatic Failover solutions > without third party tools. > > There is no automatic failover solution provided with core postgresql. (maybe EDB provides in windows but ...) there are third party OSS solutions, dhamaniasad/awesome-postgres: A curated

PostgreSQL Automatic Failover Windows Server

HI, I am Heljeeve from India working as a DB Administratror. We are a company doing projects on solutions for lottery system worldwide, and been in the industry for the past 20 years. Currently we are doing projects in Windows environments ( MS SQL SERVER DATABASE ), as we required high availabil

Re: log_statement setting

On Wed, Aug 18, 2021 at 09:34:08PM +0530, Jayadevan M wrote: > Hello all, > > A doubt on the setting  'log_statement'. Is it possible to set this at > database > /user level? Sure, ALTER USER/DATABASE ... SET. > I get 'all' when I try > select * from pg_settings where name = 'log_statement' > D

log_statement setting

Hello all, A doubt on the setting 'log_statement'. Is it possible to set this at database/user level? I get 'all' when I try select * from pg_settings where name = 'log_statement' Does this mean all statements by any user on any database in that server are getting logged? This is for auditing pur

Re: Postgres Migration error - Need help

On Wed, Aug 18, 2021 at 09:50:32AM +, Pansara, Jiten wrote: > Hello Team, > > > > I am executing below command to copy data but it is throwing error. Can anyone > help please? I think you want to contact the ora2pg project, not us. -- Bruce Momjian https://momjian.us EDB

Postgres Migration error - Need help

Hello Team, I am executing below command to copy data but it is throwing error. Can anyone help please? [cid:image001.jpg@01D79444.912866B0] Jiten Pansara Senior Database Analyst T: +91 9158149600 E: jiten.pans...@fisglobal.com FIS | Advancing the way the wo

Re: Help with my MacOS PostgreSQL 12 installation

> On Aug 17, 2021, at 12:21 PM, Michael White wrote: > > This is my first post so if I’m in the wrong place please help me get to the > correct list. > > Issue: > > I installed PostgreSQL on my Mac over a year ago and since upgraded my disk > drive and OS to Big Sur. I am a retired Softwa