On Thu, Aug 24, 2023 at 2:49 AM Marcos Pegoraro wrote:
>
> Have you tried grant pg_read_all_data to readonly ?
>
I tried. seems pg_read_all_data really means "read all data no matter what".
so you cannot grant pg_read_all_data then revoke certain schema privileges.
begin;
create user my_user
Hi Avinash,
Thanks for your input.
On Wed, Aug 23, 2023 at 4:35 PM Avinash Vallarapu <
avinash.vallar...@gmail.com> wrote:
>
> On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate
> wrote:
>
>> Hi Team,
>>
>> We want to know if there are any open/known issues that we may face
>> post-migration of the
On 8/23/23 13:23, Hellen Jiang wrote:
Sorry it is a typo in the email. My readonly role is dbreadonly. It
works well so far except no access to new tables created by read write
role. It has access to new tables created by admin role.
I granted dbreadonly as the following:
-- Read-only role
Sorry it is a typo in the email. My readonly role is dbreadonly. It works well
so far except no access to new tables created by read write role. It has access
to new tables created by admin role.
I granted dbreadonly as the following:
-- Read-only role
GRANT CONNECT ON DATABASE mydatabase TO dbre
> On 23/08/2023 18:42 CEST Hellen Jiang wrote:
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to the new tables created by
> readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can
Hellen Jiang writes:
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to the new tables created by
> readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can grant the access to reado
Have you tried grant pg_read_all_data to readonly ?
regards
Marcos
Em qua., 23 de ago. de 2023 às 14:30, Hellen Jiang <
hji...@federatedwireless.com> escreveu:
> Hi,
>
>
>
> I have created readonly and readwrite roles with the following grants:
> however, readonly user does not have access to th
Hi,
I have created readonly and readwrite roles with the following grants: however,
readonly user does not have access to the new tables created by readwrite user.
(readonly user has the access to new tables created by admin).
Any idea how I can grant the access to readonly to make sure it has t
## Nick Renders (postg...@arcict.com):
> I was wondering if anyone had any good tips for "debugging" the
> archive_command in the postgresql.conf.
For starters, you get rather noisy logging when that command fails
(plus all the output from the command itself), so check your postgres
logfile first
Hello,
I was wondering if anyone had any good tips for "debugging" the archive_command
in the postgresql.conf.
I want to see what certain settings are when the command is run, like $PATH and
id, but I don't want it to be successful either, so that the WAL files remain
untouched.
Any tips?
Th
On 8/22/23 23:10, Jethro Elmer Sanidad wrote:
Hello,
Can you confirm in this email that our current version of PostgreSQL
(9.2.24) is not compatible with any of oracle_fdw versions released? And
you are recommending an upgrade? Thanks!
In your first post you said:
"Can you provide us downlo
On Wed, Aug 23, 2023, 07:25 Christian Barthel wrote:
> Hello,
>
> can anyone explain why the domain check is not generating an exception
> when used within PL/pgSQL ‘RETURN QUERY’ statement?
>
>
>
> 45 -- works not as expected:
> 46 CREATE OR REPLACE FUNCTION tf2() RETURNS SETOF t
> 47 AS $$
>
Hello,
can anyone explain why the domain check is not generating an exception
when used within PL/pgSQL ‘RETURN QUERY’ statement?
See tf2() and tf3() above - in particular, the INSERT statement in line
100 and 163:
--8<---cut here---start->8---
1
2 -- x,
On 8/21/23 20:50, Adrian Klaver wrote:
On 8/21/23 09:31, Rihad wrote:
On 8/21/23 20:17, Adrian Klaver wrote:
On 8/21/23 09:09, Rihad wrote:
On 8/21/23 20:00, Adrian Klaver wrote:
Sorry, they are all as per default, commented out in the config.
There are no long running queries, otherwis
2023年8月23日(水) 15:10 Jethro Elmer Sanidad :
> Hello,
>
> Can you confirm in this email that our current version of PostgreSQL
> (9.2.24) is not compatible with any of oracle_fdw versions released? And
> you are recommending an upgrade? Thanks!
>
OK, here's the summary:
- oracle_fdw builds against
On Wed, Aug 23, 2023 at 6:23 AM Tushar Takate
wrote:
> Hi Team,
>
> We want to know if there are any open/known issues that we may face
> post-migration of the DB cluster from centos7/RHEL7/OEL7 to RHEL8.
>
> Depends on the method you choose to perform this migration ?
If you are using pg_dump an
Hi Team,
We want to know if there are any open/known issues that we may face
post-migration of the DB cluster from centos7/RHEL7/OEL7 to RHEL8.
We came across one issue regarding collation(
https://wiki.postgresql.org/wiki/Locale_data_changes), the solution for
which is to reindex or use logical
Hi,
We have an application currently running on PostgreSQL 12, partitioned as
shown below. Database size is approx. 1.4TB. We are now in the process of
upgrading the application, using PostgreSQL 15. In the new version, there
is an optional step to implement 'primary key' on history table.
In the
18 matches
Mail list logo
