Re: [GENERAL] wal_retrieve_retry_interval

2017-05-29 Thread Ludovic Vaugeois-Pepin
On Tue, May 30, 2017 at 12:20 AM, Michael Paquier wrote: > On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin > wrote: >> On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin >> wrote: >>> It really is set at 3s on all

Re: [GENERAL] wal_retrieve_retry_interval

2017-05-29 Thread Michael Paquier
On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin wrote: > On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin > wrote: >> It really is set at 3s on all servers (master and standbies) earlier in the >> "deployment" process at the same time

Re: [GENERAL] Does NUMERIC lose precision?

2017-05-29 Thread Tom Lane
Kaiting Chen writes: > Hi everyone. I’m trying to perform some exact precision arithmetic with > PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized > NUMERIC type to perform exact precision arithmetic: Division is inherently inexact, except in

Re: [GENERAL] Does NUMERIC lose precision?

2017-05-29 Thread Melvin Davidson
On Mon, May 29, 2017 at 4:19 PM, Kaiting Chen wrote: > Hi everyone. I’m trying to perform some exact precision arithmetic with > PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized > NUMERIC type to perform exact precision arithmetic: > > # SELECT

[GENERAL] Does NUMERIC lose precision?

2017-05-29 Thread Kaiting Chen
Hi everyone. I’m trying to perform some exact precision arithmetic with PostgreSQL’s NUMERIC type. However I can’t seem to get the unparameterized NUMERIC type to perform exact precision arithmetic: # SELECT 2::NUMERIC ^ 64; ?column?

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
On Mon, May 29, 2017 at 7:17 PM, Adrian Klaver wrote: > On 05/29/2017 06:40 AM, PAWAN SHARMA wrote: > >> >> > ya, but how can fix it.?? >> >> because memory is not an issue on both the server. >> >> >> Hi Chris, >> >> I am able to get the output script in

[GENERAL] Memorial Day

2017-05-29 Thread Melvin Davidson
*On this Memorial Day, Let us not forget the many that gave their lives so that we can enjoy our Freedom today. I give thanks to all my fellow veterans, and those still on active duty. May future generations still remember us and grow to never know the horrors of war.Da Nang 1969->'70* -- *Melvin

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread Adrian Klaver
On 05/29/2017 06:40 AM, PAWAN SHARMA wrote: ya, but how can fix it.?? because memory is not an issue on both the server. Hi Chris, I am able to get the output script in output.sql but now data migration is the big problem.

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread Neil Anderson
>>> >>> >> ya, but how can fix it.?? >> >> because memory is not an issue on both the server. >> > I've never used ora2pg but there is some documentation saying that often an out of memory issue can be fixed by adjusting your DATA_LIMIT setting.

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
On Mon, May 29, 2017 at 6:54 PM, PAWAN SHARMA wrote: > > > On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote: > >> [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) >>> [>] 1/2 total rows (50.0%) - (4 sec.,

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
On Mon, May 29, 2017 at 6:51 PM, Chris Mair wrote: > [>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) >> [>] 1/2 total rows (50.0%) - (4 sec., avg: 0 >> recs/sec). >> Out of memory!] 1/2 rows (50.0%) on total estimated

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread Chris Mair
[>] 1/1 rows (100.0%) Table MYTAB (0 recs/sec) [>] 1/2 total rows (50.0%) - (4 sec., avg: 0 recs/sec). Out of memory!] 1/2 rows (50.0%) on total estimated data (4 sec., avg: 0 recs/sec) Issuing rollback() due to DESTROY without explicit

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
On Mon, May 29, 2017 at 6:28 PM, Chris Mair wrote: > C:\ora2pg>ora2pg -c ora2pg.conf >> [>] 2/2 tables (100.0%) end of scanning. >> [>] 0/2 tables (0.0%) end of scanning. >> [>] 2/2 tables (100.0%) end of

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread Chris Mair
C:\ora2pg>ora2pg -c ora2pg.conf [>] 2/2 tables (100.0%) end of scanning. [>] 0/2 tables (0.0%) end of scanning. [>] 2/2 tables (100.0%) end of table export. Looks good so far. This means you could connect to Oracle DB now.

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
On Mon, May 29, 2017 at 2:49 PM, Chris Mair wrote: > I am facing below issue while running below command. >> >> *C:\ora2pg>ora2pg -c ora2pg.conf* >> DBI connect('host=;sid=;port=',',...) >> failed: ORA-01017: invalid username/p >> assword; logon denied (DBD ERROR:

Re: [GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread Chris Mair
I am facing below issue while running below command. *C:\ora2pg>ora2pg -c ora2pg.conf* DBI connect('host=;sid=;port=',',...) failed: ORA-01017: invalid username/p assword; logon denied (DBD ERROR: OCISessionBegin) at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376. FATAL: 1017 ... ORA-01017:

[GENERAL] Oracle to PostgreSQL Migration.

2017-05-29 Thread PAWAN SHARMA
Hi All, I am going to migrate Oracle database into PostgreSQL using ora2pg tools. I have installed Strawberry Perl. C:\ora2pg>perl -v This is perl 5, version 24, subversion 1 (v5.24.1) built for MSWin32-x64-multi-thread Copyright 1987-2017, Larry Wall I am facing below issue while running

Re: [GENERAL] plpgsql function with offset - Postgres 9.1

2017-05-29 Thread Albe Laurenz
Patrick B wrote: > I am running a background task on my DB, which will copy data from tableA to > tableB. For > that, I'm writing a PL/PGSQL function which basically needs to do the > following: > > > 1.Select the data from tableA > 2.The limit will be put when calling the function >