An addition to my previous post (marked as [addition]).
From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org]
Sent: Samstag, 14. Juli 2018 08:23
To: 'Łukasz Jarych' ; pgsql-gene...@postgresql.org
Subject: RE: Read only to schema
Hello
From: Łukasz Jarych [mailto:jarys...@gmai
Hello
From: Łukasz Jarych [mailto:jarys...@gmail.com]
Sent: Freitag, 13. Juli 2018 16:39
To: pgsql-gene...@postgresql.org >> PG-General Mailing List
Subject: Re: Read only to schema
I found something like this:
CREATE ROLE readonly_user
WITH LOGIN
ENCRYPTED PASSWORD '
Hi,
given this setup:
create table part2 ( a int, list varchar(10) ) partition by hash (a);
create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER
0);
create table part2_2 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER
1);
create table part2_3 partition
Ok, Done!
thanks for you help
Em sex, 13 de jul de 2018 às 10:29, Adrian Klaver
escreveu:
> On 07/12/2018 04:56 PM, Edgard Battisti Guimarães wrote:
> > --- The ODBC Global tracing was turned on too but any one entry was made
> > from the powerbuilder app.
> >
> > --- No problem on sending the
On 2018-Jul-13, Sean McIntyre wrote:
> Quick correction :)
>
> I am running PostgreSQL *9.6.8* on AWS RDS. I'm going to try to pg-repack
> the table and will look to upgrade to *9.6.9* (though it's not presently
> available on RDS).
Yay RDS ...
--
Álvaro Herrerahttps://www.2ndQ
Quick correction :)
I am running PostgreSQL *9.6.8* on AWS RDS. I'm going to try to pg-repack
the table and will look to upgrade to *9.6.9* (though it's not presently
available on RDS).
Sean
On Fri, Jul 13, 2018 at 11:14 AM Sean McIntyre <
sean.mcint...@warbyparker.com> wrote:
> Dear all,
>
> I
Dear all,
I just wanted to report that I found similar error "found multixact from
before relminmxid" that Alexandre Arruda and Jeremy Finzel recently
reported and discussed with Andres Freund. (Thanks all for good notes.)
I get this error when vacuuming a specific table in my high-transaction
OL
On Fri, Jul 13, 2018, 7:35 PM Daniel Westermann <
daniel.westerm...@dbi-services.com> wrote:
> Hi,
>
> given this setup:
>
> create table part2 ( a int, list varchar(10) ) partition by hash (a);
> create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3,
> REMAINDER 0);
> create table pa
I found something like this:
CREATE ROLE readonly_user
WITH LOGIN
ENCRYPTED PASSWORD '1234'
ALTER ROLE readonly_user
SET search_path to
public
GRANT CONNECT
ON DATABASE "TestDb"
TO readonly_user;
GRANT USAGE
ON SCHEMA public
TO readonly_user;
GRANT USAGE
ON AL
From: Nicola Contu [mailto:nicola.co...@gmail.com]
Sent: Friday, July 13, 2018 6:19 AM
To: pgsql-general@lists.postgresql.org
Cc: Alessandro Aste
Subject: Monitor repl slot size
Hello,
we used to monitor the replication slot size on postgres 9.6.6 with the
following query:
SELECT pg_xlog_locati
> -Ursprüngliche Nachricht-
> Von: Tom Lane
>
> > If you're an server admin you can disable the extension (editing
> > shared_pre_load_libraries GUC), change password and then enable the
> > extension again...
I am aware of this and all the other points.
> Or more to the point: exactly
On 07/13/2018 06:56 AM, Łukasz Jarych wrote:
Hmm so maybe better is use text field here
Well it really depends on what you want to do with the field.
Best,
Jacek
--
Adrian Klaver
adrian.kla...@aklaver.com
Hi,
given this setup:
create table part2 ( a int, list varchar(10) ) partition by hash (a);
create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER
0);
create table part2_2 partition of part2 FOR VALUES WITH (MODULUS 3, REMAINDER
1);
create table part2_3 partition of
Hmm so maybe better is use text field here
Best,
Jacek
pt., 13 lip 2018 o 15:36 Adrian Klaver
napisał(a):
> On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
> > Hi Guys,
> >
> > i created boolean in postgresql table (in attachment) but linked table
> > in Access see this as short text.
> >
> >
=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes:
> 2018-07-13 9:01 GMT-03:00 Guillaume Lelarge :
>> 2018-07-13 13:57 GMT+02:00 :
>>> I’d like to disable the TRUST authentication method for certain servers
>>> where modification of pg_hba.conf and restarting a service is fairly easy
>>> for a numbe
On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table
in Access see this as short text.
I checked in odbc option Bools as Char to false and True is -1 as
true.but still tihs is not working.
Define working.
I found li
2018-07-13 15:19 GMT+02:00 Fabrízio de Royes Mello
:
>
> 2018-07-13 9:01 GMT-03:00 Guillaume Lelarge :
>
>> 2018-07-13 13:57 GMT+02:00 :
>>
>>> I’d like to disable the TRUST authentication method for certain servers
>>> where modification of pg_hba.conf and restarting a service is fairly easy
>>>
Hi Hellmuth,
Thanks for the response and the new approach; a LATERAL JOIN is new to me.
Unfortunately it seems to have the same performance characteristics and
query plan. The aggregation in the lateral join still executes for every
row (eg. if my base query has 50 rows, I get "Aggregate (...
On 07/12/2018 04:56 PM, Edgard Battisti Guimarães wrote:
--- The ODBC Global tracing was turned on too but any one entry was made
from the powerbuilder app.
--- No problem on sending the entire PB app, but it's really big, so
follows the initial script with the connect and the ini file content
2018-07-13 9:01 GMT-03:00 Guillaume Lelarge :
> 2018-07-13 13:57 GMT+02:00 :
>
>> I’d like to disable the TRUST authentication method for certain servers
>> where modification of pg_hba.conf and restarting a service is fairly easy
>> for a number of users.
>>
>>
>>
>> I looked at this example http
> I'm not sure this is such a good idea. You may need the trust authentication
> method,
> for example if you forgot the superuser password. Otherwise, there's good
> chance
> you might use the ClientAuthentication hook to do what you want.
Thanks for your feedback.
Klaus
Am 13.07.2018 um 13:10 schrieb Rijo Roy:
Hello Experts,
Today, my colleague asked me if there was any way to check the
progress of recovery (backup-recovery) in Postgresql. I told him to
check the postgresql logs and look out for keywords such as recovery.
He was refreshing the database by
2018-07-13 13:57 GMT+02:00 :
> I’d like to disable the TRUST authentication method for certain servers
> where modification of pg_hba.conf and restarting a service is fairly easy
> for a number of users.
>
>
>
> I looked at this example https://wiki.postgresql.org/images/e/e3/Hooks_in_
> postgresq
I'd like to disable the TRUST authentication method for certain servers
where modification of pg_hba.conf and restarting a service is fairly easy
for a number of users.
I looked at this example
https://wiki.postgresql.org/images/e/e3/Hooks_in_postgresql.pdf It appears
that creating a ClientAut
Hello Experts,
Today, my colleague asked me if there was any way to check the progress of
recovery (backup-recovery) in Postgresql. I told him to check the postgresql
logs and look out for keywords such as recovery. He was refreshing the database
by restoring a database backup but the method he
Maybe read-only view?
Best,
Jacek
pt., 13 lip 2018 o 07:00 Łukasz Jarych napisał(a):
> Hi Guys,
>
> Yesterday i tried all day to figure out system to read only schemas.
>
> I want to :
>
> 1. Create user who can login (user: jaryszek)
> 2. Create role who can read only data (only watching table
On 13/07/2018 13:19, Nicola Contu wrote:
Hello,
we used to monitor the replication slot size on postgres 9.6.6 with the
following query:
SELECT pg_xlog_location_diff(pg_current_xlog_location(), restart_lsn) FROM
pg_replication_slots WHERE slot_name = 'SLOT NAME';
We are moving to postgres 10.
Hello,
we used to monitor the replication slot size on postgres 9.6.6 with the
following query:
SELECT pg_xlog_location_diff(pg_current_xlog_location(), restart_lsn) FROM
pg_replication_slots WHERE slot_name = 'SLOT NAME';
We are moving to postgres 10.4 and we saw the pg_xlog_location_diff is not
Hi Guys,
sorry for my late answer. I tested this today and working like a charm!
You are brilliant ! thank you, saved my ass!
Best,
Jacek
śr., 11 lip 2018 o 10:30 Ken Tanzer napisał(a):
>
>
> On Tue, Jul 10, 2018 at 5:45 PM Adrian Klaver
> wrote:
>
>> select add_trigger('trg_test');
>>
>> te
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table in
Access see this as short text.
I checked in odbc option Bools as Char to false and True is -1 as true.but
still tihs is not working.
I found linke here:
http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean
Sorry,
my error.
pt., 13 lip 2018 o 09:52 Łukasz Jarych napisał(a):
> Hi,
>
> thank you.
> I think that i have to add sequance here...
>
> Best,
> Jacek
>
> pt., 13 lip 2018 o 09:50 Guillaume Lelarge
> napisał(a):
>
>> Hi,
>>
>> 2018-07-13 9:29 GMT+02:00 Łukasz Jarych :
>>
>>> hi,
>>>
>>> i am
Hi,
thank you.
I think that i have to add sequance here...
Best,
Jacek
pt., 13 lip 2018 o 09:50 Guillaume Lelarge
napisał(a):
> Hi,
>
> 2018-07-13 9:29 GMT+02:00 Łukasz Jarych :
>
>> hi,
>>
>> i am trying to alter table :
>>
>> ALTER TABLE logging.t_history
>> alter column "id" GENERATED ALWA
Hi,
2018-07-13 9:29 GMT+02:00 Łukasz Jarych :
> hi,
>
> i am trying to alter table :
>
> ALTER TABLE logging.t_history
> alter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
>
> but this is not working. Error i have.
>
> How to change this properly?
>
>
Which error message do you get?
-
hi,
i am trying to alter table :
ALTER TABLE logging.t_history
alter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
but this is not working. Error i have.
How to change this properly?
Best,
Jacek
34 matches
Mail list logo
