Migration from Oracle to Postgres

2020-05-05 Thread Jean Claude
Hi guys, I hope you're doing well. Simple question What are the best methods to migrate a huge table from Oracle to Postgres ? Cheers

watchdog issues

2018-07-17 Thread Jean Claude
Hello Guys' I have implement a pgpool-II cluster and the standby service want not to add on the watchdog info.. Some issues for help? [root@tes01 ~]# /usr/pgpool-10/bin/pcp_watchdog_info -p 9898 -U pgpool Password: 2 YES test01.adm.test.ch:5432 Linux test01 test01.test.cacc.ch test01.adm.test.ch

Fwd: Add to watchdog cluster request is rejected by node

2018-06-11 Thread Jean Claude
Hi all, How I can resolved this error after restart my pgpool-II standby ? Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-1] 2018-06-11 08:57:04: pid 3240: WARNING: checking setuid bit of if_up_cmd Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-2] 2018-06-11 08:57:04: pid 3240: DETAIL: ifup[/sbi

Add to watchdog cluster request is rejected by node

2018-06-11 Thread Jean Claude
Hi, The following error is a bug ? Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-1] 2018-06-11 08:57:04: pid 3240: WARNING: checking setuid bit of if_up_cmd Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-2] 2018-06-11 08:57:04: pid 3240: DETAIL: ifup[/sbin/ip] doesn't have setuid bit Jun 11 08:5

Re: Service pgpool

2018-06-11 Thread Jean Claude
used. > Normally on RHEL 7.x the systemd service is used to start a service. > > > On Fri, 8 Jun 2018 10:47:34 +0200 > Jean Claude wrote: > > > Hi Bo Peng, > > > > Thank you for your feedback. > > > > You can find the status of my service below : &

Re: Service pgpool

2018-06-08 Thread Jean Claude
odborough Road, Frenchs Forest NSW 2086, Australia > T +61 2 9452 9027 > na...@fast.au.fujitsu.com > fastware.com.au > > > > > -Original Message- > From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Sent: Friday, 8 June 2018 4:30 AM > To: Joshua D. Drake ;

Re: Service pgpool

2018-06-08 Thread Jean Claude
Hi all, How I can resolved the error about the pgpool daemon? any idea? Jun 08 05:23:05 -pgpool02 pgpool[1400]: [5-1] 2018-06-08 05:23:05: pid 1400: LOG: setting the local watchdog node name to "- pgpool02.adm.cacc.ch:5432 Linux -pgpool02" Jun 08 05:23:05 -pgpool02 pgpool[1400]: [6-1] 2018-06-08

Service pgpool

2018-06-07 Thread Jean Claude
Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state. Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed. Can you help me? Than