failed to setup barman backup when Posgres is running in Podman Container

Dear All, I am trying to use Barman to back up PostgreSQL, which is running in a Podman container. However, I encounter the error "WAL archive: FAILED," as shown below: #barman check testdb Server testdb: WAL archive: FAILED (please make sure WAL shipping is set up) PostgreSQL: OK superuser: OK

Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?

> Hello friends, > > I want to migrate a large Oracle table to PostgreSQL, which is > approximately 200GB in size and includes a LOB segment. This table has a > primary key column named "ID," which increments by one unit (similar to a > sequence). During the migration of this large table,

Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?

Hello friends, I want to migrate a large Oracle table to PostgreSQL, which is approximately 200GB in size and includes a LOB segment. This table has a primary key column named "ID," which increments by one unit (similar to a sequence). During the migration of this large table, sometimes the

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

Yes, you are right. Thank you Brs Hans Vào Th 2, 28 thg 8, 2023 lúc 14:43 Luca Ferrari đã viết: > On Fri, Aug 25, 2023 at 5:49 PM duc hiep ha > wrote: > > > > Hi, > > > > I've just found the root cause! In this command: > > ora2pg -c ora2pg.conf -t

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

thg 8, 2023 lúc 21:53 Luca Ferrari đã viết: > On Thu, Aug 24, 2023 at 6:19 PM duc hiep ha > wrote: > > [2023-08-24 18:07:14] Collecting 0 tables information in DBA_TABLES > took: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) > > I suspect there is a permission pr

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

8, 2023 vào lúc 23:34 Erik Wienhold đã viết: > > 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 -

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

> 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 >

Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

of that? Thanks Hans Vào Th 5, 24 thg 8, 2023 vào lúc 19:01 Luca Ferrari đã viết: > 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 t

ora2pg -c ora2pg.conf -t COPY -a tablename not working properly

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