When the materialized view was refreshing concurrently, I saw the pg_lock like
this: there was no response within 30 seconds when the api calls this query,
and we got api time out.
sasanalytics=> select relation::regclass, * from pg_locks where not granted;
relation
Hellen Jiang writes:
> When the materialized view was refreshing concurrently, I saw the pg_lock
> like this: there was no response within 30 seconds when the api calls this
> query, and we got api time out.
Well, that seems to confirm my idea that the REFRESH is blocked behind
somebody else's
Greetings,
* Ron (ronljohnso...@gmail.com) wrote:
> On 8/21/23 18:49, Bruce Momjian wrote:
> > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote:
> > > It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text=
> > > Q%3A%20What%20features%20will%20PostgreSQL%2016%20have
Greetings,
* Emile Amewoto (emil...@yahoo.com) wrote:
> Here is the high level process:
> 1- Create the user x without password in Postgres.
> 2- Assign role or roles to the user x
> 3- Update pg_hba.conf with the ldap connection link.
>
> You might need cert for the ldap to connect to AD, assu
Hellen Jiang writes:
> But from time and time, we found that it took forever to refresh materialized
> view( normally or concurrently), and there is no response to query from this
> materialized view.
That sounds like a locking problem. Have you looked into pg_locks
while this is happening, to
Hi All,
We have one business critical materialized view( let’s called
materialized_view_1) which contains around 16M records.
This materialized view is refreshed CONCURRENTLY every 1 minute, and got
refreshed normally (without CONCURRENTLY) every 6 hours.
But from time and time, we found that i
Yes i can access the target table on Postgres, because i have to create it
as strukture on the posgres before transfer data. Actually in the past i
have done it successfully many time. The Problem here is some thing
happened in between in my computer, or there is a bug on Ora2pg.
Vào Th 5, 24 thg
Thanks for you idea, here is the log file when i used -d flag:
D:\ora2pg\hans>ora2pg -c ora2pg.conf -t COPY -a codes1 -d
WARNING: target PostgreSQL version must be set in PG_VERSION configuration
directive. Using default: 11
[2023-08-24 18:07:13] Ora2Pg version: 24.0
[2023-08-24 18:07:13] Expo
> On 24/08/2023 15:49 CEST duc hiep ha wrote:
>
> Further updated to the below Post. Shortly question:
> * Saving data to file using the following Command is fine:
> ora2pg -c ora2pg.conf -t COPY -o data.sql schema/data/
> * Direct copy data from Oracle to Postgres doesn't work
> (comm
Further updated to the below Post. Shortly question:
- Saving data to file using the following Command is fine:
ora2pg -c ora2pg.conf -t COPY -o data.sql schema/data/
- Direct copy data from Oracle to Postgres doesn't work(command: ora2pg
-c ora2pg.conf -t COPY -a tablename). Everythin
On Thu, Aug 24, 2023 at 3:49 PM duc hiep ha wrote:
>
> do i have to completely delete the Ora2pg and install it again!? or some
> other softaware running on the computer have prevented this transfer's
> process.
I don't think so.
Does the -d flag helps in finding out the problem?
Luca
On Thu, Aug 24, 2023 at 1:51 PM duc hiep ha wrote:
>
> no data have been transfered to postgres. it shows: 0/0 tables(100%) end of
> scanning.
>
Even if asking only for the table structure?
Can you perform an offline migration (i.e., saving to file)?
I would suggest to ask on ora2pg support.
L
Hello Friends,
i have an very strange issue that i have tried to fix in hours but couldn't
solve it. Could you please help me this case:
- I have installed ora2pg to migrate oracle table to postgres,
everything was working fine for several projects before
- recently i started a new projec
On Thu, Aug 24, 2023 at 11:34 AM Erik Wienhold wrote:
> > On 24/08/2023 10:11 CEST Dominique Devienne wrote:
> > On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> > > The readwrite user (not the admin) would need to issue ALTER DEFAULT
> > > PRIVILEGES granting that.
>
> > And I don't remembe
> On 24/08/2023 10:11 CEST Dominique Devienne wrote:
>
> On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> >
> > The readwrite user (not the admin) would need to issue ALTER DEFAULT
> > PRIVILEGES granting that.
>
> Hi. I'm confused Tom. Why should it matter who created the new tables?
>
> I'm al
On Wed, Aug 23, 2023 at 7:46 PM Tom Lane wrote:
> 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
>
The original poster was building against Greenplum 6, it’s expected to fail.
Try this https://github.com/adam8157/oracle_fdw_greenplum, it’s not based on
the lasts oracle_fdw, but likely easy to rebase.
From: Adrian Klaver
Date: Thursday, August 24, 2023 at 15:19
To: Jethro Elmer Sanidad , Ian
17 matches
Mail list logo
