On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> Okey, I see no one was be able to solve this problem. But I could. May be
> for someone this will be useful too. There is solution.
[...]
> Now query is:
>
> SELECT genera
On 2023-10-23 16:31:30 -0700, Adrian Klaver wrote:
> On 10/23/23 14:55, p...@pfortin.com wrote:
> > Next, I made a query list for 30 tables, turned on timing and pasted the
> > queries. Pasting results inline:
> > ncsbe=# select count(*) from ncvhis_2012_12_06;
> > select count(*) from ncvhis_2016
Hi,
El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. But I could.
> May be
> > for someone this will be useful to
If a PgAmin view is created and tables it queries are missing, what will
happen?
If a PdAmin view is created, and it may take 20 hours to complete, what
will happen?
Would views automatically run, when you start the PgAmin?
Regards,
David
On 2023-10-26 11:56:56 +0200, Olivier Gautherot wrote:
> El jue, 26 oct 2023 11:15, Peter J. Holzer escribió:
> On 2023-10-25 17:48:46 +0200, Olivier Gautherot wrote:
> > El mié, 25 oct 2023 16:58, Олег Самойлов escribió:
> > Okey, I see no one was be able to solve this problem. B
On Thursday, October 26, 2023, Shaozhong SHI wrote:
> If a PgAmin view is created and tables it queries are missing, what will
> happen?
>
> If a PdAmin view is created, and it may take 20 hours to complete, what
> will happen?
>
> Would views automatically run, when you start the PgAmin?
>
>
Tes
Hello PostgreSQL Community,
I've recently developed a tool named PostgresFly that I'd like to share
with you. It's a Python-crafted tool designed specifically for Windows
users to remotely install PostgreSQL on Linux machines directly from the
source.
This approach offers the benefits of customizat
Hello!
What's the situation with Property Graph Queries in Postgres?
I've heard that it has become part of the SQL standard from this blog:
https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
How far in development is this feature? and is there an expected time f
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed on
our Postgresql servers. I would appreciate any input on how to uninstall
it. Thanks everyone for your time.
Very Respectfully
Yong
Anders Kildemand writes:
> What's the situation with Property Graph Queries in Postgres?
There isn't any.
> I've heard that it has become part of the SQL standard from this blog:
> https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new
> How far in development is th
On 10/26/23 03:56, Shaozhong SHI wrote:
If a PgAmin view is created and tables it queries are missing, what will
happen?
Easy enough to test:
create view test_vw as select * from non_existent_table;
ERROR: relation "non_existent_table" does not exist
LINE 1: create view test_vw as select * fr
On 10/26/23 05:42, Yongye Serkfem wrote:
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed
on our Postgresql servers. I would appreciate any input on how to
uninstall it. Thanks everyone for your time.
Need way more information:
1) ora2pg ver
On 10/26/23 07:42, Yongye Serkfem wrote:
Hello PostgreSQL Community,
I am having difficulties uninstalling ora2pg which I manually installed on
our Postgresql servers. I would appreciate any input on how to uninstall
it. Thanks everyone for your time.
Why do you have to uninstall it, when "ju
I'd like to express my appreciation for a project with a feature set so
extensive that a person might mistakenly assume that its goal was to cover
the spec comprehensively.
On Thu, Oct 26, 2023 at 10:32 AM Tom Lane wrote:
> Anders Kildemand writes:
> > What's the situation with Property Graph Q
Hi,
I have the postgres12 version running on centos7.
In pg_hba.conf file I have an entry like below:
hostall all /32md5
So from the above entry, I understand that all users can connect to all
databases from the remote ip.
But when I use pg_basebackup f
Atul Kumar writes:
> In pg_hba.conf file I have an entry like below:
> hostall all /32md5
That is an entry governing ordinary session connections ...
> Error that I got:
> pg_basebackup: error: FATAL: no pg_hba.conf entry for replication
> connection fro
On 10/26/23 09:51, Atul Kumar wrote:
Hi,
I have the postgres12 version running on centos7.
In pg_hba.conf file I have an entry like below:
host all all /32 md5
So from the above entry, I understand that all users can connect to all
databases from the rem
Anders Kildemand ezt írta (időpont: 2023. okt. 26., Cs,
14:38):
> What's the situation with Property Graph Queries in Postgres?
>
If the underlying question is how to utilize graph database functionality
in PostgreSQL, there are similar extensions that may be worth exploring:
- Apache AGE is a P
Hi team,
I was looking into using prepared statements and using the auto
plan_cache_mode. The issue is that the current sample of data collected to
determine whether to use custom plans or the generic one is very small and
susceptible to a bad set of queries that might pick the suboptimal choice.
Thanks, I appreciate the input
Regards
Yong
On Thu, Oct 26, 2023, 11:39 AM Ron wrote:
> On 10/26/23 07:42, Yongye Serkfem wrote:
>
> Hello PostgreSQL Community,
> I am having difficulties uninstalling ora2pg which I manually installed on
> our Postgresql servers. I would appreciate any input on
On Thu, Oct 26, 2023 at 10:56 AM Zain Kabani
wrote:
> I was looking into using prepared statements and using the auto
> plan_cache_mode. The issue is that the current sample of data collected to
> determine whether to use custom plans or the generic one is very small and
> susceptible to a bad se
as per response
"It allows anyone/anything on the local machine to connect to the database
without authentication. Whether that impacts any particular one/thing
depends on your personal setup."
There is already one line to serve your stated purpose
local all all
> On Oct 26, 2023, at 11:44, Atul Kumar wrote:
> There is already one line to serve your stated purpose
> local all alltrust
>
>
> That's why I specifically raised this question for below from postgresql
> experts
> hostall all
Please share the required link having such information in detail, It would
be more helpful to me.
Regards.
On Fri, Oct 27, 2023 at 12:16 AM Christophe Pettus wrote:
>
>
> > On Oct 26, 2023, at 11:44, Atul Kumar wrote:
> > There is already one line to serve your stated purpose
> > local
> On Oct 26, 2023, at 11:53, Atul Kumar wrote:
>
> Please share the required link having such information in detail, It would be
> more helpful to me.
https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
Hi Peter,
All of the following is based on using SQL_workbench/J (WB) (Mageia Linux
has not provided a viable pgAdmin4 package); WB is setup to autoload the
table row count and 10 rows. I'm sticking to one set of files where they
are all roughly 33.6M rows.
I've been doing a lot of digging and f
On Thu, Oct 26, 2023 at 11:46:18AM -0400, Raymond Brinzer wrote:
> I'd like to express my appreciation for a project with a feature set so
> extensive that a person might mistakenly assume that its goal was to cover the
> spec comprehensively.
Okay, I couldn't stop smiling from this comment. :-)
On Thu, 26 Oct 2023 15:50:16 -0400 p...@pfortin.com wrote:
>Hi Peter,
>
>All of the following is based on using SQL_workbench/J (WB) (Mageia Linux
>has not provided a viable pgAdmin4 package); WB is setup to autoload the
>table row count and 10 rows. I'm sticking to one set of files where they
>a
On 2023-10-27 12:03, p...@pfortin.com wrote:
I can't think of a common hardware bus/other that would only affect
PostgreSQL disk accesses.
Which file system is PostgreSQL being run on?
Asking because I remember seeing weirdness reported with *some* SSD
drives when used with ZFS:
https://gi
29 matches
Mail list logo