Ujjwal's Blog: postgresql

provide-free-support Ujjwal's Blog: postgresql

Showing posts with label postgresql. Show all posts

Showing posts with label postgresql. Show all posts

Wednesday, June 26, 2013

Best Way to Export billions of rows from Oracle, DB2, MSSQL, MySQL, Teradata, Netezza, Sybase, PostgreSQL

Hi All.

The best way to export large volume of data from Oracle (or any other databases) to CSV is by DBCrane (http://www.bronzeage.us/downloads.html). Toad is not designed for large data volume. DBCrane is also many times faster than sqlplus/spool or utl_file and it doesn't require any coding. We use DBCrane to export billions of rows from Oracle, SQL server and Netezza into delimited files and the process is done in less than one hour.

I tried Util_File package but it failed, then i tried CSV Exporter library for Java, but it failed as well. But DBCrane did this job well.

Cheers,

Ujjwal Soni

Saturday, June 9, 2012

Killing idle sessions in Postgresql

Recently, i faced an issue with Postgresql with one table where it got locked due to some reason. I followed below steps to unlock it ::

1) connect to Postgresql using below command

ssh -L 5432:127.0.0.1:5432 DEMO@server.com

2) Find idle processes using below command

ps -ef | grep postgres

Identify the process and note its id

3) connect to database using PG Admin tool

Fire below command from sql window

pg_cancel_backend(‘procpid’)

Thanks,

Ujjwal Soni

Subscribe to: Posts (Atom)

best-it-exam- | for-our-work- | hottst-on-sale- | it-sale- | tast-dumps-us- | test-king-number- | pass-do-it- | just-do-it- | pass-with-us- | passresults-everything- | passtutor-our-dumps- | realtests-us-exam- | latest-update-source-for- | cbtnuggets-sale-exam | experts-revised-exam | certguide-sale-exam | test4-sale-exam | get-well-prepared- | certkiller-sale-exam | buy-discount-dumps | how-to-get-prepared-for-the | in-an-easy-way | brain-dumps-sale | with-pass-exam-guarantee | accurate-study-material | at-first-try | 100%-successful-rate | get-certification-easily | material-provider-exam | real-exam-practice | with-pass-score-guarantee | certification-material-provider | for-certification-professionals | get-your-certification-successfully | 100%-Pass-Rate | in-pdf-file | practice-exam-for | it-study-guides | study-material-sku | study-guide-pdf | prep-guide-demo | certification-material-id | actual-tests-demo | brain-demos-test | best-pdf-download | our-certification-material | best-practice-test | leading-provider-on | this-course-is-about | the-most-reliable | high-pass-rate-of | high-pass-rate-demo | recenty-updated-key | only-for-students-free-download | courseware-plus-kit-for | accurate-answers-of | the-most-reliable-id | provide-training-for | welcome-to-buy | material-for-success-pass | provide-free-support | best-book-for-pass | accuracy-of-the-answers | pass-guarantee-id | pass-exam-key | pass-sku-id | study-for-exid | pdf-sku-exid | sku-pdf-id | pdf-demo-key | exam-demo-ske | pass-it-dump |

http://www.menuiserie-dauvergne.com/ | http://www.menuiserie-dauvergne.com/ |