On 7/18/23 01:18, Luca Ferrari wrote:
Dear all,
I'm looking for ideas here, and it could be someone already stepped
into declarative partitioning of an existing database where Hibernate
(a Java ORM) handles the tables.
The situation is as follows:
create table foo( id primary key, a_date date, .
Dear all,
I'm looking for ideas here, and it could be someone already stepped
into declarative partitioning of an existing database where Hibernate
(a Java ORM) handles the tables.
The situation is as follows:
create table foo( id primary key, a_date date, ... );
Now, the trivial way to partition
Hi, suggest to automatically rename backup_manifest to backup_manifest.old
like backup_label when postgres start up successfully because it has no use
anymore for pg_verifybackup after postgres has been started.
For future reference, this parameter was removed in v17 via commit 884eee5.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
Thanks a lot tomas, i will try it.
I have find out that there is a 'aggregation' function in the frontend.
But this is MySQL specific and I have no idea the transform it to postgres.
It looks like:
'REPLACE INTO aggregate (channel_id, type, timestamp, value, count)
SELECT channel_id, ? AS type
I too had problems with 7.4. They went away when I downgraded to 7.2
C E Eriksson
Sent from iPhone
> On 17 Jul 2023, at 18:31, Erik Wienhold wrote:
>
>
>>
>> On 17/07/2023 16:30 CEST Adrian Klaver wrote:
>>
>>
>> The other screenshot is a pgAdmin issue. I have seen quite a few
>> questio
> On 17/07/2023 16:30 CEST Adrian Klaver wrote:
>
>
> The other screenshot is a pgAdmin issue. I have seen quite a few
> questions about this on Stack Overflow recently. Seems to be related to
> version 7.4. My suggestion would be to file an issue here:
>
> https://github.com/pgadmin-org/pgadmin4/
On Mon, Jul 17, 2023, 08:44 Tomas Vondra
wrote:
>
>
> On 7/17/23 16:11, Yi Sun wrote:
> > Hello guys,
> >
> > Our read only user is okay to be granted read only permission of tables.
> >
> > How to grant read only functions execute permission to read only user,
> > is there a simple way to do it
On 7/17/23 16:11, Yi Sun wrote:
> Hello guys,
>
> Our read only user is okay to be granted read only permission of tables.
>
> How to grant read only functions execute permission to read only user,
> is there a simple way to do it please? If not, how to get the list of
> read only functions pl
On 7/16/23 23:47, Baskar Muthu wrote:
Reply to list also.
Ccing list.
I tried many times but they showed the same things and it ran for more
than 3 hours. how to resolve this issue. If you have any idea please let
me know.Thanking you..
OS version - Windows 11
Postgre sql version - 14.3
I
Hello guys,
Our read only user is okay to be granted read only permission of tables.
How to grant read only functions execute permission to read only user, is
there a simple way to do it please? If not, how to get the list of read
only functions please? Then can grant one by one based on the list
On 7/17/23 04:13, basti wrote:
[snip]
The Indexes:
volkszaehler=# SELECT tablename,indexname,indexdef FROM pg_indexes WHERE
tablename LIKE 'data%' ORDER BY tablename,indexname;
tablename | indexname | indexdef
---++---
On 7/17/23 13:20, Tomas Vondra wrote:
> ...
>
> It's always going to be slow with the COUNT(DISTINCT), I'm afraid.
>
> Not sure how much you can modify the query / database, and how accurate
> results you need. If you're OK with estimates, you can try postgres-hll
> extension [2] which estimates
On 7/17/23 11:13, basti wrote:
> Hello,
>
> I use volkszaehler.org (a DIY Smartmeter) on postgres.
>
> The hardware is a Dual-core 2,4 GHz amd64-CPU and 6 GB RAM.
> The databse is approx. 1.5 GB on SSD
>
> my local config looks like:
>
> root@vz:~# cat /etc/postgresql/15/main/conf.d/local.co
On 7/17/23 05:23, Wen Yi wrote:
> Hi community,
> I am reading the 'Generate code for query jumbling through
> gen_node_support.pl'
> (https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org)
> to understand the principle of the postgres's node, but I really don't know
Hello,
I use volkszaehler.org (a DIY Smartmeter) on postgres.
The hardware is a Dual-core 2,4 GHz amd64-CPU and 6 GB RAM.
The databse is approx. 1.5 GB on SSD
my local config looks like:
root@vz:~# cat /etc/postgresql/15/main/conf.d/local.conf
# DB Version: 15
# OS Type: linux
# Total Memory (
You can use a DO block or write a function do to this.
It takes some practice (and you need to use EXECUTE FORMAT())
If users need to be able to change their own users, something like this
works:
CREATE FUNCTION change_my_password(in_password, text)
returns void language plpgsql as
$$
begin
E
I think maybe you can check the pg_hba.conf, change the method to the 'trust'.
(Allow the connection unconditionally. This method allows anyone that can
connect to the PostgreSQL database server to login as any PostgreSQL user they
wish, without the need for a password or any other authentication
Hi community,
I am reading the 'Generate code for query jumbling through gen_node_support.pl'
(https://www.postgresql.org/message-id/E1pMk51-000puf-55%40gemulon.postgresql.org)
to understand the principle of the postgres's node, but I really don't know
the meaning of the word 'query jumbling'.
Thanks for your explanation.
Laurenz Albe 于2023年7月13日周四 17:48写道：
> On Thu, 2023-07-13 at 13:12 +0800, 黄宁 wrote:
> > I want to create some temporary tables in SPI, but after I created the
> table and inserted the data, I can’t query any data, why?
> >
> > the postgres version:
> > PostgreSQL 13.6
20 matches
Mail list logo
