Both features reside only in the client side, of course.
A virtual column allows to permanently show, in a table, a column
calculated from a _javascript_-alike _expression_. That _expression_ is
based on other columns of the table and offers several
mathematica
De: Alvaro Herrera
Enviado: quarta-feira, 1 de abril de 2020 23:38
Para: Edson Richter
Cc: pgsql-general
Assunto: Re: It is possible to force periodically switch xlog?
On 2020-Apr-02, Edson Richter wrote:
> Actually, I do have a stand by server I wish to upda
On 2020-Apr-02, Edson Richter wrote:
> Actually, I do have a stand by server I wish to update a bit more
> frequently in low traffic servers.
It is better to use streaming replication for that. Using the WAL
archive for that is an archaic mechanism now.
--
Álvaro Herrerahttps:/
De: Kyotaro Horiguchi
Enviado: quarta-feira, 1 de abril de 2020 22:22
Para: da...@pgmasters.net
Cc: edsonrich...@hotmail.com ;
pgsql-gene...@postgresql.org ;
alvhe...@2ndquadrant.com
Assunto: Re: It is possible to force periodically switch xlog?
At Wed, 1 Ap
De: David Steele
Enviado: quarta-feira, 1 de abril de 2020 22:09
Para: Edson Richter ; pgsql-general
Cc: Alvaro Herrera
Assunto: Re: It is possible to force periodically switch xlog?
On 4/1/20 7:19 PM, Edson Richter wrote:
>
> IIRC archive_timeout does pr
At Wed, 1 Apr 2020 21:09:20 -0400, David Steele wrote in
> On 4/1/20 7:19 PM, Edson Richter wrote:
> > IIRC archive_timeout does precisely that.
> > I would assume that "archive_mode" must be "on" or "always" - but I do
> > have "archive_mode=off".
>
> I'm not sure what the point of switchin
On 4/1/20 7:19 PM, Edson Richter wrote:
IIRC archive_timeout does precisely that.
I would assume that "archive_mode" must be "on" or "always" - but I do
have "archive_mode=off".
I'm not sure what the point of switching the WAL segment would be with
archive_mode=off.
What are you tryin
On Wednesday, April 1, 2020, David Gauthier
wrote:
> psql (9.6.7, server 11.3) on linux
>
> I want to do something like this
> (intentionally bad sql but will illustrate the need)
>
> select s.name,s.grade from students s where s.class='math'
> union
> select 'whole class', class_grade from all_c
psql (9.6.7, server 11.3) on linux
I want to do something like this
(intentionally bad sql but will illustrate the need)
select s.name,s.grade from students s where s.class='math'
union
select 'whole class', class_grade from all_classes where class=s.class
Of course it's that "where class=s.clas
De: Alvaro Herrera
Enviado: quarta-feira, 1 de abril de 2020 19:55
Para: Abdul Sayeed
Cc: Edson Richter ; pgsql-general
Assunto: Re: It is possible to force periodically switch xlog?
On 2020-Apr-02, Abdul Sayeed wrote:
> Hi Edson,
>
> You can switch by using
On 2020-Apr-02, Abdul Sayeed wrote:
> Hi Edson,
>
> You can switch by using below command below PG 10.
>
> Select pg_switch_xlog();
>
> And there is no parameter present to switch it.
IIRC archive_timeout does precisely that.
--
Álvaro Herrerahttps://www.2ndQuadrant.com/
Post
Hi Edson,
You can switch by using below command below PG 10.
Select pg_switch_xlog();
And there is no parameter present to switch it.
Regards,
Abdul Sayeed
On Thursday, April 2, 2020, Edson Richter wrote:
> I would like to know if there is any parameter I can set to force postgres
> to swi
I would like to know if there is any parameter I can set to force postgres to
switch xlog periodically, even if it not reach the 16MB size?
Thanks,
Edson.
On 4/1/20 9:33 AM, Roberto Della Pasqua wrote:
On 4/1/20 9:17 AM, Roberto Della Pasqua wrote:
Hello, please some questions about a newbie Postgresql user:
- what is the best method to keep the data replicated (for backup purposes):
Can be possible to deploy a master/slave with realtime data rep
negora schrieb am 01.04.2020 um 21:44:
It has lots of useful features, such as good query completion, row
coloring, virtual columns, virtual foreign keys
What kind of feature is "virtual foreign keys"?
Or "virtual columns" in the context of a SQL GUI tool
> - does dbeaver is a good frontend for pg administration?
It is an excellent sql client tool and I use it heavily for Redshift,
SQLServer, Snowflake and PG.
However it is a not dba tool in the sense that it can DBA specific details and
graphs as shown in pgadmin.
On 01/04/2020 18:17, Roberto Della Pasqua wrote:
> Hello, please some questions about a newbie Postgresql user:
>
> - what is the best method to keep the data replicated (for backup purposes):
> Can be possible to deploy a master/slave with realtime data replication and
> adding a storage where do
On 2020-Apr-01, Silvio Fabi - NBS srl wrote:
> WAL Archive process on my DB Postgresql 10 is not working.
> the WAL Archive file 0001020A0073 was accidentally deleted
> and there is no backup.
> Postgresql tries to run the following command:
> rsync -a pg_wal/0001020A0073
>
Hi,
WAL Archive process on my DB Postgresql 10 is not working.
the WAL Archive file 0001020A0073 was accidentally deleted
and there is no backup.
Postgresql tries to run the following command:
rsync -a pg_wal/0001020A0073
barman@database:/var/lib/barman/database/incoming/00
On 4/1/20 9:17 AM, Roberto Della Pasqua wrote:
> Hello, please some questions about a newbie Postgresql user:
>
> - what is the best method to keep the data replicated (for backup purposes):
> Can be possible to deploy a master/slave with realtime data replication and
> adding a storage where do
On 4/1/20 9:17 AM, Roberto Della Pasqua wrote:
Hello, please some questions about a newbie Postgresql user:
- what is the best method to keep the data replicated (for backup purposes):
Can be possible to deploy a master/slave with realtime data replication and
adding a storage where do a journa
Hello, please some questions about a newbie Postgresql user:
- what is the best method to keep the data replicated (for backup purposes):
Can be possible to deploy a master/slave with realtime data replication and
adding a storage where do a journaled backup of the database, eg. a backup
increme
On 4/1/20 7:43 AM, Dummy Account wrote:
Please post to list also.
Ccing list.
Hello,
So I went to this
link: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
I downloaded version 12.2 for Mac OS X
I selected all the defualt installation wizard prompts by just selecting
"Ne
On 4/1/20 6:35 AM, AC Gomez wrote:
I'm trying to write a function that eventually will rotate users.
Currently I have the code below which works and creates a new user using
the prior user which ultimately has the same rights as the master user,
ie, can do everything.
select mysch.dblink('dbn
Greetings,
We prefer to use in-line responses, please don't top-post on these
lists.
* Alastair McKinley (a.mckin...@analyticsengines.com) wrote:
> Thanks for looking at this! It seems like there are quite a few performance
> gotchas around leaky operators and RLS, this is my second encounter w
I'm trying to write a function that eventually will rotate users. Currently
I have the code below which works and creates a new user using the prior
user which ultimately has the same rights as the master user, ie, can do
everything.
select mysch.dblink('dbname=mydb user=themasteruser password=abc
Hello,
I am running postgres 11.5 and we were having issues with shared segments.
So I increased the max_connection as suggested by you guys and reduced my
work_mem to 600M.
Right now instead, it is the second time I see this error :
ERROR: could not resize shared memory segment "/PostgreSQL.213
Hi Tom,
This is the solution I went with.
create policy X on tableX for select to new_role using (
has_table_read_permission(tableX.column) );
This covers all usage of the table and then for APIs that utilise leaky
operators:
create function with_leaky_operator(args) returns setof tableX as
$
On 2020-04-01 01:30, Amitabh Kant wrote:
On Tue, Mar 31, 2020 at 5:58 PM Turritopsis Dohrnii Teo En Ming
wrote:
Does phpMyAdmin support PostgreSQL?
On 2020-03-31 20:15, Ben Madin wrote:
and \q works in MySQL, so it may not be different anyway :)
On Tue, 31 Mar 2020 at 08:18, Tom Lane wrote
29 matches
Mail list logo
