Skip to main content

Posts

Showing posts from April, 2012

EDBLDR

Hi, Here are the steps how to use EnterpriseDB EDBLDR. Step 1: Create Control file like in Oracle using "sqlldr" [enterprisedb@localhost bin]$ more csv.ctl LOAD DATA INFILE '/tmp/test1.csv' BADFILE '/tmp/test.bad' DISCARDFILE '/tmp/test.dsc' INSERT INTO TABLE test FIELDS TERMINATED BY "," (t date) Step 2: Create/Generate CSV Files like as below [enterprisedb@localhost bin]$ more /tmp/test1.csv "10-10-10 10:10:10" Step 3: Create the required table structure. In this example, we have taken only one column with the table name called test(t timestamp). CREATE TABLE TEST(T timestamp); Step 4: Execute the EDBLDR as using the below command. [enterprisedb@localhost bin]$ ./edbldr -d edb -p 5444 userid=enterprisedb/adminedb control=csv.ctl NOTICE: the specified DATE mask (dd-mm-yy hh:mi:ssAM) will be ignored by the server EDB*Loader: Copyright (c) 2007, 2008 EnterpriseDB. Successfully loaded (1) records --Dinesh

FATAL localListenThread: "select "".cleanupNodelock();

Hi , Today i have faced this issue while configuring the Slony on Ubuntu.. FATAL localListenThread: "select "".cleanupNodelock(); insert into "_rep".sl_nodelock values ( 1, 0, "pg_catalog".pg_backend_pid()); " - ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey" DETAIL: Key (nl_nodeid, nl_conncnt)=(1, 0) already exists After analyzing this "cleanupnodelock" function, slon deamon could not able to delete this entry from the table due to some reasons. Find the below entry . master=# select * from _rep.sl_nodelock; nl_nodeid | nl_conncnt | nl_backendpid -----------+------------+--------------- 1 | 0 | 22988 So, i have removed it manually and started the deamons successfully... master=# delete from _rep.sl_nodelock ; DELETE 1 However, it works for me successfully. And my primary and slave are in sync after this hack ..:) --Dinesh

RMTK

Hi , Here are the steps how to set the runmtk tool kit steps. How to Migrate Oracle Sample Data using RunMTK ++++++++++++++++++++++++++++++++++++++++++++++ Step 1: ------- -bash-3.2$ pwd /opt/PostgresPlus/9.1AS/etc -bash-3.2$ vi toolkit.properties SRC_DB_URL=jdbc:oracle:thin:@localhost:1521:DELTA SRC_DB_USER=ar_test SRC_DB_PASSWORD=ar_test TARGET_DB_URL=jdbc:edb://localhost:5465/edb TARGET_DB_USER=enterprisedb TARGET_DB_PASSWORD=adminedb Step 2: ------- Start the Oracle Listner Listner.ora +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DELTA = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) ) SID_LIST_DELTA = (SID_LIST = (SID_DESC= (SID_NAME=DELTA) (ORACLE_HOME=/u01/app/oracle/product/11.2.0) ) ) +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -bash-3