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.2$ lsnrctl start

LSNRCTL for Linux: Versi…