Dear team ,
This is Vimal from WIpro. We are using Postgres 14 , while connecting
postgres from application we are getting "*Could not open R2DBC Connection
for transaction;" error in pod . *We have increased the max number of
connections in postgres from 100 to 1000 , still we are facing the sam
Hi
Can you check the following.
1. The machine 10.0.202.121 is accessible.
2. Check the firewall settings.
3. Check the pg_hha.conf Settings.
Regards
Kashif Zeeshan
On Wed, Jul 10, 2024 at 12:48 PM vimal va wrote:
> Dear team ,
>
> This is Vimal from WIpro. We are using Postgres 14 , while
El día miércoles, julio 10, 2024 a las 01:18:06 +0530, vimal va escribió:
> Dear team ,
>
> This is Vimal from WIpro. We are using Postgres 14 , while connecting
> postgres from application we are getting "*Could not open R2DBC Connection
> for transaction;" error in pod . *We have increased the
On Tue, 9 Jul 2024, Adrian Klaver wrote:
The error:
LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636')
is giving you the line number and the data:
a) Navigate to that line number using whatever method Joe has for that.
b) Search for '85250 Red House Rd'.
Adrian,
With t
On Tue, 9 Jul 2024, Craig McIlwee wrote:
The input file is 488 lines (presumably, since Rich said the file should
insert 488 rows). It seems like too much of a coincidence that the last
character of the last line is really the error. My guess is that there is
an unmatched character, perhaps a pa
On Wednesday, July 10, 2024, Rich Shepard wrote:
>
> Partial screenshot attached.
And what are the first few lines of the file? Use text, not screenshots.
David J.
If the file has these line breaks you show, then can make it to multiple
'INSERT INTO' instead.
Search for lines starting with parentese begin '(' and replace it with the
correct INSERT and last comma to semi-colon:
cat i.sql | sed -e 's/^(/INSERT INTO foo VALUES(/' -e 's/,$/;/'
Does the file c
On Wed, Jul 10, 2024 at 2:59 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
>
> And what are the first few lines of the file? Use text, not screenshots.
>
Yes the line with 'INSERT'
grep -ni 'INSERT INTO' scripts/insert-addrs.sql
--
𝕳𝖆𝖓𝖘 𝕾𝖈𝖍𝖔𝖚
☏ ➁➁ ➅➃ ➇⓪ ➁⓪
> On Jul 9, 2024, at 7:21 PM, Krishnakant Mane wrote:
>
>
>> On 7/10/24 06:44, Guyren Howe wrote:
>>> On Jul 9, 2024, at 17:58, Krishnakant Mane wrote:
>>> Hello.
>>>
>>> I have a straight forward question, but I am just trying to analyze the
>>> specifics.
>>>
>>> So I have a set of que
On Wed, 10 Jul 2024, David G. Johnston wrote:
And what are the first few lines of the file? Use text, not screenshots.
David,
insert into locations
(company_nbr,loc_nbr,loc_name,addr1,city,state_code,postcode) values
(2564,1,default,'4250 Hopkins Rd','Ontario','OR','97914'),
(2565,1,default,
On Wed, 10 Jul 2024, Hans Schou wrote:
If the file has these line breaks you show, then can make it to multiple
'INSERT INTO' instead.
Hans,
I thought of that, but forgot it. This makes more sense than dividing the
file in small chunks.
Thanks,
Rich
On 2024-07-09 03:35:33 +, Buoro, John wrote:
> I've dusted off my C books and coded a solution.
[...]
> When using SSPI you can grant access to a user by giving the login name as
> firstname.lastname@SOMEDOMAIN for example.
> PostgresSQL has no concept of groups, just roles.
> The code provided
On Wed, Jul 10, 2024 at 7:10 AM Peter J. Holzer wrote:
> On 2024-07-09 03:35:33 +, Buoro, John wrote:
> > I've dusted off my C books and coded a solution.
> [...]
> > When using SSPI you can grant access to a user by giving the login name
> as
> > firstname.lastname@SOMEDOMAIN for example.
>
On 2024-07-10 06:28:46 +0530, Krishnakant Mane wrote:
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to compute
> some results for generating financial report.
I am assuming that you aren'
On 2024-07-10 07:27:29 -0700, Ian Harding wrote:
>
>
> On Wed, Jul 10, 2024 at 7:10 AM Peter J. Holzer wrote:
>
> On 2024-07-09 03:35:33 +, Buoro, John wrote:
> > I've dusted off my C books and coded a solution.
> [...]
> > When using SSPI you can grant access to a user by g
On 7/10/24 05:30, Rich Shepard wrote:
On Tue, 9 Jul 2024, Adrian Klaver wrote:
The error:
LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636')
is giving you the line number and the data:
a) Navigate to that line number using whatever method Joe has for that.
b) Search for
On Wednesday, July 10, 2024, Rich Shepard wrote:
> On Wed, 10 Jul 2024, David G. Johnston wrote:
>
> And what are the first few lines of the file? Use text, not screenshots.
>>
>
> David,
>
> insert into locations (company_nbr,loc_nbr,loc_name,
> addr1,city,state_code,postcode) values
> (2564,1,d
On Wed, 10 Jul 2024, David G. Johnston wrote:
My first easy look for this setup is for any single quotes not adjacent to
either a comma or a parenthesis. Syntax highlighting should ideally have
caught this but I’d look anyway.
David,
I found an error on line 21 that I missed seeing every tim
Hi, ALL,
Is there an explicit autotools macro that can tell
the presence of PostgreSQL client library?
And that can be used with "configure" script.
Or I should be using AC_CHECK_MODULE() one?
Thank you.
Hi
st 10. 7. 2024 v 18:07 odesílatel Igor Korot napsal:
> Hi, ALL,
> Is there an explicit autotools macro that can tell
> the presence of PostgreSQL client library?
> And that can be used with "configure" script.
>
> Or I should be using AC_CHECK_MODULE() one?
>
I use
I use
https://github.com/
On Wed, Jul 10, 2024 at 11:11 AM Pavel Stehule wrote:
>
> Hi
>
> st 10. 7. 2024 v 18:07 odesílatel Igor Korot napsal:
>>
>> Hi, ALL,
>> Is there an explicit autotools macro that can tell
>> the presence of PostgreSQL client library?
>> And that can be used with "configure" script.
>>
>> Or I shou
Windows somehow aggregates the permissions allowed for all the Server
Principals (logins) associated with global groups of which your account is
a member. It’s a disaster. We would shortcut that disaster by making a
single group a PostgreSQL login.
It would be bad, but not as awful as SQL Server.
On Wed, 10 Jul 2024, Rob Sargent wrote:
I'm an emacs user too. Do you have show-paren enabled? This would show
that your file was ill-formed. M-p and M-n go previous/next matching
parentheses of all types.
Rob,
No, I haven't enabled show-paren.
Thanks for the tip,
Rich
Hi Krishnkant,
On Wed, Jul 10, 2024 at 2:58 AM Krishnakant Mane
wrote:
> Hello.
>
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to
> compute some results for generating financial report.
Hi All,
It's postgres database version 15.4. We have a table which is daily and is
approx. ~2TB in size having a total ~90 partitions. We have a requirement
to drop columns and add new columns to this table.
I Want to understand, If this can be done online? what is the fastest way
to drop/add colu
On Tue, Jul 9, 2024 at 8:58 PM Krishnakant Mane wrote:
> Hello.
>
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to
> compute some results for generating financial report.
>
> It involves
Great tip!!! Thx
El mié, 10 de jul de 2024, 16:17, Ron Johnson
escribió:
> On Tue, Jul 9, 2024 at 8:58 PM Krishnakant Mane
> wrote:
>
>> Hello.
>>
>> I have a straight forward question, but I am just trying to analyze the
>> specifics.
>>
>> So I have a set of queries depending on each other in
On 7/10/24 13:13, sud wrote:
Hi All,
It's postgres database version 15.4. We have a table which is daily and
is approx. ~2TB in size having a total ~90 partitions. We have a
requirement to drop columns and add new columns to this table.
I Want to understand, If this can be done online? what i
Hello list,
I have a table with 1000 partitions on PostgreSQL 16.
I notice that a fairly complicated query of the form:
SELECT ... GROUP BY ... LIMIT ...
causes the postgres backend process to grow insanely very fast, and the
kernel OOM killer to kill it rather soon.
It seems it tries to alloca
On Thu, 11 Jul 2024 at 13:19, Dimitrios Apostolou wrote:
> I have a table with 1000 partitions on PostgreSQL 16.
> I notice that a fairly complicated query of the form:
>
> SELECT ... GROUP BY ... LIMIT ...
>
> causes the postgres backend process to grow insanely very fast, and the
> kernel OOM ki
On Thu, Jul 11, 2024 at 2:52 AM Adrian Klaver
wrote:
>
> https://www.postgresql.org/docs/current/sql-altertable.html
>
> "The DROP COLUMN form does not physically remove the column, but simply
> makes it invisible to SQL operations. Subsequent insert and update
> operations in the table will stor
On Wed, Jul 10, 2024 at 6:37 PM Han Tang wrote:
> I am using range_agg() function, it works fine with original table value
>
> But when I try to do some update for range value, it will give back an empty
> list
>
> Select range_agg(b.r)
> From (
> Select int8range(lower(bin_range)+1, upper(bin_
32 matches
Mail list logo
